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…
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
Or you can mark that column as a key column and it will do that automatically.
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