Add multiple linked records with script or automation?

[Some_Voices]

Hello world

I’m working on a budget base which requires a linked field to pull in cost data.
It currently means manually searching for a linked record 20 times for each choir rehearsal (there are 10 venue costs, and 10 staff costs per choir)…
And we have 19 different choirs to do this for (almost 400 manual ‘clicks’).

I’m either being stupid and missing something obvious, OR it requires some form of scripting (in which I am clueless) or automation to make this happen automatically.

Could anyone shed some light?
Here’s a short video showing what I currently have to do.

And here’s a link to an abbreviated version of the base.

Any help would be hugely appreciated!
Many thanks
Curtis

[ScottWorld]

Where it is specifically asking you for a Record ID, you are not giving it a record ID. Where it asks you for the record ID, you need to specify the Airtable Record ID from the trigger step.

[Some_Voices]

I think what we’ve all learnt today, is that I don’t understand Airtable as well as most!
Thanks ever so much - I really do appreciate it.
It works :slightly_smiling_face: