Help!! How i can i avoid duplicate for a a s...

[Abu_Md_Moniruzj]

Help!!

How i can i avoid duplicate for a a specific column list?

Example- the column contain customer name, if any of the customer named form filled before, it will not be filled again? Do i need to make formulas for every customer or is the any expression which do it for all customers?

What will be tge expression!!

Thnx for helping…

[Fernando_Lopez1]

Check this section: Preventing Duplicate Field Values

Here: https://help.appsheet.com/expressions/expression-types/list-expressions-and-aggregates List Expressions and Aggregates help.appsheet.com

[Aleksi_Alkio]

Or you can mark that column as a key column and it will do that automatically.

[tony1]

Aleksi’s approach or this one would work https://www.appsheet.com/samples/Only-allow-values-that-havent-been-chosen-in-dropdown?appGuidString...