Stop user from saving depending on value selection

[Chris_Bean1]

Hi folks

I'm working on a compliance app and I want the app to stop a user from being allowed to save a form if for example they select 'yes' on a certain column. I have put a 'show if' column after the relevant column saying 'do not proceed!', but the app will still allow them to save. Is there a way to stop this, ie when they hit save there is a message saying 'value 'yes' not valid'. 

This would ideally work just like the error message you get when a required field is not populated. 

As always, I've spent some time hunting around on here, to no avail

Thanks in advance

Chris

[dbaum · Accepted solution]

Use the column's Valid if property. You can even specify the message to display if a column's value isn't valid. See an explanation in the Check form input validity (Valid_If) - AppSheet Help article.

[dbaum · Accepted solution]

Use the column's Valid if property. You can even specify the message to display if a column's value isn't valid. See an explanation in the Check form input validity (Valid_If) - AppSheet Help article.

[Joseph_Seddik · Accepted solution]

You have a Valid if column constraint.

[Chris_Bean1]

Ok - I put [_THIS]="false" in the validif and it worked, thank you! 

Chris