Skip to main content

Get related records action

Follow relation fields to collect the records linked to the current record or to a list of collected records, then use them in later actions.

Written by Leo

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.

The action Get related records for the current record with one row: From app Tasks, Outgoing via, Any field, and All records, and Add follow below it

Note:

  • The action only collects records. Use the collected records in later actions, like Update collected, Send email to collected, or Loop 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 interval or When a webhook is received. Use Get related for collected there.

  • 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:

  1. Open the database app and click the automations icon at the top right (Create and view automations).

  2. Open an automation, or select New automation and choose a trigger.

  3. Select Add action → Get related. The step appears as Get related records for the current record.

  4. Under From app, check the database whose records are linked. Tape preselects a linked database app. Select its name to choose another one.

  5. Choose the direction, the relation field, and which records to collect.

  6. Select Add follow to follow more relations.

  7. Select Create automation for a new automation, or Save changes for an existing one.

Adding Get related in an Expenses automation: Add action, selecting Get related, pointing to Tasks after From app, choosing the field Follow-up task, opening All records, and selecting Add follow, which adds a row starting with Follow to app Projects

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 in Get related for collected.

  • Follow to app: the database the next row leads to. It's used for every row after the first.

  • Outgoing via and Incoming via: the direction of the relation.

  • Outgoing via means only records that this record refers to directly. For example, the project a task points to.

  • Incoming via means records that refer to this record. For example, the tasks that point to a project.

  • Both directions follows 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 keep Any field to follow all relation fields between the databases.

  • All records or Filtered records: All records collects every linked record. Filtered records only 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:

  1. Add an action that collects records first, for example Search for records or Get view.

  2. Select Add action → Get related for collected. The step appears as Get related records for and the name of a list.

  3. Check the list next to for. Tape preselects the nearest collection above this action. Without one, it reads Select collected records, and the list shows No results.

  4. Set the rows the same way as in Get related.

  5. Select Create automation for a new automation, or Save changes for an existing one.

The action Get related records for Expenses below Search for records, with the row From app Tasks, Outgoing via, Any field, and All records, and Add follow

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:

  1. Set the trigger to When a record is updated in the Installations database app and select the Status field.

  2. Add the filter Where Status Has changed to "Scheduled".

  3. Select Add action → Get related.

  4. Under From app, choose Customers with Outgoing via and Any field, and keep All records.

  5. Select Add action → Send email to collected.

  6. Select the collected customers, then write the email.

  7. 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 via and Incoming via give different records.

  • If Select collected records shows No 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 use cmd/ctrl + 1. Each run shows its status, for example Success; select a run to see every step. For all automations, open Runs in the Automation Center and filter by App, Automation, or Status.

Test, pause, or edit the Get related actions

  • Manual run runs the automation once. Under Run on, select the records, then select Start run, or Save and start run if 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?

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?

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?

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?

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?

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?

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?

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 →

Did this answer your question?