Hello

I am trying to update multiple records at the same time with a single automation.

Here is my setup:

In the same table, I have one PARENT product that has many CHILD products, all being separate records.

There is a “Link to another record” column in the PARENT, with a link to each of its childs.

When I update some fields in the PARENT record, I want them to be copied back to the CHILD same field.

Is it possible to setup an automation to use ALL the Records ID from the linked field?

I tried simply adding the field with the links to the needed “record ID” of the automation, but it gives an error, as it expects only one.

After trying many things, I have figured out that I might have to do the reverse and with the help of a lookup. I mean having each CHILD to check if the PARENT fields has been updated recently, then, if yes, copy it. This could probably work, but I would need to add a lookup for each field and worst, this would use a lot of automations and might kill my limit as many fields would trigger the automation.

I really wish the trigger could come from the PARENT instead. Anyone has an idea? I really hope that I am missing the obvious !

Sorry for my bad English, I am doing my best here :smiling_face_with_halo:

Thank you all!!