Is there a way to customize this error notice?

Is there a way to customize this error notice?
3X_0_b_0bc857777de5899cf57c32713acc99dbd5e5c43f.png

1 4 294
4 REPLIES 4

GreenFlux
Participant V

3X_4_d_4d90cd618f3eee6c6ecab0061cf0dd0b39c41b78.png

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โ€)

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โ€

Great. Thanks. Iโ€™ll try it outโ€ฆ

Top Labels in this Space