Problem with data validation

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?

0 1 181
1 REPLY 1

Aurelien
Google Developer Expert
Google Developer Expert

Hi @Rodrigo_Albin 

 

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:

 

Aurelien_0-1650892689445.png

 

Top Labels in this Space