This article will show you how to use the Data Validation feature to validate product No., product number, production date, and registration date, thus realizing the intelligent automation of product registration.
When to Validate Product Information?
In the case of product registration, you may need to validate product information, such as product No., product number, registration date, production date, and so on. In this scenario, you can apply Validations on form submission to validate whether the production information is recorded correctly, thus regulating the registration process.
What Does It Look Like?
1. Add a condition in Validations on submission: If product No. is not a five-digit number, you cannot submit records. The effect of the validations on product No. is as follows:
2. Add a condition in Validations on submission: If the product number is not within 1 – 9999, you cannot submit records. The effect of the validations on the product number is as follows:
3. Add a condition in Validations on submission: When the product exceeds the shelf life of 180 days, you cannot submit records. The effect of the validations on the production date is as follows:
4. Add a condition in Validations on submission: When the registration date is not the current day, you cannot submit records. The effect of the validations on the registration date is as follows:
How to Set the Validation?
In the Product Registration form, you can only submit records when the product information meets the following validation conditions:
1. Customize the product No., and the product No. should be a five-digit number.
2. The product number should be within the range of 1 to 9999.
3. The registered products should be within a shelf life of 180 days.
4. The registration date must be the current day.
Step 1 Designing a Form
When creating a Product Registration form, you can set fields as follows:
Field Name | Field Type |
Product Name | Single Line |
Product No. | Number |
Product Number | Number |
Production Date | Date&Time |
Registration Date | Date&Time |
Step 2 Validation on Product No.
Go to Form Properties > On Form Submission > Data Validation, and click 
to add conditions. On the Validations on submission page, enter Enter a five-digit valid number. for the prompt text, and set the formula as follows:
LEN(Product No.)==5
Step 3 Validation of Product Number
Click again. On the Validations on submission page, enter The number should be within the range of 1 to 9999. for the prompt text, and set the formula as follows:
AND(Product Number>=1,Product Number<=9999)
Step 4 Validation on Production Date
Click Add Condition again. On the Validations on submission page, enter Register the products within the shelf life. for the prompt text, and set the formula as follows:
DAYS(TODAY(),Production Date)<180
Step 5 Validation on Registration Date
As the TODAY function contains six parameters of year, month, day, hour, minute, and second, and the default format of the date and time field is YYYY-MM-DD, there are two methods for setting the validation conditions.
1. Directly validate with the TODAY function.
a. Click the Registration Date field, go to Field Properties > Type, and select YYYY-MM-DD HH:MM:SS.
b. Go to Form Properties > On Form Submission > Data Validation, and click to add conditions. On the Validations on submission page, enter The registration date must be the current day. for the prompt text, and set the formula as follows:
Registration Date==TODAY()
2. Comprehensive validation based on the TODAY function.
Click Add Condition again. On the Validations on submission page, enter The registration date must be the current day. for the prompt text, and set the formula as follows:
Registration Date==TIMESTAMP(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())))
I have finished reading. 🏆
👉I can't wait to VALIDATE PRODUCT INFORMATION.
👉I need more HELP in Discord Forum.