Help

Re: Updating Status After Time Period

Solved
Jump to Solution
1271 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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. 

Noahbrown18_0-1713794369696.png

 

Here is what my configuration is.. Someone please help me understand what I am doing wrong..

14 Replies 14
Jack_Manuel
7 - App Architect
7 - App Architect

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.

Screenshot 2024-04-22 at 16.02.45.png

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.

Screenshot 2024-04-22 at 15.35.06.png

 

 

 

 

 

 

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.

Anonymous
Not applicable

I am not a robot Scott. I am providing screenshots and asking for help, and even private messaging you for help. It is very clear that I am not AI or anything of the sort. I was under the assumption that changing the "record ID" meant that you were only changing ONE record. Not the list of records that I want to change. I have multiple peoples statuses I wish to automatically change when a specific day is passed, so I had assumed what I have stated above. 

Anonymous
Not applicable

This is the exact information that  I needed explained that scott did not provide. Thank you for your help

That is the same information that I gave you in my post above (although I didn’t include a screenshot this time).

Anonymous
Not applicable

Scott, thanks for your reply but I really do not wish to continue a back and forth on a public forum. If you would like to continue a dialogue please let me know via direct message.