Daily Dispatch Sheet & Assignment
Build an internal tool that assigns the day's loads and routes to drivers and equipment, checks for conflicts, gets one dispatcher approval, then publishes a clean per-driver dispatch sheet - replacing the whiteboard with a real record.
A logged-in dispatch board where you assign loads to drivers and equipment, get an automatic conflict and availability check, approve the day in one click, and send each driver a printable dispatch sheet.
Before you start
- A free Supabase account
- A free Vercel account
- A free Resend account
- Your day's loads/routes as a spreadsheet or CSV (no API needed)
The problem this kills
Every morning the dispatch whiteboard gets wiped and rebuilt from scratch. Loads get assigned to drivers in your head, on sticky notes, or in a group text. Then a truck gets double-booked, a driver who is out of hours gets a run anyway, the reefer load lands on a dry van, and nobody can answer "who had load 4471 yesterday?" because the board was erased.
The whiteboard has no memory, no conflict check, and no approval step. When something goes wrong there is no record of who assigned what, when, or why.
What you'll build
A simple, private web app for your dispatch desk:
- Pull in the day's loads and routes and your driver and equipment availability from a spreadsheet - no integration required.
- Assign each load to a driver and a piece of equipment on a daily board.
- An automatic conflict check that flags double-booked drivers or trucks, equipment that does not match the load (reefer vs. dry van), and drivers who are over their hours-of-service or marked unavailable.
- A one-click dispatcher approval gate - nothing reaches drivers until a human signs off on the whole day.
- A clean per-driver dispatch sheet that is printable and emailed automatically, plus a live daily board for the whole team.
What's inside the Implementation Plan
The plan is a complete, paste-and-go runbook for an AI coding agent. It opens by interviewing you about your operation - your lanes, your equipment types, how you name loads, your HOS and availability rules, your peak-day volumes, and your messy exceptions - so the tool fits how you dispatch, not a generic template. The agent reads a short spec back to you and waits for your thumbs-up before it builds anything.
From there it walks you, one copy-paste prompt at a time, through standing up the database, the import, the assignment board, the conflict engine, the approval gate, and the driver sheets - in an afternoon.
The governance it includes (this is the point)
- Login so only your dispatch team can open the tool.
- Row-level security so you only ever see your own company's loads and drivers.
- A full audit trail - who assigned which load, who approved the day, and exactly when.
- A hard human-in-the-loop approval gate: the tool drafts the day's assignments, the dispatcher reviews and approves, and only then are driver sheets published.
- Duplicate guards so the same driver can't be dispatched twice for the same date.
Who it's for
Dispatchers who are tired of rebuilding the whiteboard every morning, and drivers who want a clear sheet they can trust. If you run trucks, vans, crews, or equipment and assign work day by day, this is for you.
You've got this - paste the first prompt and let the agent interview you.