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?
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