Help

Automation Trigger for Time Based Records

Topic Labels: Automations Formulas
543 3
cancel
Showing results for 
Search instead for 
Did you mean: 
v1_oh_n0
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

3 Replies 3

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?

Screenshot 2024-03-27 at 6.36.47 AM.png

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

Thank you that will definitely help.

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

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

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