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.
Note:
It changes every related record. With
Set valueorSet 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 relatedupdates the linked records of one database. To update linked records in another database, add anotherUpdate relatedaction.
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:
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.Open an automation, or select
New automationand choose a trigger.Select
Add action→Update related. The step appears asUpdate all related records.Next to
in, select the database app whose records you want to update. Tape preselects the first linked database app.Select
Add field. Tape adds a row with the first field of the database app andSet value. Select the field name and choose the field you want to change.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, orSet record. It also hasCalculationand an option to clear the field.Add more fields if needed, then select
Create automationfor a new automation, orSave changesfor an existing one.
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 isValue. Fields with several values also offer adding or removing values, for exampleAdd optionsandRemove 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 underAuthor. You can choose the automation (the default), a member of the workspace, or a person value such asCreated 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 triggerWhen 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:
Set the trigger to
When a record is updatedand select the fieldStage.Add the filter
WhereStageHas changed to"Won".Select
Add action→Update related.Select the database app
Contacts.Select
Add field, chooseCustomer statusin the new row, then set the option to "Customer".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 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.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 runruns the automation once. UnderRun on, select the records, then selectStart run, orSave and start runif you have unsaved changes. The linked records of those records are changed for real.New automations you create in the editor are
Activeright away. The status,ActiveorPaused, sits right below the automation's name in the editor. To pause one, selectActive, then selectSave changes. The status switches toPaused.To change the action, open the automation, select the
Update all related recordsstep, make your changes, then selectSave changes.
Learn more
FAQs
Do I need to collect the related records first?
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?
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?
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?
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?
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?
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: referenced_records_update in the developer docs →
Still have questions? Find answers and get help from community experts in the Tape community →
