Tablomat
  • Introduction
  • Learn
    • Getting Started
    • Column Types
      • Text and Number
      • List
      • Files
      • Boolean
      • Single Select
      • Rich Text (HTML)
    • Uploading Images
    • Schema
    • Validation
    • Advanced Navigation
      • Views
      • Quick Filters
    • Advanced Editing
  • Other Resources
    • Features
    • Comparison with Excel
    • Keyboard Shortcuts
    • Mouse Shortcuts
Powered by GitBook
On this page
  1. Learn

Validation

PreviousSchemaNextAdvanced Navigation

Last updated 2 years ago

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 ...

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)

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