Tables

Tables are where your structured data lives in Information Hub. Each table stores data in rows and columns, much like a spreadsheet - but with defined column types that keep your data consistent and reliable.

The tables page

What tables are used for

Every project can have multiple tables. Tables are the backbone of your project's data:

• Forms collect data and write it directly into tables.

• Dashboards visualise data stored in tables.

• Apps can read from and write to tables.

Column data types

Each column in a table has a data type that controls what values it can hold:

Data Type	Description
Text	Free text of any length
Integer	Whole numbers
Double Precision	Decimal numbers (high precision)
Real	Decimal numbers (standard precision)
Yes/No	Boolean true/false values
File	Reference to a file in project storage
Dropdown	Select from a predefined list of options
Foreign Key	Reference to a row in another table
Lookup	References a specific column in another table - similar to a foreign key but with a search interface for finding the linked value
JSON	Stores structured JSON data within a single cell
Tabular	Stores multiple rows of structured data within a single cell

Every table also has a primary key column. By default this is an auto-incrementing integer called id that uniquely identifies each row. If you need human-readable IDs (such as SP-1 or OBS-42) you can use a key generator on the primary key column instead - see Key generators below.

Key generators

A key generator is a template-based pattern for auto-generating column values. Use them for serial numbers, sample IDs, specimen codes, or any value that should follow a consistent format. For example, a template of SP-{autoincrement} would produce SP-1, SP-2, SP-3, and so on.

Key generators produce string values. If your template includes literal text (for example SP-{autoincrement}), the primary key column type must be Text, not Integer. Open Edit Column on the primary key column and change its type to Text before assigning the generator.

Key generators are managed from the table's Settings page. You can assign a key generator to a column when adding or editing that column.

In this section

Create a TableImport DataView and Edit DataExport DataAnalyse Data