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"
)

[MZ13]

What could be done if the automation needs to trigger let's say every 1,000 miles. So the first trigger would be 1,234 mile and the next one would need to be at 2,234, and so on. 

I have a similar use case and haven't figured out how to do this...

[TheTimeSavingCo]

Hmm, I'd try making the "Miles Trigger" field into a formula in that case, and the formula would be `{Current Miles} + 1000`