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
Automate
+2Best answer by TheTimeSavingCo
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.
Ah, I would suggest checking out the documentation to familiarize yourself with the functionality available
+31Set 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
+2Set 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
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.
+31I'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.
Ah, I would suggest checking out the documentation to familiarize yourself with the functionality available
+2Ah, I would suggest checking out the documentation to familiarize yourself with the functionality available
Thanks so much for your guidance.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.