What is the validation rule to use?
Validation Rules | Description/Usage |
copy X when X is modified | Will let you copy the value of field X into the field this rule is used in, whenever X is modified |
Why use this validation rule?
With this validation rule, you will be able to:
Copy the value of a targeted field/column into another field/column of the same type, possibly in read only, to replicate values elsewhere in your form, such as important information, product specification, etc.
Can copy the field/column value of a specific type into another field/column of the same type (i.g. text to text, num to num, CNCNA to CNCNA, etc.).
Can copy the field/column value of a specific type into a text field/column (i.g. num to text, date to text, CNCNA to text, etc.).
Signature, freesign, photo and video can not be copied to a text field.
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
Here is an example:
Here is how it displays in the application:
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
Here is an example:
Here is how it displays in the application: