Validations on Form Submission
Introduction
Feature(s)
Validations on form submission is used to validate whether the data entered by members meet certain conditions for submitting the form.
Application Scenario(s)
It can be used in scenarios where the contents of forms need to be validated. For example, you need to validate applicants' phone numbers in activity registration forms, validate the serial number of products in product management, and to validate ID numbers in employee information.
Preview
Here is an example of validating the serial number of products. The serial number of products is set as five digits. Members cannot submit data if the entered data do not meet this condition.
Setting Procedure
Where to Set
1. Go to Design > Form Properties > Validations on form submission, and click Add Condition.
2. If there are multiple conditions in one form, you can sort them out through dragging and dropping.
Setting Prompt for Failed Check
The system will show you a prompt if the entered value does not meet certain validation conditions.
Setting Formula(s)
The formula in Validations on form submission is the validation condition. Data can only be submitted when it meets the condition. So you need to set a proper formula, otherwise, members cannot submit the form successfully.
There are two ways to add fields in the formula:
- Select fields under Variables in the lower-left corner of the Formula page.
- Click Copy Formula in the upper-right corner of the Formula page and paste the formula into the formula editing area. The formulas can be copied and pasted among the following features:
- Formulas set in form fields.
- Formulas set in Validations on Form Submission.
- Formulas set in Batch Edit for forms.
- Formulas set in node validation.
- Formulas set in Calculated Fields in the dashboards.
- Formulas set in Calculated Fields in the data factory.
- Formulas set in Measure in aggregate tables.
- Formulas set in Validations on source form submission in aggregate tables.
Note:
1. You can only copy formulas through Copy Formula. Manually entering field names or directly pasting from other locations does not work.
2. Right-clicking with the mouse or using keyboard shortcuts is not supported for copying or cutting formulas in Safari and UC browsers.
Operator Symbols
Common operator symbols are shown below. For details about how to use formulas, see Formula.
Name | Greater than | Less than | Equal to | Not equal to | Greater than or equal to | Less than or equal to |
Expression | > | < | == | != | >= | <= |
Note(s)
1. Regular forms can be set validations on form submission in Form Properties.
2. After a workflow is enabled, you cannot configure validations on form submission in Form Properties. Instead, you need to set validation conditions of nodes in Workflow > Node Properties > Advanced > Data to Be Submitted. For details, see Node Validation.