# Advanced Validations ## 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`	true
`min`		false
`max`		false
`errorMessage`		false

#### 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`	true
`min`		false
`max`		false
`errorMessage`		false

#### 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`	true
`uniqueKey`		false
`errorMessage`		false

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.

2. Assign validations as needed,

### From Code You can check the advanced validations sections in react( [#advanced-validations](https://docs.impler.io/importer/react-embed#advanced-validations "mention")), angular [#advanced-validations](https://docs.impler.io/importer/angular-embed#advanced-validations "mention")) and javascript ([#advanced-validations](https://docs.impler.io/importer/html-js-embed#advanced-validations "mention")) *** If you have any questions, suggestions, or comments. Feel free to reach out to us over [**Discord**](https://discord.impler.io). We’re constantly improving to deliver the best Data Importer for your product, and we value your input.