Hi everyone!
I am having the following problem with data validation in a field of a Form in Appsheet.
My idea is to validate if the form can be completed by verifying that certain fields are complete, for that create a button at the end of the form with 2 options (Completed, Not Completed), since if I put the fields that should not be blank as mandatory the user could not advance in the form.
For this, I have tried to use these formulas:
Comp_Gen_1_Score <> "",
NOT BLANK (Comp_Gen_1_Score)
OFF(BLANK(Comp_Gen_1_Score))
Some were also grouped in an AND()
But nothing seems to work, any idea how I could fix it?
Column names should be used with square brackets.
Also, I suggest you have a look on syntax of blank/not blank operators:
https://help.appsheet.com/en/articles/2357266-isblank
https://help.appsheet.com/en/articles/2357267-isnotblank
For your remark about field being "required", you may want to use this option:
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |