Mar 26, 2024 10:11 AM
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.
Mar 26, 2024 03:37 PM
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"
)
Mar 26, 2024 04:42 PM
Thank you that will definitely help.
What is the formula to leave the automation blank if there is a missing miles trigger?
Mar 26, 2024 09:58 PM
Hmm, throw in an AND to check whether it's populated?
IF(
AND(
{Current Miles} >= ({Miles Trigger} - 5),
{Miles Trigger}
),
"Yes",
"No"
)