
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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"
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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"
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 15, 2024 06:14 AM
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...
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 15, 2024 11:37 PM
Hmm, I'd try making the "Miles Trigger" field into a formula in that case, and the formula would be `{Current Miles} + 1000`
