Help

Script for status and dates

Topic Labels: Automations
Solved
Jump to Solution
102 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Noahbrown18
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi, I am trying to create either a script or automation that will detect multiple records for me. 

Noahbrown18_0-1712154300254.png

I have my trigger set up, If a record has a scheduled date that was one day ago and the status on it is "booked"

I want to then update anything under these conditions to "completed" 

I am having issues setting up the "updating" feature. 

 

Noahbrown18_1-1712154398046.png

my configuration is as shown. I have NEVER done this type of automation, so I am extremely confused on this. 

any help would be greatly appreciated!

 

Thanks in advance!

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Ah, you need to be using an Airtable record ID for the "Record ID" input field:

Screenshot 2024-04-03 at 10.38.44 PM.png

Check out Airtable's guide on how to use the Update Record action: https://support.airtable.com/docs/update-record-action

See Solution in Thread

1 Reply 1
TheTimeSavingCo
18 - Pluto
18 - Pluto

Ah, you need to be using an Airtable record ID for the "Record ID" input field:

Screenshot 2024-04-03 at 10.38.44 PM.png

Check out Airtable's guide on how to use the Update Record action: https://support.airtable.com/docs/update-record-action