Updating Status After Time Period
Hi, I have been having problems with this for weeks now and cannot understand why my automation is not working.
I work for a company that runs an appointment based service. I book the date it is for and the status of it. When I put in the info, it is defaulted to "Booked". When the day AFTER the appointment comes, I want the system to find all record that match the given criteria (appointment yesterday, status booked) and update it to "Completed"
I have tried a million different things but nothing is working.
Here is what my configuration is.. Someone please help me understand what I am doing wrong..
Accepted Solutions
Airtable doesn't let you update a group of records in one go per se. Instead you update one record, multiple times for each item in a list.
The update record action doesn't know its in a list, it just wants the id of a single record at a time. That's this field here.
You have that field set to status when what it wants is the record id of the current item in the list. If you delete what is there you should be able to click the blue plus and see something similar to this.
Select "Airtable record ID" under "Insert value from field" when you have "Current item from List of records" to trigger the "Update record" on each item in your list of records.
For more reference this is my "find record" config
You should see something like the image below because your "Update record" action is inside of a "Repeat for each in list of records"
This will repeat for each record in your records search
