Link units with relations
A relation links two units, such as “a client has many contracts”. You define it once and it shows in both units, and it opens the way to lookups, rollups and document templates.
Before you start · for ownersThe relations permissions (create, view, edit, delete)
- You need: The relations permissions (create, view, edit, delete)
Steps
Deleting a relation empties the rollups that depend on it for good. The numbers only come back if you create the relation and its links again.
The two types
A rollup needs a to-many relation. A lookup works with both types.
Display columns
Types allowed as a column: text, number, currency, dates, select, status, priority, tag, multi-select, source, true/false, and more. Sensitive fields, long text, relations and lookups aren’t shown.
Editing from the relation panel
Edit the linked record’s columns right from the relation panel on the record page. You can edit a column if it’s editable and you have the right to edit that record. If a teammate changed it before you, you see an alert with the new value, and your edit isn’t saved.
You can also quickly add a new linked record from the panel.
Deactivating or deleting a relation
You can deactivate a relation without deleting it. Deleting it empties the values of the rollups that depend on it and leaves the lookup fields empty, without deleting the records themselves.
If something goes wrong
A real example
The advisor doesn’t know which course the client signed up for.
- Relation: the client Has many enrollments.
- Display columns: course name, start date, amount.
The advisor sees the client’s enrollments right in their record.