Stop user from saving depending on value selection

AppSheet AppSheet Q&A
,
1

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

2

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.

1 Like
3

You have a Valid if column constraint.

1 Like
4

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

Chris

1 Like