Airtable is a cloud-based no-code platform that blends spreadsheet flexibility with database power, enabling teams to organize, link, and automate workflows using bases, tables, views, and interfaces. Unlike traditional databases, Airtable offers visual views (grid, kanban, gallery, calendar, timeline, gantt) and rich field types (attachments, formulas, linked records, rollups), making complex relational data accessible without writing SQL or code. The key mental model: treat each base as a project workspace, each table within it as a category of records, and linked record fields as the relationships that connect everything — this architecture lets you build CRM systems, content calendars, inventory trackers, or project dashboards entirely through drag-and-drop configuration.
What This Cheat Sheet Covers
This topic spans 23 focused tables and 173 indexed concepts. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.
Table 1: Core Building Blocks
Airtable's three foundational layers — bases, tables, and fields — form the structural hierarchy of any workspace. A base is the top-level container for a project or workflow, housing multiple tables that store related data, while each field (column) defines the type and format of information captured in every record (row). Understanding this hierarchy is essential for designing scalable databases.
| Concept | Example | Description |
|---|---|---|
Project Management Hub | • Top-level workspace that groups related tables • functions as a complete database for a specific project or team | |
Tasks, People, Projects | • A collection of records organized in rows and columns within a base • similar to a spreadsheet tab but with relational database capabilities | |
Status, Due Date, Owner | • A column that defines the data type for all records in that column • equivalent to a database column | |
Single row in a table (e.g., Task #42) | • A single row representing one item, entry, or entity in a table • each record contains values across all defined fields |