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 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. ![]()
Again, again and again
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 ![]()

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.