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.
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.
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
.
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.
Here is the example of unique_with
validation in action,
Adding Validations
From Platform
Click on
Validations
while adding column or click onEdit
to edit the column.Assign validations as needed,
From Code
Last updated