This might happen if the required field is not shown - because AppSheet only enforces the required nature of a column when it’s shown.
- If your valid if formula would result in 0 options, the field disappears - which then removes the required state for that field.
There are a couple of solutions, but my favorite is the following:
- Apply the require formula on a different field, one that will always be shown.
- Sometimes I add another virtual column to the table, that’s a LongText type with a formula something like this:
“Make sure you fill all the fields”)
I would actually go into much more detail, providing exact instructions on why the field isn’t working - but you get the drift I hope.
You can then apply a valid if formula to your new “alert” column:
where if that column has any value, it will not let the user save - but as long as it’s blank (which means that all criteria and things are as they should be), then a user wouldn’t even know it was there.