Help

Update multiple records in one table when a new record is created in another table

Topic Labels: Scripting extentions
551 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Abdi_Farah
4 - Data Explorer
4 - Data Explorer

Hi! I have an issue I think I might be able to solve with automation but just not sure how.

I have 3 tables Providers details, Solutions and Parts.

When I create a new Provider record I want to use a trigger to populate the name of the Provider into the Solutions table. I want this to happen 30 times as for each new provider I also have to update the same table with 30 parts.

Is it possible to create 30 new records in the Solutions table when a new provider is entered into the Provider details table and them simultaneously pull the 30 records from the parts table into Solutions table.

Can this be done with Automation?

Thank you in advance

1 Reply 1

Hi @Abdi_Farah

Welcome to Airtable community!

While I think it should be possible to create automation with 30 "create record actions (I have never really tested limit here)…
image
… this definitely sounds like a job that could be solved faster with a run script module and script creating the record 30 times.