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?