Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Is Automation limited to one time a record?

78 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Dear All, I have got a situation, where I try to have a single update will trigger two records changes (one to many relationship), like below:

twmeric_0-1671238107996.png

When I change back to 1 on 1 relationship, the automation works.  Because the two entries are on the same column, so that I can't refer one to another.

Any suggestion to me?

1 Reply 1

An update record action will only work if there is exact one record ID. You cannot submit multiple record IDs to a single Update Record action and have it update all of the records.

Some options include moving the automation around to the linked table and using a lookup of a rollup on the linked table to indicate when the automation should fire. 

Another option is to use scripting. 
or if you will have a maximum of two linked records, you might be able to use conditional rollups or a rollup and formula fields to split the linked record IDs into different fields. But that is rather complicated are rarely worth the complexity.