Automation Trigger for Time Based Records

[v1_oh_n0]

Hello,

I am trying to develop a maintenance tracking solution that deals with both dates and hours or miles due. I am attempting to configure airtable automations to send notifications as upcoming inspections become near. 

I have figured out how to run a notification automation quite easily for those inspections required by a certain date. However I am still trying to determine how to configure the same type of automation with a trigger when the miles or hours reach a certain time. 

For example, if the next inspection is due at 1,234 miles, I want the automation to trigger when the current vehicle miles are within 5 miles of that number, or anytime that the current miles have exceeded the next due mileage.

Thank you for your help.

[TheTimeSavingCo]

Try creating a formula field that'll check whether the miles value is within 5 miles and then using that formula field as your automation trigger?

IF(
  {Current Miles} >= ({Miles Trigger} - 5),
  "Yes",
  "No"
)

[v1_oh_n0]

Thank you that will definitely help.

What is the formula to leave the automation blank if there is a missing miles trigger?

[TheTimeSavingCo]

Hmm, throw in an AND to check whether it's populated? 

IF(
  AND(
    {Current Miles} >= ({Miles Trigger} - 5),
    {Miles Trigger}
  ),
  "Yes",
  "No"
)