Form validation rules automatically control the status for the work item and equipment that contain the form/checklist (table).
Validation rules can facilitate complex workflows, or simple verification that each row has been checked in a checklist.
Each table can have multiple validation rules consisting of required cells in columns, rows, individual cells, and use AND or OR logic.
You can add new validation rules in three ways.
- In the table edit window.
- Using Excel uploads.
- Copying existing validation rules to matching tables.
Add validation in the table edit window
Click the Open button for a table.
Click Add Validation. Note the operator - it can be used to define OR or AND groups.
When you select a column using this setup method, a validation group will be created for each row. To add validation rules using table rows or individual cells, use the Excel upload method with shortcodes (below)
In the following example, by selecting the Pass, Fail, and NA columns with the OR operator, when any of the 3 checkboxes are selected, the row will be "validated" and turn from red to green.
You can add as many validation groups as needed on any given form.
Add validation with Excel uploads
You can add validation rules to forms using shortcodes in uploaded Excel files. Take a look at the list of all shortcodes in this article.
Copy validation rules
You can copy existing validation rules to matching tables by clicking the Copy Validation button and following the prompts.
The tables being copied to must have the same dimensions (rows and columns) as the source table.