Glossary of Airtable terminology
  • 25 Jan 2023
  • 4 Minutes to read
  • Dark
    Light

Glossary of Airtable terminology

  • Dark
    Light

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 phraseDefinition
Admin Panel

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.


App

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.


Automations

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.


Bases

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.


Billable collaborators

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

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.


Enterprise

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

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.

Field

A field is a vertical column in a table. It contains the details or data for each record in the table.


Field type

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 field

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

Interface Designer is the tool that lets builders create visual interfaces powered by base data for end users.


Permissions

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.


Plus

One of 3 paid plans on Airtable. The Plus plan is the least expensive paid plan (per billable collaborator), with the most limited functionality.


Primary field

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.


Pro

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).


Record

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.



Table

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.


View

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.


Workspace

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.



Was this article helpful?