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: