Introduction

CloudTable is a database that behaves like a spreadsheet. You organize data into bases, each containing tables, and view that data through configurable views — grids, kanban boards, galleries, and calendars.

Core concepts

• Workspace — a shared container inside your organization. Bases live in workspaces.
• Base — a collection of related tables (like a single Airtable base or a database).
• Table — rows of records with typed fields (columns).
• Field — a typed column: text, number, date, single-select, attachment, formula, and many more.
• View — a saved way of looking at a table: filters, sorts, grouping, hidden fields, row color, and row height. A table can have many views (grid, kanban, gallery, calendar).
• Record (row) — one entry in a table. Each cell holds a value validated against its field’s type.

Fields at a glance

Fields fall into a few groups:

• Data you type — text, numbers, dates, select options, attachments, and so on. See Field types.
• Relationships — link records across tables.
• Computed — values derived automatically from other fields in the same row, read-only:
  • Formula — spreadsheet-style expressions, e.g. {Price} * {Qty}.
  • Template — string interpolation, e.g. Hi {{Name}}.
  • Code — sandboxed JavaScript per row.

Working programmatically

Everything you can do in the UI is available over the API:

• A REST API for reading and writing records, tables, and bases.
• An MCP server so AI clients can use your bases as tools.

See the REST & MCP API page.

Next steps

• Learn the field types.
• Add your first formula or code field.