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

(Abu Md. Moniruzjaman) #1

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 López) #2

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) #3

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

(Tony Fader) #4

Aleksi’s approach or this one would work https://www.appsheet.com/samples/Only-allow-values-that-havent-been-chosen-in-dropdown?appGuidString=0fff1325-90cd-4259-814f-91bafe271f55