Relation Column

Relate items to other items

Relation columns play a very important role in connecting data across your sheets.

With a relation column, you can link records from one sheet to another, provided that the two sheets share something in common.

In the sheet above ๐Ÿ‘†๐Ÿผwe have two tabs.

  • The first tab contains a companyโ€™s employees.

  • The second tab contains information about the departments.

Because each employee has a column with the name of their department, we can match this with the department name in the department's sheet.

Types of Relations

With a relation column you can create two types of relation;

  1. A single relation

  2. A multiple relation

Single Relations

When a relation column returns a single value for each cell, we refer to this as a single relation. For example, you could relate to the manager for each employee (assuming they have one) or the category for a particular recipe.

To create a single relation, go to the data editor and create a new column. Choose โ€œrelation columnโ€and configure the column to match your data.

To display a single relation in your app, use the Relation Component.โ€‹

Multiple Relations

When a relation column returns multiple values for each cell, we refer to this as a multiple relation. For example, you could create a multiple relation that allowed you to see all employees that worked in a particular location or all recipes in a particular category.

To do this, go to your data editor and create a relation column. This time, also turn on the 'match multiple' setting to make sure that the column will return more than one entry.

To display a multiple relation in your app, use an Inline List or List Relation.