Is there a way to customize this error notice?
1 Like
In the column settings, DATA VALIDITY>Invalid value error
If you put a “string” then that value will ALWAYS show, regardless of the real reason the value is invalid.
So make sure if there is more than one reason, that you use an expression to test the input and show the right error.
IFS(> CONDITION1, “Error 1”,> CONDITION2, “Error 2”,> TRUE, “Other Error”)
3 Likes
Thanks @GreenFlux for the tip. How would I structure it to detect a “row already there” error?
You have to get the list of keys for all other rows, and make sure the current key is not in that list.
[Valid If - What formula to use to only allow unique values](https://community.appsheet.com/t/valid-if-what-formula-to-use-to-only-allow-unique-values/12995/4) Questions
Hi @Tom_Graham, If I have correctly understood your requirement ,could you try following expression in your SKU field’s valid_if expression NOT(IN([_THIS], SELECT(Inventory Data[SKU], NOT(IN([Custom Label], LIST([_THISROW].[Custom Label])))))) The above expression assumes that [Custom Label] is key field and ]SKU]is the non key field that you do not wish to be duplicated.
If it is, that would be one of the conditions in the Valid_If_Error formula:
CONDITION1, “Error: Value already in use”
2 Likes
Great. Thanks. I’ll try it out…