Validation

Introduction

You can setup validation rules to flag any content errors within your sheets.

Usage

Validation rules can be configured per column in the Schema settings page. For example, if you setup the following column definition ...

then any cells under the "SKU" column and containing spaces will be flagged like below ...

Clicking the alert icon () will show a popup with more information on the validation error ...

This particular rule supports auto-correction so the error can be corrected automatically by clicking "Fix".

There are currently two built-in validation rules:

1. "No Spaces"; checks for and corrects spaces in input

2. "No Accents"; checks for and removes letter accents

3. "Lower Case"; checks that input is in lower case

4. "Title Case"; checks that input is in title case

Supported Column Types

Validation is currently limited to the following types:

1. Text

2. Single Select

3. Rich Text (HTML)