Is there a way to show a custom error message...

Steven_Aung · 05-15-2018 05:00 PM

Is there a way to show a custom error message for an invalid column?

pravse

I’m guessing you mean for a data validation error. No. One thing you could do is provide input guidance in the column description. Eg: column name: Price, column description: enter a value between $1 and $99

Charlie_Wells

You can always add a Show column right after the column in question, where you can display a message if the value entered is invalid. I do this several places in my app. Set the value for the content to show, and set ShowIf accordingly. Then use a format rule to display the content in red and bold - never fails to draw people’s attention :=)

Steven_Aung

Thanks for the suggestion.

Heino_Matthee

In the invalid value error message box you can put a nested IF like
IF([value] > 99, “too high”, IF([value] < 1, “too smal”), x) .

The x just satisfies the IF statement and will never be used if your valid_if constraint states that [value] needs to be between 1 and 99. (I never bothered to learn the IFS statement ^^) This post is old so I don’t know what changed in appsheet since then but this way you can have different error messages.

Jonathon

AppSheet added custom error functionality in September 2018:

LeventK

@Jonathon you’re da man!

pravse

@Jonathon thank you for answering so many questions and helping out so many others in the community!