Validation Block

Use the Validation block in the App Design to prevent or warn the end user from entering Invalid or Duplicate Inputs.

‍

Help Video

Editing The Block

Click on the Validation block. A Right Panel for editing appears on the right side. Start editing the fields from the Right Panel.

Description

Description is positioned below the coloured block which further explains to the end user about the Validation Message that appears before submitting the data. Description is an optional field.

Type of Validation

1. Duplicate

Duplicate Validation option allows the end user to enter unique data each time. The end user can input any data only once and cannot input the same data again.

Example‍

Condition: Phone Numbers must be unique and should not be repeated inputs

Select Type of Validation: Duplicate

Select Fields: Email

Select Validation Level: Error (Red Coloured Box)

Input Validation Message: Email already used! Use another

‍

This is how it will look to the end user during submission:

1. The end user enters the email ID as: “test@test.com” and submits. Here are the submission details:

‍

2. The end user while creating another submission enters the same email ID: “test@test.com”.

Now the Validation block appears with the Validation message, “Email already used! Use another” and blocks the submission of the data.

The desired condition is proved to be true. An email ID can only be entered once and hence Duplication of Data is prevented.

‍Select Fields‍

This field is visible only when Type of validation - Duplicate  is selected. This field allows the App Designer to choose an Input Block to check for Duplicate submissions when the end user inputs the data.

Considering the above example, the Phone Number block is the selected input block to check for Duplicate submissions and hence the end user will not be able to enter a phone number more than once.

Validation Level‍

Validation Level depends on whether or not the desired condition is met.‍

There are 3 levels of Validation: Error, Warning, Success

Error - Validation Message is displayed in a Red coloured box signifying error in the input data and the end user cannot submit the data since the submissions are blocked.‍

Warning - Validation Message is displayed in a Yellow coloured box signifying error in the input data and the end user can edit the input data & submit. Submissions are not blocked.‍

Success - Validation Message is displayed in a Green coloured box signifying no error and the end user can submit the data. Submissions are not blocked.‍‍‍

Validation Message

Validation Message appears when the desired condition becomes true.

Validation Message is editable and can be customized according to the user requirements.

‍

Validation and Bulk Upload/Bulk Edit

When you configure a Validation block in your app with the Duplicate option enabled, it does not only apply to manual submissions from App Home but also when an admin performs Bulk Uploads or Bulk Edits from the Submissions tab.

Here is how it works:

• If any row in the uploaded spreadsheet contains a duplicate value in the field(s) that are marked for Duplicate Validation, the system will detect the duplicate and reject that row.
  
  
• The rest of the rows that do not violate the Duplicate Validation will still be processed successfully. This means the entire bulk operation is not blocked — only the duplicate rows are skipped.
  
  
• Once the processing is complete, the admin can see the status screen that shows which rows succeeded and which rows failed.
  
  
• For failed rows, you can download the error spreadsheet from the status screen. This spreadsheet clearly specifies the reason for failure. In the case of Duplicate Validation, the error message will indicate that a duplicate value was found in the relevant field.
  
  
• To correct the issue, open the downloaded spreadsheet, fix or replace the duplicate value, and then re-upload it to process the rows again.
  
  

This ensures that the rules you configure with the Validation block are consistently enforced, whether data is entered manually or through bulk operations.

‍

‍

2. Custom Validation‍

Custom Validation option allows the end user to validate the inputs entered in the current submission.

Example

Condition: A User has to Rate an Outlet for the following factors on Rating Block:

Ease of Entry/Exit

Cleanliness

Staff Behaviour

‍

The Calculation & Logic Block Represents the Overall Rating Corresponding to the Appropriate Formula which calculates the Average of the Three Ratings.

‍

Formula

The Formula to calculate Average: Type @variable name to get the Variables

(@entry_access + @cleanliness + @staff_behaviour)/3

‍‍Custom Validation 1

If the Overall Rating turns out to be greater than or equal to 4 then the Validation Level selected is Green Coloured Box which is set to Display ‘Awesome’.

Select Type of Validation: Custom

Input Validation Condition: @overall_ra>=4 (@variable name should be typed and selected)

Select Validation Level: Success (Green Coloured Box)

Input Validation Message: Awesome

‍

This is how it will look to the end user during submission

Ratings:

Entry Access: 4

Cleanliness: 4

Staff Behaviour: 4

So the Average calculated will be 4 which is greater than or equal to 4.

The condition is true and Green Coloured Box with 'Awesome' is displayed.

‍Custom Validation 2

If the Overall Rating turns out to be greater than or equal to 3 and less than 4 then the Validation Level selected is Yellow Coloured Box and is set to Display ‘Average’.

Select Type of Validation: Custom

Input Validation Condition: AND(@overall_ra>=3, @overall_ra<4)(@variable name should be typed and selected)

Select Validation Level: Warning (Yellow Coloured Box)

Input Validation Message: Average

‍

This is how it will look to the end user during submission

Ratings:

Entry Access: 3

Cleanliness: 3

Staff Behaviour: 3

‍

So the Average calculated will be 3 which is greater than or equal to 3 and less than 4.

The condition is true and Yellow Coloured Box with 'Average Score' is displayed.

Custom Validation 3

If the Overall Rating turns out to be less than 3 then the Validation Level selected is Red Coloured Box and is set to Display ‘Poor’.

Select Type of Validation: Custom

Input Validation Condition: @overall_ra<3 (@variable name should be typed and selected)

Select Validation Level: Error (Red Coloured Box)

Input Validation Message: Poor

‍

This is how it will look to the end user during submission

Ratings:

Entry Access: 2

Cleanliness: 2

Staff Behaviour: 3

‍So the Average calculated will be 2.33 which is less than 3.

The condition is true and Red Coloured Box with 'Poor' is displayed.‍