Skip to main content

Connect your apps with relations and calculations

Link records across database apps with relation fields, show linked records on both sides, and add up values from linked records, such as hours per project.

Written by Leo
The project Environmental campaign with its owner, team, and status, and its two tasks under Related records

Each project shows the tasks that belong to it.

Work is connected: tasks belong to projects, meetings move projects forward, invoices belong to clients. When each lives in its own database app without a link, people copy information back and forth. Relations connect the records instead, so every record shows the context it belongs to.

How relations work

A Relation field links records of one database app to records of another database, or of the same database. You add it once to one database, for example a "Project" field in the Tasks database. Then:

  • Each task shows its project in the relation field.

  • Each project shows its tasks with a Two-way reference or References block.

  • Calculations can use values of linked records, such as the hours of all tasks of a project.

Link two apps

  1. Open the database app, for example Tasks, then the app menu, and select Customize record layout.

  2. Click + next to a field, and under New field, select Relation.

  3. Under Select a database, search for the database with Search for a database…, for example Projects.

  4. Optional: under Limit, choose 1 Record if a task belongs to exactly one project.

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

Add a relation field and choose the database to link.

In a record, click the relation field and pick records. The search field names the linked database app, for example Search projects…. To add a project that doesn't exist yet, click + next to the search field, fill in the new project, and select Create Project. Learn more about creating related records →

The task Prepare agenda for team meeting with its assignee, status, task list, and the project Prepare team meeting in the relation field Belongs to project

Each task shows the project it belongs to.

Tip: In the settings of the relation field, choose a View of the linked database to limit which records people can pick, for example only active projects. On the Premium Plan, you can use a Filter instead. Learn more about filtering relation options →

Show linked records on the other side

The relation field lives in one database app. To show the linked records in the other database, add a block to its record layout:

  • Two-way reference: shows the records of one other database app that link to this record, for example the tasks of a project.

  • References: shows linked records from several database apps at once, grouped by Data source or by Date. Useful as an activity timeline of a client or a project.

In the layout editor, the add menu filtered by Refer shows References and Two-way reference under Database

Add References or Two-way reference to the record layout.

Calculate across linked records

A Calculation field can read the fields of linked records. Write the name of the relation field, or for records that link to this one, the name of their database app. Then add the field of the linked records and what you want. For example:

  • The total hours of a project: Tasks.Hours.sum

  • The number of tasks: Tasks.Title.all.length

  • The latest due date: Tasks.Due_date.max

Type @ in the editor to pick fields from a list. Read the guide on calculations →

Typing Unit in the empty calculation editor of the Total field and selecting Unit_price, then typing * Qua and selecting Quantity, after which Preview with shows $2,274.00

Pick fields from the list while you type.

Need the total stored as a regular field, for example for reports or automations? An automation can add up the values and write them to the project. Open the roll-up recipe →

Example: connect projects, tasks, and meeting notes

  1. Projects hold the goal, the owner, and the status.

  2. Tasks have a relation field "Project," so every task belongs to a project.

  3. Meetings have a relation field "Projects," because one meeting can cover several projects.

  4. On the project's record layout, a References block shows its tasks and its meetings, grouped by date.

  5. A Calculation field on the project counts the open tasks.

Open a project, and you see what's planned, what's done, and what was discussed, on one page. Read the projects and tasks guide →

Learn more

FAQs

Do I need a relation field in both database apps?

No. Add the relation field to one database app, and show the linked records in the other database with a Two-way reference or References block. Learn more about references →

Can a record link to several records?

Yes. A relation field has No limit by default. Choose 1 Record under Limit if a record should link to only one. Learn more about the relation field →

Can I link records of the same database app?

Yes. A relation field can point to its own database app, for example to link a task to the task it depends on. Learn more about the relation field →

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

Did this answer your question?