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