Automate

[JBAA]

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

[TheTimeSavingCo]

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

Link to base

[JBAA]

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.

[TheTimeSavingCo · Accepted solution]

Ah, I would suggest checking out the documentation to familiarize yourself with the functionality available

[JBAA]

Thanks so much for your guidance.