validation form entry

AppSheet AppSheet Q&A
1

i want when i type a name in a field to validate it by loocking if it’s already exist or no in my table if it exist it warn me by text , if anyone got the formula for this validation

2

Hiya, try something like this?

COUNT(SELECT(TableName[ColumnName],[ColumnName]=[_THIS]))<2

1 Like
3

didn’t work brother

4

This expression works for me :

ISBLANK(FILTER(“table name”, ([column name] = [_THIS])) - LIST([_THIS]))