Skip to main content

Relation field

Link records of one database app to records of another. Choose the database, a view or a filter, limit the field to one record, and set a sort order.

Written by Leo

A Relation field connects the records of two database apps. In a Tasks database, a relation field can link each task to a Projects database. Relation fields are meant to help you keep related information connected instead of copying it.

The task Prepare key visual for environmental campaign with the relation field Belongs to project linking to the project Environmental campaign

Note:

  • A relation can link to the current database app. In the list of databases, the app you're in is marked Current database. Choose it to let records point to other records of the same database.

  • Removing a linked database from the field doesn't delete records. Tape tells you: "Linked records will not be deleted."

  • To see the link from the other side, add a reference. A relation field links in one direction. In the linked database app, add a Two-way reference or References block to the record layout to see which records link to a record. Learn more about references and two-way references →

Who can use the relation field?

  • The relation field is available on all plans: Free, Plus, and Premium. See what each plan includes on our pricing page.

  • To add or change a field, you need Full access to the database app and a desktop or tablet.

Add a relation field

  1. Open the database app, open the app menu, and select Customize record layout.

  2. Click + or type / in a text block.

  3. Under New field, select Relation. You can also type Relat to find it.

  4. Under Select a database, enter a name under Search for a database… and select the database. The name of its workspace is shown below each database, so you can tell databases with the same name apart.

Clicking + next to a field in the layout editor, typing Relat, and selecting Relation under New field, which opens the list Select a database

The list Select a database with Search for a database…: Properties marked Current database, then Tasks, Projects, Sprints, Epics, and Backlog, each with its workspace name below

Tape names the field "Relation to" followed by the name of the database. You can rename it under Edit field.

Choose which records can be linked

In Edit field, the section Related to lists the linked databases. For each database you can set:

A database uses either a view or a filter: Filter is hidden while a view is selected, and View is hidden while a filter has conditions.

Edit field of the relation field Primary contact with the menu of the linked database Contacts open: Filter with a Premium badge, View set to None, and the view list with Search views…, Contacts All records in app, and the team view Table

Click + next to Related to (Link a database) to link another database to the same field. To change the order of the linked databases, drag a database by its handle. The tooltip reads Drag to move.

Relation field settings

  • Limit: No limit or 1 Record. When you choose 1 Record, Tape asks Change limit to 1 record?. Only the first linked record of each record is kept, and you can't undo it. In some older relation fields, Limit is grayed out and can't be changed. To use a different limit there, add a new relation field.

  • Sort: the order of the linked records. Choose Manual, Alphabetical, or Reverse alphabetical.

  • Default: the record that new records start with. Search for it under Select default record….

The Edit field menu of the older relation field Primary contact with Limit grayed out at 1 Record, Sort set to Manual, Required, Default set to None, and Contacts under Related to

Link records in a record

In a record, select the button of the field. It's named after the records of the linked database, for example Add contact. If the field links several databases, it reads Add record. Choose an existing record from the list, or create a new one. If the record layout doesn't allow linking existing records, the button reads New instead, for example New contact. To remove a link, select Unlink. The record itself stays in its database.

Clicking Add contact in the Primary contact field of the property Riverstone Eight and selecting Olivia Bennett from the list, which then shows as a card

In a record layout, you can show a relation as cards, a list, or a dropdown. Learn more about relation blocks →

Choose what the search shows

When you link a record, the search list shows the title of each record. You can add more fields, for example the city of a property or the email of a contact, so the right record is easier to find.

  1. Open the layout editor with Customize record layout, then open the search of the relation field in the record. Learn more about the layout editor →

  2. Click the eye icon at the top right of the list. It turns blue once more fields than the title are shown.

  3. If the field links more than one database, choose the database first.

  4. Under Shown in search and Hidden in search, show or hide fields, or use Show all and Hide all. Search for a field under Search for a field….

Opening the search of the relation field Lender in the layout editor, clicking the eye icon, and showing Company type, so each company in the search shows its type

The setting is saved in the record layout, so everyone using the layout sees the same fields in the search. The eye icon appears in the layout editor, not while you work in a record. Learn more about the layout editor →

FAQs

Can I see the link from the other record too?

Yes. Add a Two-way reference or References block to the record layout of the linked database app. It lists all records that link to that record through the relation field. Learn more about references and two-way references →

Can I link a record to several records?

Yes, as long as Limit is No limit. Set it to 1 Record if each record should link to only one.

Can I link records of the same database app?

Yes. Choose the database marked Current database.

Does unlinking delete the record?

No. Unlink only removes the link. The record stays in its database.

Can I limit which records people can choose?

Yes. Choose a View or add a Filter for the linked database app. Learn more about filtering relation options →

Can I add up values from linked records?

Yes. A calculation field can add up or average values of linked records. Learn more about calculation syntax →

Are there other field types?

Yes! Database apps have fields for text, numbers, dates, members, files, relations, calculations, and more. See every field type in Intro to fields →

Still have more questions? Find answers and get help from community experts in the Tape community →.

Did this answer your question?