Fleet & Vehicles
Inspections, DOT Compliance, Maintenance
THE PROMPT
“I manage a fleet of 60 vehicles. Drivers need to do pre-trip inspections, log defects with photos, track fuel usage, and we need to stay DOT compliant with maintenance schedules and service records.”
Lattice builds the complete system from this single prompt: 5 entities, 62+ fields, 6 automations.
Data Schema
(5 entities, 62 fields)| Field | Type | Required |
|---|---|---|
| Inspection ID | Auto-ID (DVR-####) | |
| Vehicle | Relation → Vehicles | |
| Driver | Relation → Drivers | |
| Type | Select[Pre-Trip, Post-Trip, Annual DOT, Spot Check] | |
| Odometer | Number | |
| Tires | Select[Pass, Fail] | |
| Brakes | Select[Pass, Fail] | |
| Lights | Select[Pass, Fail] | |
| Fluids | Select[Pass, Fail] | |
| Body/Exterior | Select[Pass, Fail] | |
| Horn/Mirrors | Select[Pass, Fail] | |
| Safety Equipment | Select[Pass, Fail] | |
| Defects Found | Long Text | — |
| Photos | Images (multi) | — |
| Result | Select[Pass, Fail - Minor, Fail - Out of Service] | |
| Date | DateTime (auto) |
Automations
(6 rules)When Inspection item → "Fail"
When Vehicle odometer passes service threshold
When CDL/Medical Card < 30 days to expiry
When Maintenance status → "Complete"
Daily at 5 AM
When Insurance/Registration < 30 days to expiry
Available Views
Sample Workflow: Pre-Trip Inspection with Defect
Driver opens mobile app, starts pre-trip
→ Checklist loads for assigned vehicle #247
Driver checks tires — notices low tread on front left
→ Marks "Fail" for tires, captures photo
Driver completes remaining items (all pass)
→ Inspection result: Fail - Minor
Inspection submitted
→ Fleet manager alerted, work order auto-created for tire replacement
Fleet manager reviews, approves continued use
→ Vehicle cleared for today, maintenance scheduled for tomorrow
Driver departs with documented defect
→ Full DOT compliance maintained with documented awareness