Skip to main content
Solved

Script for status and dates

  • April 3, 2024
  • 1 reply
  • 15 views

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

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. 

 

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!

Best answer by TheTimeSavingCo

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

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

1 reply

TheTimeSavingCo
Forum|alt.badge.img+31
  • Brainy
  • 6457 replies
  • Answer
  • April 3, 2024

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

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