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,

Checking uniqueness of Employee No using unique_with validation

Adding Validations

From Platform

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

   

   Mentioning Validations
2. Assign validations as needed,

   

   Assigning validations from web UI

From Code

You can check the advanced validations sections in react( Advanced Validations), angular Advanced Validations) and javascript (Advanced Validations)

---

If you have any questions, suggestions, or comments. Feel free to reach out to us over Discord. We’re constantly improving to deliver the best Data Importer for your product, and we value your input.