Skip to main content

Update related records action

Change fields on every record linked to the current record in one step, for example set all contacts of a won deal to Customer, without collecting them first.

Written by Leo

Update related is an action that changes fields on all records that are linked to the record that started the automation. In the action list, its description reads Update all related records. It's meant to help you keep linked records in sync without a loop and without collecting them first.

You can use this action for many things, including:

  • Setting every task of a project to "On hold" when the project is paused.

  • Setting the status of all contacts linked to a deal to "Customer" when the deal is won.

The action Update all related records in Tasks with Add field

Note:

  • It changes every related record. With Set value or Set option, each field you add replaces the current value on every related record. Test with a small set of records first.

  • One database app per action. Update related updates the linked records of one database. To update linked records in another database, add another Update related action.

Who can use the Update related action?

  • 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 this action, 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 Update related action

To update related records from an automation:

  1. Open the database app and click the automations icon in the top bar (tooltip Create and view automations). The icon is only there for workspace admins, and not on mobile.

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

  3. Select Add action → Update related. The step appears as Update all related records.

  4. Next to in, select the database app whose records you want to update. Tape preselects the first linked database app.

  5. Select Add field. Tape adds a row with the first field of the database app and Set value. Select the field name and choose the field you want to change.

  6. Enter the new value next to the field. The menu next to the field depends on the field type, for example Set value, Set option, Set date, Set person, or Set record. It also has Calculation and an option to clear the field.

  7. Add more fields if needed, then select Create automation for a new automation, or Save changes for an existing one.

Adding Update related in an Expenses automation: selecting Update related, which reads Update all related records in Tasks, selecting Add field, changing the field Title to Priority, and choosing the option High after Set option

Update related settings

The action reads as a sentence: Update all related records in a database app, followed by the fields you set.

  • The app: the database app whose related records are updated. You can choose any database that is linked to this one through a relation field. The action updates records in both directions: records this record links to and records that link to it.

  • Add field: adds a row with the first field of that database app. Select the field name to choose another field. You can add as many fields as you need.

  • A value for each field: enter text or numbers, choose an option, date, person, or record, or insert record values by typing @. The placeholder in the text box is Value. Fields with several values also offer adding or removing values, for example Add options and Remove options. Learn more about field options in the Update record action →

Under the action's menu, Settings has these options:

  • Author: who the change is attributed to in the record's activity. If you don't choose one, the change is attributed to the automation itself. Open •••, then select a person under Author. You can choose the automation (the default), a member of the workspace, or a person value such as Created by.

  • Silent: makes the update without sending notifications. It's off when you add the action.

  • Trigger automations: lets the update start other automations, for example one with the trigger When a record is updated. It's off when you add the action.

  • Trigger webhooks: lets the update send outbound webhooks. It's off when you add the action.

The menu also has Continue on error, Deactivate, Turn into, Duplicate, and Remove. To rename the step, select its title. Learn more about action settings →

Let's look at an example

Let's say your sales team wants every contact linked to a deal to become a customer when the deal is won. Here's how:

  1. Set the trigger to When a record is updated and select the field Stage.

  2. Add the filter Where Stage Has changed to "Won".

  3. Select Add action → Update related.

  4. Select the database app Contacts.

  5. Select Add field, choose Customer status in the new row, then set the option to "Customer".

  6. Select Create automation.

The next time a deal moves to "Won", all contacts linked to that deal get the status "Customer". Deals without linked contacts stay unchanged.

Update related errors

  • If the step fails, the run shows the step and its message in the automation's runs. 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.

  • If updating one of the records fails, the step fails. Records are updated one after another: records updated before the error keep their new values, and the remaining records aren't updated.

  • If the current record has no linked records in the selected database app, the step finishes without changing anything.

Test, pause, or edit the Update related action

  • 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. The linked records of those records are changed for real.

  • New automations you create in the editor are Active right away. The status, Active or Paused, sits right below the automation's name in the editor. To pause one, select Active, then select Save changes. The status switches to Paused.

  • To change the action, open the automation, select the Update all related records step, make your changes, then select Save changes.

Learn more

FAQs

Do I need to collect the related records first?

No. Update related finds the linked records itself. If you want to filter, sort, or count the linked records first, use Get related to collect them, then use Update collected.

Is this the same as updating referenced records?

Yes. In Tape, records that are linked through a relation field are called related records, and this action updates all of them.

Can I update related records in more than one database app?

Yes, with one action per database. Add Update related again and select the next database.

Will the update start other automations?

Only if Trigger automations is on in the action's Settings. This helps you avoid loops, for example when the updated records have an automation that updates the first record again. Learn more about runs in a loop →

How many related records can one action update?

Each run has a limit of 1,000 actions and runs for up to three minutes. Each updated record counts as one action, and finding the related records counts as one more. Learn more about limits →

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: referenced_records_update in the developer docs →

Still have questions? Find answers and get help from community experts in the Tape community →

Did this answer your question?