Is there a way to customize this error notice?

Is there a way to customize this error notice?
image

1 Like

Screen Shot 2020-06-18 at 7.47.05 AM

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.

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…