Get related is an action that collects the records connected to a record through relation fields (the trigger decides when the automation runs, and the action decides what happens). It's meant to help you reach linked records, like the project of a task or the tenants of a unit, without searching for them.
You can use this action for many things, including:
Collecting all tasks of a project when the project is closed.
Collecting the customer of an installation to send them an update.
Tape has two versions. Get related starts from the record that started the automation. Get related for collected starts from a list of records you collected earlier.
Note:
The action only collects records. Use the collected records in later actions, like
Update collected,Send email to collected, orLoop actions.It collects up to 1,000 records. If more are linked, the result is cut at 1,000, and no error appears. Learn more about limits →
Get related needs a record. It isn't offered after
On a scheduled time or intervalorWhen a webhook is received. UseGet related for collectedthere.Get related replaces the list of that database app. Use it before other actions that add to the same list.
Who can use the Get related actions?
Automations are available on the Free, Plus, and Premium plans. The number of automation actions per month depends on your plan. See the limits for your plan on our pricing page.
To add or change these actions, you need to be a workspace admin of the workspace the database app is in. You also need full access to every database the automation uses.
Add the Get related action
To collect the related records of the current record:
Open the database app and click the automations icon at the top right (
Create and view automations).Open an automation, or select
New automationand choose a trigger.Select
Add action→Get related. The step appears asGet related records for the current record.Under
From app, check the database whose records are linked. Tape preselects a linked database app. Select its name to choose another one.Choose the direction, the relation field, and which records to collect.
Select
Add followto follow more relations.Select
Create automationfor a new automation, orSave changesfor an existing one.
Get related settings
Each row of the action reads from left to right. The first row starts with From app, and every row you add starts with Follow to app.
From app: the database app whose linked records you want to collect. The first row starts from the record that started the automation, or from the collected records inGet related for collected.Follow to app: the database the next row leads to. It's used for every row after the first.Outgoing viaandIncoming via: the direction of the relation.Outgoing viameans only records that this record refers to directly. For example, the project a task points to.Incoming viameans records that refer to this record. For example, the tasks that point to a project.Both directionsfollows the relation both ways. The dropdown only offers the directions that exist between the two databases.Any field: the relation field to follow. Open the dropdown to choose one field, or keepAny fieldto follow all relation fields between the databases.All recordsorFiltered records:All recordscollects every linked record.Filtered recordsonly collects those that match a filter you add.Add follow: adds a row that follows another relation from the records the row before reached. Click×at the end of a row to remove it.
The ••• menu of the action contains Continue on error, Deactivate, Turn into, Duplicate, and Remove. Learn more about action settings →
Each row fills the list of its database, so after the action you can use the collected records of every database in the rows. Tape keeps one list per database. Search for records and Get view add to that list, and Get related replaces it. Use Clear collected first if you want only the new records.
Add the Get related for collected action
To collect the related records of a list of records:
Add an action that collects records first, for example
Search for recordsorGet view.Select
Add action→Get related for collected. The step appears asGet related recordsforand the name of a list.Check the list next to
for. Tape preselects the nearest collection above this action. Without one, it readsSelect collected records, and the list showsNo results.Set the rows the same way as in
Get related.Select
Create automationfor a new automation, orSave changesfor an existing one.
The settings are the same as above. The result is a new list of records, which later actions can use. Learn more about collected records →
Let's look at an example
Let's say your solar team wants to notify the customer when an installation is scheduled. Here's how:
Set the trigger to
When a record is updatedin theInstallationsdatabase app and select theStatusfield.Add the filter
WhereStatusHas changed to"Scheduled".Select
Add action→Get related.Under
From app, chooseCustomerswithOutgoing viaandAny field, and keepAll records.Select
Add action→Send email to collected.Select the collected customers, then write the email.
Select
Create automation.
The next time an installation is scheduled, the customer linked to it gets an email.
Get related errors
If nothing is collected, check the direction and the relation field.
Outgoing viaandIncoming viagive different records.If
Select collected recordsshowsNo results, add an action that collects records above this one.If the step fails, the run shows the step and its message. Open the automation and click
▷(View all runs) at the top, or usecmd/ctrl+1. Each run shows its status, for exampleSuccess; select a run to see every step. For all automations, openRunsin the Automation Center and filter byApp,Automation, orStatus.
Test, pause, or edit the Get related actions
Manual runruns the automation once. UnderRun on, select the records, then selectStart run, orSave and start runif you have unsaved changes. Later actions can change real records.To stop only one action, select
•••→Deactivate.To change an action, open the automation, select the step, make your changes, then select
Save changes.
Learn more
FAQs
What's the difference between Get related and Get related for collected?
What's the difference between Get related and Get related for collected?
Get related starts from the record that started the automation. Get related for collected starts from a list of collected records and returns the records linked to all of them.
Can I follow several relations in a row?
Can I follow several relations in a row?
Yes! Select Add follow to add a row. Each row follows one more relation from the records of the row before.
Can I change the related records directly?
Can I change the related records directly?
Yes! Use Update related to change all related records in one action, or collect them first and use Update collected. Learn more about Update related →
Can I get only some of the related records?
Can I get only some of the related records?
Yes! Choose Filtered records instead of All records and add a filter. Learn more about filters →
Can I get the values of related records, like a total?
Can I get the values of related records, like a total?
Yes! Collect the records, then use Rollup collected to combine their values. Learn more about rolling up totals →
Are there other actions I can use?
Are there other actions I can use?
Yes! Actions can create and update records, add comments, send emails, create PDFs, call other services, and more. See every action in Automation actions →
Are you a developer using the Tape API for automations?
Are you a developer using the Tape API for automations?
The automation API has its own documentation for developers. Full reference: collect_referenced_records in the developer docs →
Still have questions? Find answers and get help from community experts in the Tape community →
