On Add ->On Validate section in Deluge is used to write the Form validation scripts. You can check for field values and tell the user to enter the right value. This part is executed after user clicks on the Submit button and before adding the record to the database. This script will also work when you import data, add records via email and duplicate the records.
For example, if you want to confirm a user’s email address using two fields Enter your Email and Confirm your Email and give an error if emails do not match, you can use the On Add ->On Validate script section.
- See https://creator.zoho.com/sampleapps/script-actions/#Form:On_Validate and give different email addresses for the fields you see there and click on Submit.
- Access https://creator.zoho.com/sampleapps/script-actions/#View:On_Validate_View , click on Add and do the same.
After you click on Submit (with different data for emails), you will see the message as “Invalid Entries Found” and “Email Addresses do not match“.
Note that this is different from the default Zoho Creator Form validation. If you did not enter the value in an email format, Zoho Creator will give “Invalid Entries Found” error. Because, they are both email fields and Zoho Creator will look for an email value in there.
How is the Message displayed?
- if statement is used to compare emails.
- alert task is used to display custom message.
- cancel submit task is used to cancel the Form submission in case of failures.
How to reach the On Add ->On Validate section?
- Edit your application (by clicking on Edit this application link, or from the home page, click on the Edit link next to your application)
- Select your Form from the Forms tab.
- Next to the Form name, click on More Actions ->Script (On Add) ->Validate on Form Submit.
This will take you to the On Add ->On Validate section of your Form’s script. You can drag and drop the deluge tasks from the left side to write your business logic there.