Relationship attributes
Create bidirectional relationships to connect records.
Relationship attributes allow you to connect records and show the bidirectional relationship between them. Updating the value of a relationship attribute on one record will also automatically update the value on any connected records.
For a video walkthrough of setting up relationship attributes, see Attio Academy.
Note: Relationship attributes are only available on Pro and Enterprise plans. Learn more about plans and pricing.
The relationship attribute type is only available for object attributes, not list attributes, and you must be an admin to create them. To create a relationship attribute, click your workspace name and go to your Workspace settings, click Objects, select an object, then go to the Attributes tab. When you create an object attribute and select the Relationship attribute type, you will choose the two objects you want to link. This can be two different objects or two of the same object.
Then choose from the following options to designate how many records can be linked on both sides:
One to many
This allows you to select one record of the first object and connect it to many records of the second object
Example: Connect Companies with a Deals object to connect one company with many deals associated with the company
One to one
Connect one record of the first object with one record of the second object
Example: Connect Companies with People to link your main point of contact at a company to their company
Many to one
Connect many records of the first object with one record of the second object
Example: Connect an Invoices custom object with Companies to link many invoices to one company
Many to many
Connect many records of the first object with many records of the second object
Example: Connect a Workspaces custom object with a Users custom object to link a workspace with its users (and users can be in more than one workspace)
You will also need to give an Associated attribute name for both sides of the relationship. This will show on all records for the object it's under and should describe the relationship the linked records of the other obejct will have to its records.
For example: For a Workspaces <> Users relationship attribute, under Workspaces you'd enter "Users" for the Associated attribute name, and under Users you'd enter "Workspaces", like this:
With the above setup, when you are adding a workspace record you can designate its user(s) via the relationship attribute, and when you add a user you can designate its workspace(s) via the relationship attribute. If you update the workspace attribute on a user, it will also update the user attribute on the workspace.
