Vehicle Service Log
Community,
I need some help.
I have a vehicle service log that field techs complete when using a company vehicle. It is driven by a form that asks them to enter dates of use, specific vehicle, and mileage. I want to set up alerts based off a mileage intervals. For example, I want a vehicle to have an oil change every 5000 miles. The vehicles are not starting at zero. I am trying to figure out a way to send a notification to users if a vehicle's mileage reaches or exceeds the interval that will change with each service.
Answers
-
I think this would be best done with three sheets, a usage mileage log sheet, Service mileage Log sheet, and a Metrics sheet to take all the latest mileage entered for a vehicle and subtract the last service mileage if that is less than 5000 miles do nothing. once it is over 5000 send an email to the user. once the vehicle is serviced the service mileage will = the usage mileage again and then it will start the count all over again.
-
Hmmm, makes sense. I will try this and see if I can make it work.
Thanks for the help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.1K Get Help
- 448 Global Discussions
- 154 Industry Talk
- 504 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 513 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!