Build a DIY vehicle maintenance tracker in SmartSuite

Executive overview

Reactive maintenance — fixing things after they break — is inefficient and avoidable. A spreadsheet helps but fails if you forget to check it.

This tutorial builds a three-database SmartSuite system that automatically calculates when each service is due, surfaces overdue items in red, and sends alerts so you never have to remember.

The core insight: embed your service manual into your tools so the tool does the remembering, not you.

The three apps and what they track

• Vehicles — one record per vehicle with nickname, owner, make/model, mileage (auto-calculated), status, and photo
• Maintenance schedule — each service item from the service manual, with instructions, mileage intervals, and a formula that calculates next-due mileage
• Maintenance log — individual service entries recording date, odometer, vehicle, technician, and items serviced

Vehicles app: key fields

• Mileage is a formula summing the mileage log — not a manually updated field
• Sub-items track aftermarket mods (date, cost, condition) — useful when selling a used bike
• Count fields show how many service intervals are on-track vs. overdue
• Card view with conditional formatting: a red banner appears if any maintenance is overdue
• Mileage log records trip start/end odometer; can be updated via the SmartSuite mobile app

Maintenance schedule app: how due dates are calculated

• Service intervals (e.g. 4,000 / 7,000 / 10,000 miles) are entered directly from the service manual
• A next service formula field uses nested IF functions to find the next interval not yet passed, based on the last logged mileage
• Instructions are stored as SmartDoc fields with screenshots of the service manual — accessible and zoomable on mobile
• Linked record field connects each schedule item back to the vehicle it belongs to
• Spotlight (conditional formatting) colours rows green / yellow / red by miles remaining

Maintenance log app: logging a service

• Entry title is auto-generated from service date and odometer reading
• Items serviced field uses a linked record filtered to show only maintenance items for the selected vehicle — prevents cross-vehicle confusion
• After saving a log entry, the maintenance schedule updates automatically: next service mileage recalculates, and vehicle count fields refresh
• A public-facing quick form lets you log a service from any browser tab without opening SmartSuite

Alerts and recurring maintenance

• Repeating due dates (SmartSuite's repeating task feature) trigger time-based reminders independent of mileage — useful for seasonal tune-ups
• Set recurrence to every 3 months (or per your manual's time-based intervals) to catch maintenance even if mileage stays low
• When the due date arrives, SmartSuite sends an alert and the vehicle card shows what's overdue