Skip to main content

Updating multiple linked records


Forum|alt.badge.img+5

I want an automation to update the linked records. It works when a record only has 1 linked record that the automation should update. But when there is more linked records to update it will not change any of them.   any suggestions? 

 

 

3 replies

Valentino_Escal
Forum|alt.badge.img+10

Hi @Lars_Bjertnaes 

To answer the question regarding updating multiple linked records with an automation, it's possible but not the way your automation is set up. It could go as follows:

Trigger: If a record is updated (the field with multiple records)

Conditional action:

1. If the conditions you want are met.

2. Update record into the new field as desired. The record id. would be the airtable trigger and select the field you want and put the linked record name.  

However the above described is not the current automation you have. To fix your current automation, the record id. in the screenshot you provided should not be the linked record. It should either be the trigger record id. or you need to create a find record step beforehand to make sure you are getting the right record id. number.

Let me know if this fixes the issue!


Forum|alt.badge.img+5
  • Author
  • New Participant
  • 3 replies
  • August 27, 2023
Valentino_Escal wrote:

Hi @Lars_Bjertnaes 

To answer the question regarding updating multiple linked records with an automation, it's possible but not the way your automation is set up. It could go as follows:

Trigger: If a record is updated (the field with multiple records)

Conditional action:

1. If the conditions you want are met.

2. Update record into the new field as desired. The record id. would be the airtable trigger and select the field you want and put the linked record name.  

However the above described is not the current automation you have. To fix your current automation, the record id. in the screenshot you provided should not be the linked record. It should either be the trigger record id. or you need to create a find record step beforehand to make sure you are getting the right record id. number.

Let me know if this fixes the issue!


Thank you Valentino. I found a solution with the "Repeating Groups" https://support.airtable.com/v1/docs/repeating-groups-of-automation-actions?_gl=1*fr096b*_ga*Njc1NTA3NjI3LjE2OTEwNjY1NTE.*_ga_VJY8J9RFZM*MTY5MzExNjg2My4yMy4xLjE2OTMxMTczODguMC4wLjA.

Now it first find the multiple linked records and after run the update on all of them. 

 

 


Valentino_Escal
Forum|alt.badge.img+10
Lars_Bjertnaes wrote:

Thank you Valentino. I found a solution with the "Repeating Groups" https://support.airtable.com/v1/docs/repeating-groups-of-automation-actions?_gl=1*fr096b*_ga*Njc1NTA3NjI3LjE2OTEwNjY1NTE.*_ga_VJY8J9RFZM*MTY5MzExNjg2My4yMy4xLjE2OTMxMTczODguMC4wLjA.

Now it first find the multiple linked records and after run the update on all of them. 

 

 


Hi @Lars_Bjertnaes 

Awesome happy you found a solution to the automation 👌


Reply