Note:
The alert message in 'on submit' will be invoked only in the presence of a 'cancel submit'. In the absence of form cancellation, the alert message is bypassed by Zoho Creator.
The cancel submit deluge statement is used in the Form Action - Validate block to stop a form from being submitted.
on submit { // specify validation code { // specify alert message if not valid and cancel the submission alert "age should be between 20 to 100"; cancel submit; }
| |
Note:
The alert message in 'on submit' will be invoked only in the presence of a 'cancel submit'. In the absence of form cancellation, the alert message is bypassed by Zoho Creator. |
Examples - Free flow Scripting
1. Alerts the message specified in quotes and cancels submission, if the value entered in the age field is not between 20 and 100.
Age ( type = number ) on submit { if (input.Age < 20) && (input.Age >100) { alert "age should be between 20 to 100"; cancel submit; } }
2. The code snippet given below fetches the data corresponding to the particular position applied by the applicant and checks if the Status for that position is currently closed and displays an error message to the user. You can access all the details related to that position by accessing the variable “opening”.
on submit { opening = New_Opening [Position_Name == input.Applied_For]; if (opening.Status == “Closed”) { alert “The job profile ” + this.Applied_For + ” for which you have applied is not currently open “; cancel submit; } }
Let us built a Validate action script using Script Builder for the SampleForm1. Click here, to view the SampleForm1. The script will validate the Contact Address field in the SampleForm1. If the Amount is greater than 1000, the Contact Address is mandatory. In other words, if the ContactAddress is not specified for amounts greater than 1000, the form data will not be submitted.
1. Add Validate form action : Click on the Script Tab to display the Script Editor. Select the Form Action On Add -> On Validate as highlighted in the screen-shot below.
a. Drag and drop the If control flow statement, as highlighted in the screen-shot below. Click on Edit to specify the If condition. Refer the If, else if, else topic, for more information on the syntax and usage.
b. The Edit dialog for If is displayed as shown below, wherein you have to create the If condition.
Click on the Amount field from the list of Input fields. The text input.Amout will be added to the text area as highlighted below.
Select the > operator from the list of operators and specify the value as 1000. Now, the first condition (input.Amount >1000) in the If statement is added.
Double-click on the ContactAddress field from the list of Input fields. The text input.ContactAddress will be added to the text area below.
Select the == operator and specify a blank text in double quotes. You can do this, by selecting the
icon from the operator list.
Since the If statement must satisfy both the conditions, they must be joined by an "AND" operator. To do this, place the cursor inbetween the two conditions and select the && operator from the list of operators.
c. Click Done to add the If condition to the script editor as show below.
3. Add Alert message: Now, we have to add the If statements to be executed, when the If condition is satisfied. In our example, if the Amount is greater than 1000 and if the ContactAddress is not specified, an alert message will be displayed and the form submission will be cancelled.
To add an alert message, drag and drop the Alert keyword to the editor area.
Click on Edit to specify the Text to be displayed.
The text must be specified within double quotes. Click Done to add it to the script editor.
4. Add Cancel Submit: To cancel submission,
Drag and drop Cancel submit to the script editor area and place it after the alert message.
5. Click Save Script to add the On validate script action to the form definition.
6. To view the complete script, select Form Definition -> With Action or select Free-flow Scripting. The validate action script is successfully added to the form definition, as shown below.
When the form data is submitted, if the Amount is greater than 1000 and the ContactAddress is not specified, the alert message is displayed and the form is not submitted, as shown below.
