Category equal to value

I have two categories.

AJIO

KEY- 57575

SMART

KEY- 57575

I have similar keys of both. Because of which I am having trouble entering. I want that when I category wise duplicate function are work.

I don’t understand. :disappointed_face:

1 Like

Again, again and again :confounded_face: please post screenshots of your tables, columns, the expression you are using, the errors you might be getting.

It’s a pity that none of us is a fortune teller who can read your mind, or see your app through a crystal ball :roll_eyes:

could-be-fun-studio-cs.gif

2 Likes

I want my duplicate function to work category wise.

SCAN KEY

Category

58656

AJIO

THIS COLUMN SHOW DUPLICATE BUT THIS IS NOT DUPLICATE IN MY CASE

58656

SMART

SCAN KEY Category
58656 AJIO
58656 AJIO THIS COLUMN IS ACTUAL DUPLICATE VALUE

It seems you are trying to deal with a case of multi-column key.

https://help.appsheet.com/en/articles/1023086-what-is-a-key

will guide you to create your table key structure to handle it.

1 Like