Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 20, 2023 02:03 PM
How can I set up an automation in Airtable that will update records in the status column once a week, but only if they meet a certain status type, such as changing records with the status 'DONE' to 'Archive'?
Solved! Go to Solution.
Feb 21, 2023 10:13 PM
Ah, I would suggest checking out the documentation to familiarize yourself with the functionality available
Feb 20, 2023 06:06 PM
Set up an automation that runs once a week with a "Find Records" action that will look for all records with the status "Done"
Then, add a repeating group with an "Update Record" action that will update each found record as needed
Feb 21, 2023 03:22 PM
I'm grateful for your reply, but I'm still confused about the 'update record' step and the available options for 'Record ID'. I appreciate that you chose 'Airtable record ID', but I'm having trouble understanding the other options.
Feb 21, 2023 10:13 PM
Ah, I would suggest checking out the documentation to familiarize yourself with the functionality available
Feb 22, 2023 04:49 AM
Thanks so much for your guidance.