Hi Appsheet community,
I’m looking for a Valid if expression.
In a table I have a column Organisation.
Users can Add any organisation when they need to.
But when an organisation is already in the column, there should be an error message that says that the entry is invalid!
I tried:
Valid if:
NOT(
List[organisation]=[organisation]
)
But this is also not allowing the new entry.
Is there a syntax where you can allow the valid if to look to the list before you entered a new value?
Greetings,
Bram
Check the section “Preventing duplicate field values” from this article…
User | Count |
---|---|
43 | |
30 | |
27 | |
14 | |
14 |