Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Create automations change new record status if already exists in 30 days period

Topic Labels: Automations
195 1
Showing results for 
Search instead for 
Did you mean: 


I’m looking for a solution for creating an automation that changes the status of a new record to “Denied” if a record already exists with the same requestor name but with status “Approved” in the last 30 days.

Can someone help me if this is possible?

1 Reply 1

Welcome to the community, @Dennis_Voorn! :grinning_face_with_big_eyes: This is definitely possible, but it will require a “Run script” action in the automation. Only a script can do the kind of search required.

As for the script itself, if you’re not comfortable with script development, that will come with a price tag for the development time. However, it should be a quick build, so the cost wouldn’t need to be very high, but that all depends on the developer’s rate. If you’d like help, start a new thread in the #developers:work-offered category, or you could edit this thread and change the category.