What is the validation rule to use?
Validation Rules | Description/Usage |
hidden | Will hide a field/column from the form |
Why use this validation rule?
With this validation rule, you will be able to:
Hide fields/columns from the forms that you can still refer to through formulas, limit comparing, etc.
How to use this validation rule?
As a FIELD
Using columns A, B and C in the Excel spreadsheet, you can create a field.
Column A will be used for the TITLE
The title will be displayed to add a description regarding your input
Column B will be used for the KEYWORD
The keyword defines what the field will be used for
Column C will be used for the VALIDATION RULE(S)
Optionally, you can add the validation rules to:
specify a limit
add formulas
automate a targeted field, such as making it display a certain value
change the state of a field
As a COLUMN
Using three consecutive rows (or as we refer to it, 123) in the Excel spreadsheet, you can create a column.
Row 1 will be used for the TITLE
The title will be displayed to add a description regarding your input
Row 2 will be used for the KEYWORD
The keyword defines what the column will be used for
Row 3 will be used for the VALIDATION RULE(S)
Optionally, you can add the validation rules to:
specify a limit
add formulas
automate a targeted column, such as making it display a certain value
change the state of a column