- 25 Jan 2023
- 4 Minutes to read
Glossary of Airtable terminology
- Updated on 25 Jan 2023
- 4 Minutes to read
We'll be adding to and improving this article over time. The glossary shared here will likely never be fully comprehensive, but it's meant to give you some fundamental definitions of terms you'll come across with using Airtable.
|Term or phrase||Definition|
A centralized set of tools to help admins manage their organization’s Enterprise account. It's a designated surface that includes ways for admins to view and manage users, groups, reports, bases, and more. It is not visible or available to non-admins.
An app is software built within Airtable that's designed to structure, automate, and scale workflows and processes. An app consists of three layers: data, logic, and interface.
Airtable automations always include a trigger and one or more actions. Triggers and actions can be native to Airtable or integrated with other popular software applications. Automations are a useful feature for reducing repetitive and/or tedious tasks associated with your work.
A base is a collection of data in Airtable, designed to contain all of the information related to a project or workflow. Bases can have multiple tables, each containing data. Within each table, there are records with data for each record stored in fields.
For self-serve paid plans, any collaborator with a permission level of Commenter, Editor, Creator, or Owner is classified as a billable collaborator. Workspace owners on a paid plan are charged for the total number of billable collaborators added to the workspace. Billing is calculated differently for Enterprise services.
Elements are the essential building blocks of interfaces; builders can add visual elements like grids and timelines, design elements like text and dividers, and functional elements like buttons and comments, to present their base data in a new way.
One of 3 paid plans on Airtable. Users must contact Sales in order to sign up for an Enterprise plan, and exact pricing is customized depending on the services chosen.
Extensions are modular components that add visuals or functionality to a base. Users can create custom extensions, or they can use extensions created by Airtable or other open source extensions.
A field is a vertical column in a table. It contains the details or data for each record in the table.
A field type specifies the kind or format of data stored in a given field — for example, long text, date, multiple select, or attachment. Users can customize most field types within their base.
Formula fields allow you to output numbers, dates, strings, and more in each record based on static or dynamic information from other cells in that same record. For example, if you have a table of product orders, you can create a formula field that computes the Total Cost for each record based on the Price and Quantity fields in each record. Calculations are performed in as close to real-time as possible. This means that as cell values are updated in fields referenced by formula fields, they will automatically recompute based on the updated information.
Interface Designer is the tool that lets builders create visual interfaces powered by base data for end users.
Permissions have to do with the level of access that a user has to one or more bases within a workspace. There is a spectrum of permissions ranging from read-only access to ownership. Additionally, access can be granted broadly for a whole workspace (the user will have at least their set permission level in all bases in that workspace) or, more granularly, to an individual base. Interface permissions are covered separately here.
One of 3 paid plans on Airtable. The Plus plan is the least expensive paid plan (per billable collaborator), with the most limited functionality.
The primary field is always the first column, or field, in any table. It represents a description of each record in the table and cannot be deleted, moved, or hidden. The primary field is used as a brief description of a record in other parts of the UI.
One of 3 paid plans on Airtable. The Pro plan is more expensive than the Plus plan but less expensive than the Enterprise plan (per billable collaborator).
A record is an individual item in a table. Records are the basic unit of data that are pulled into various views and interfaces. Each record can include data in multiple fields.
A table holds information about one type of item — for example, products, projects, tasks, campaigns. Each base needs at least one table. Individual tables appear as their own tabs in a base.
A view is a particular way to look at and organize the underlying data in a table. The default type of view is a grid, but other types include form, calendar, gallery, and Kanban. A given table can have multiple views (and multiple types of views). Views can also be configured based on permissions, with collaborative, personal, and locked views.
A workspace is a collection of bases shared between a group of workspace collaborators. It is the primary billing unit for paid plans on Airtable.