Schema

Introduction

Users working with sheets that share the same underlying structure or "schema" (same column names, types and validation rules) can define this structure upfront in the schema settings page.

Defining a schema makes Tablomat apply the indicated column settings whenever it loads a file and encounters a column with the same name, helping users skip column configuration and proceed straight ahead with data browsing and editing.

Usage

Schema settings can be accessed by clicking the ellipsis icon () at the right side of the toolbar, choosing "Settings" and finally clicking "Schema" in the left-hand sidebar.

A screenshot of the page is shown below ...

A screenshot of the Schema settings page

You can add any number of columns, types and validation rules here (Validation is covered in a separate section of this docs).

Tablomat ships with a number of schema declarations (mostly targeting the Shopify product catalog CSV format). You are free to edit these declarations as you wish.