Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Insert multiple records in child table monthly

838 0
cancel
Showing results for 
Search instead for 
Did you mean: 
corb
6 - Interface Innovator
6 - Interface Innovator

Hi - I need to be able to do a batch insert into a child table, monthly. I’d like to automate this. If I were doing this in traditional SQL it would look like:

INSERT Table2 (UpdateColHere)
SELECT ColHere FROM TABLE1
WHERE ConditionField = ‘TRUE’;

How would I go about that in Airtable? If by script, does anyone have any examples?

2 Replies 2

I don’t know JavaScript, so I can’t tell you how to do this with scripting. Somebody else will need to chime in to guide you there.

In the meantime, if you’re looking for a no-code way of doing this, I’ve setup two of my Airtable consulting clients with this exact same thing by using Make.com.

I set it up very easily by using these 2 simple steps, and this repeats once a month:

image

Hey @corb, here’s a base that does what you’re looking for with a script

Find and create

Trigger is a scheduled time trigger, runs a Find Records action to look for the records, and then creates the found records in the table you set in the script