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.
With a relation column you can create two types of relation;
A single relation
A multiple relation
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.
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.