Put condition in spreadsheet

 
1
0
-1

Hi everyone,

I want to put condition or restriction in my spreadsheet.
First column, user can insert maximum 10 digits. Less is acceptable.
Second column,  user must insert 14 digits and 1 alphabet. Cannot less or more.

If either one is incorrect system will show error. Thank you!

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      You can use the "Form Builder > Spreadsheet > Properties > Row > Regex Validation" property field to define your input rules. See https://www.sitepoint.com/learn-regex/ .

        CommentAdd your comment...