How to check if 1 Product SKU (not key column) already exist in Table

AppSheet AppSheet Q&A
1

Hi community, I have a question about how to add a formula for Valid If in data validity to check if that product SKU already exist (not key column), If yes, an Invalid value error will appear and not allow me to add new data. If not, so let me add a new row.

By the way, it still allows me to edit that row if necessary.

Thanks

2

ISBLANK(FILTER(“tableName”, [SKU] = [_ThisRow].[SKU]) - LIST([_ThisRow]))

3

It does not check whether does SKU already exist or not

4

Try Then Tell

1 Like
5

Appreciate it, thanks, the expression after works correctly.

1 Like