Hi, I’m trying to figure out if I can create x number of new records based on input from a numerical field of another record. So for example, if a customer fills in a form for 7 cakes, this will trigger the creation of 7 new cake records in another table.
I’ve been trying to figure this out with Paths on Zapier, but to no avail. I have a feeling this might be doable using Code by Zapier, but coding is very much outside of my current skill level (although willing to learn if someone can point me in the right direction!).
And apologies in advance if I’m incorrectly using this forum. I am relatively new to Airtable as well as the community. Thank you!
Yes, this is a complicated challenge with Airtable’s standard (code-free) features. You are describing an automatic process and while Airtable is pretty good with human-driven processes, automated things like creating a collection of records based on a field value is well beyond its reach [presently].
This article seems to be what you are looking for.
I suspect there are ways to use Zapier to do this and the benefit would be a fully automated solution; i.e., it would create these additional task records automatically just a few minutes after entering the field that triggers the process.
A slightly less advantageous approach is to use a Script Block; an internal scripting feature.
Perhaps there are some good advisors here in the forum like @kuovonne who have already built something like this which seems like a really obvious thing people will want to do.
Thanks @Bill.French! This was very helpful and good to know that this level of automation isn’t available within the Airtable system yet. So I’ll try out the sources you’ve directed me to and see what workarounds I can incorporate.
If you are still interested in a scripting solution, I posted one here.
The system is not completely automated. You still need to click the “run” button for the script. However, the script will create new linked records for multiple orders all at once.
