Creating links between tables

Who can use this feature?

👤  Available on All plans

Create links between tables, to enable you to share data across tables and datasources.

Create Links in Airtable base

  1. Click  Manage fields and data
  2. Go to the table you would like to set the link.

This will open the Fields Settings for your table.

  1. Click Fields.
  2. Click Add field and select Automatic Link.
  3. Enter a field name (we suggest choosing a name that accurately reflects the information the data is linking, e.g. 'Link to Client')
  4. Select a table you want to create the link to.
  5. Select which fields you want to link. Please note: in order for the linking to work, the values in those fields must match exactly.
  6. Select the relationship type.
  7. Once saved, you will see the new field in the field list. The link is also visible in the table you've linked to - though it is not editable from this side.
linked_fields.gif

In our Property app, we have created a link between our Sales table and our Team table. We want to assign each team member to sales.

Screenshot_2022-07-15_at_15.13.09.png

We can now select names from the Team table to link to our Sales table.

Screenshot_2022-07-15_at_15.08.11.png

You can use this to link between different Airtable bases or even different data sources. In order for the linking to work, the values in those fields must match exactly.

To delete the field, click on the field this should show the setup where you can press the delete button

Related articles

How-to guides  

Syncing Schema and Data

Creating lookups and rollups between tables

Enabling Tables and Fields

Importing data into Stacker