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 referenceorReferencesblock.Calculations can use values of linked records, such as the hours of all tasks of a project.
Link two apps
Open the database app, for example Tasks, then the app menu, and select
Customize record layout.Click
+next to a field, and underNew field, selectRelation.Under
Select a database, search for the database withSearch for a database…, for example Projects.Optional: under
Limit, choose1 Recordif a task belongs to exactly one project.
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 →
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 byData sourceor byDate. Useful as an activity timeline of a client or a project.
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.sumThe number of tasks:
Tasks.Title.all.lengthThe latest due date:
Tasks.Due_date.max
Type @ in the editor to pick fields from a list. Read the guide on calculations →
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
Projects hold the goal, the owner, and the status.
Tasks have a relation field "Project," so every task belongs to a project.
Meetings have a relation field "Projects," because one meeting can cover several projects.
On the project's record layout, a
Referencesblock shows its tasks and its meetings, grouped by date.A
Calculationfield 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?
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?
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?
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 →.
