One of the major advantages of using Airtable over a spreadsheet program is the ability to easily link records of related data. This powerful feature is exceptionally helpful where data spans more than two tables. For example, if you had a "Contacts" table and a "Companies" table, you could create a field that links each contact to the company they work for.
In the example above, clicking on the record for Lenore Maxwell would show us all of her information from the Contacts table, such as her picture and telephone number, and a preview of information about the New York Times from the Companies table.
Linking Existing Tables of Related Records
Learn how to link tables of related information below by watching the video demonstration below.
When matching existing values, note that any commas included should be wrapped in double quotation marks to prevent commas acting as a separator. For example, the value “Chicago, IL” would create two separate entries – ‘Chicago’ and ‘IL’ if quotation marks were not included.
Creating a New Linked Table
Learn how to create a linked table from scratch and populate it with information from linked records.
Creating Multiple Links Between Tables
You can constrain record links so that you can link to one or multiple records in the other table. In the video below, we provide an example of linking multiple columns in one table to the same linked table.