Advanced Validations

Validations help you to ensure that data is in the format you want them to be in. A tooltip will be shown for invalid data and you can ensure that errors get resolved before data gets submitted.

Validations

Range

Validates that field's values for Number and Double columns fall within a min and max values. Either min, max or both must be defined. Values are inclusive.

Name
Value
Is Required

validate

range

min

max

errorMessage

Length

Validates that field's value for String column falls within min and max number of characters.

Either min, max or both must be defined. Values are inclusive.

Name
Value
Is Required

validate

length

min

max

errorMessage

Unique Across Multiple Fields

Validate uniqueness across multiple fields. To use it, place a unique_with validation on each field that you want to be part of the uniqueness validation, all sharing the same uniqueKey.

Name
Value
Is Required

validate

unique_with

uniqueKey

errorMessage

Here is an example set of fields using unique_with validations used to validate that the combination of department code and employee Id fields are unique.

[
  {
    "key": "Department Code",
    "name": "Department Code",
    "type": "String",
    "validations": [
      {
        "validate": "unique_with",
        "uniqueKey": "Employee No"
      }
    ]
  },
  {
    "key": "Employee Id",
    "name": "Employee Id",
    "type": "Number",
    "validations": [
      {
        "validate": "unique_with",
        "uniqueKey": "Employee No"
      }
    ]
  }
]

Here is the example of unique_with validation in action,

Adding Validations

From Platform

  1. Click on Validations while adding column or click on Edit to edit the column.

  2. Assign validations as needed,

From Code

Last updated