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?
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:
Hey @corb, here’s a base that does what you’re looking for with a script
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.