Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

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

Topic Labels: Scripting extentions
136 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.