Hello,
I have just come across a situation where if I am adding a row to a table from a form view and I only have some of my data set columns selected in the Column Order portion of the view, Appsheet ignores the Require_if condition of the other columns in the data set that were not in the form. The row is able to be added to the dataset without error even though those other columns have no value.
If, however, I include those same columns in the form, then Appsheet does respect their Require_if requirements and won't allow me to add a row until those columns have values.
Can someone help me understand this behavior? What is the point of data validation if rows can be added anyway?
Thanks!
Solved! Go to Solution.
This is a normal behavior. Otherwise the app user would never be able to fill the record. If you want to do this, you should have a a proper formula in the Valid_If in some of those columns that are never hidden. Then the user would not be able to save the record and you could explain it with the warning message.
User | Count |
---|---|
17 | |
12 | |
9 | |
4 | |
4 |