I want to create a 3 step automation, but having trouble with step 3 (update record)
When a record matches conditions. I want this to only run 1x per month on the 30th day of month (I know how to do this)
Find records in a table that match certain conditions (I know how to do this)
Update all records that match the certain condition in step 2. Specifically, I want to update a column to have checkbox checked for all the records the meet the condition in step 2.
Can someone please assist
Also, be sure to email firstname.lastname@example.org to let them know how much you would like to do this natively in Airtable.
If you use a script action, steps 2 and 3 would be combined in the script, which would search the records to find which ones match certain conditions, and then update them appropriately.