What if I can’t write regular expression?
In
validation, we support checking users' input via regular expression. If you're not familiar with regular expression, you may apply
conditional formulas as a workaround. For example, if you would like to make sure the users input numbers between 1~99 in the "Qty" field:
You may follow the steps below:
Step 1. Create a free text field with conditional formulas to check if the values match your criteria
With above example, you can apply conditional formulas to chech if the values are within 1~99:
The formula means when the values are within 1~99, return "Yes". Otherwise, return "No".
Step 2. Apply validation on the field you created in step 1.
Apply validation "Yes" and add error message if necessary:
In the future, when users input numbers that don't match the criteria, the system will pop-up the error message upon saving:
