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.
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 referenceorReferencesblock 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 accessto the database app and a desktop or tablet.
Add a relation field
Open the database app, open the app menu, and select
Customize record layout.Click
+or type/in a text block.Under
New field, selectRelation. You can also typeRelatto find it.Under
Select a database, enter a name underSearch 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.
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:
View: limits the records people can choose to a view of that database. Pick fromTeam viewsorMy views, or chooseAll records in app.Filter: limits the records with conditions instead of a view. It's markedPremium. Learn more about filtering relation options →Hide when empty: appears once a filter has conditions. Learn more about filtering relation options →Open in new tabopens the linked database, andRemoveremoves it from the field.
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.
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 limitor1 Record. When you choose1 Record, Tape asksChange 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,Limitis 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. ChooseManual,Alphabetical, orReverse alphabetical.Default: the record that new records start with. Search for it underSelect default record….
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.
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.
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 →Click the eye icon at the top right of the list. It turns blue once more fields than the title are shown.
If the field links more than one database, choose the database first.
Under
Shown in searchandHidden in search, show or hide fields, or useShow allandHide all. Search for a field underSearch for a field….
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?
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?
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?
Can I link records of the same database app?
Yes. Choose the database marked Current database.
Does unlinking delete the record?
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?
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?
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?
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 →.
