On-site mobile detailing with a 4-van fleet: dynamic vehicle quoter across 88 services, deterministic load balancing and a database-less CRM.
The case at a glance
4
home visits served at once, with no double bookings
- The problem
- Coordinate 4 vans across home visits at the same time and bill without double bookings.
- What it does today
- It quotes on its own across 88 services and 142 prices, and holds the slot for 15 minutes until payment arrives.
- What failed and how it was fixed
- A separate database next to the CRM kept every booking in two places. The database was removed and the CRM became the single record.
- Where a person decides
- The crew marks each service as delivered from its app, at the client's home.
Try it
- Get a quote by vehicle(opens another site in a new tab)
Live site: you can get a quote without booking.
How I solved it

4 self-contained vans · one visit is one van at one house
Gallery · live site captures
The same site, on every screen.



For those who want the detail
How it's built
System architecture
Under the hood.
The system's real parts and how they talk: pick a path or open a component.
The whole system
12 components, 12 connections and 3 guided paths.
Open a component to see what it receives, where it sends and which paths include it.
Components
- Clients and fleet — Web and mobile fleet
- Web quoter — 88 prods · 142 prices
- Crew mobile app — /cuadrilla · mobile
- Member portal — /mi-membresia
- Fleet router — 4-van rotation
- 15-min hold — Lazy expiration
- Membership engine — Credits from visits
- 4 GHL calendars — Vans 1 to 4
- appointmentStatus — new → confirmed → showed
- Contacts & deals — HighLevel CRM
- Payment webhook — Secret HMAC signature
- Idempotency-Key — Receipt in appointment
Connections
- Clients and fleet → Web quoter: Quotes
- Clients and fleet → Crew mobile app
- Web quoter → Fleet router: Availability
- Crew mobile app → 15-min hold: Reads stop
- Member portal → Membership engine: Check balance
- Fleet router → 4 GHL calendars: Assigns van
- Fleet router → 15-min hold
- 15-min hold → appointmentStatus: 15m hold
- 4 GHL calendars → appointmentStatus: Slot check
- Membership engine → Contacts & deals: Counts visits
- Payment webhook → appointmentStatus: Confirms
- Payment webhook → Idempotency-Key: Verifies
Guided paths
- Quoting and booking
- Quotes by body type; the agenda sums durations and finds a free van for the whole visit. Verified webhook confirms it.
- Field crew ops
- At each home the crew marks stop outcome with one hand (attended, cash, noshow). Directly updates HighLevel without a DB.
- Zero Postgres (Database-less)
- Zero SQL databases: state lives in HighLevel calendars and contacts. Concurrency resolved by slot checks and van rotation.
Read the case as text
01 · The challenge
Coordinate 4 self-contained vans across concurrent home visits and bill without maintaining a dedicated database or desyncs.
02 · Constraints
- A visit is one van at one address (additive durations).
- A real catalogue of 88 products and 142 vehicle prices.
- Tactile usage by outdoor crews with wet hands.
03 · Decisions
- 01Database-less architecture with Webhooks: GoHighLevel as the single store for appointments, contacts and invoices, 100% webhook-orchestrated.
- 02Dynamic body-type quoter with 15-minute temporary holds.
- 03Deterministic router with 4-van load balancing and collision fallback.
- 04Lightweight mobile crew app with one-tap stop resolution.
04 · Outcome
A 4-van operation synchronized in real time with self-service booking and zero database overhead.
Built for clients of AD Media Solution.






