Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: need help with dates?

402 0
cancel
Showing results for 
Search instead for 
Did you mean: 
ydoc
5 - Automation Enthusiast
5 - Automation Enthusiast

Is there a way to check a date constantly on airtable and if the date has passed label that record as missed?

3 Replies 3
oVo_Team
6 - Interface Innovator
6 - Interface Innovator

Hello !

do you have something like a requested date field in airtable ? 

you could compare this requested date to TODAY() in a formula field, and If the result is negative, bring the output to ''Missed'' as a single select field

Does that help ?

I assume you need to trigger an automation once that record is missed?  If so, besides the formula option @oVo_Team  mentioned you could also try using a view and filter in any records where that date has passed and trigger the automation when the record enters the view

I agree with @TheTimeSavingCo 's solution. This will also allow you to add more filters to define what is "missed". I assume it is not just that the date has passed, but also that some other field hasn't been updated.


Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/