Trailer & Yard Check-in Log
Build your own yard log that tracks every trailer from gate-in to gate-out, shows what's in the yard right now, and runs a live detention clock so you can dispute carrier charges with facts.
A live, login-protected yard board that logs trailers in and out, assigns yard spots and doors, times detention against each carrier's free window, flags seal mismatches, and exports a supervisor-approved detention report as CSV.
Before you start
- A free Supabase account
- A free Vercel account
- A free Resend account (for over-free-time alerts)
- Your gate-in fields and yard map (spots/doors)
The problem this kills
Right now your yard lives in someone's head, a clipboard, and a whiteboard that's wrong by mid-morning. Nobody can answer "what's in the yard right now?" without walking it. When a carrier bills you for detention, you have no clean timeline to push back, so you pay charges you don't actually owe. Seal numbers get eyeballed instead of checked. And the same trailer gets logged twice - or never.
That fuzziness costs real money: detention and demurrage fees you can't dispute, drivers idling on spots you didn't track, and audits you can't answer.
What you'll build
A simple web app your yard team logs into to run the whole gate flow:
- Gate-in - scan or type the trailer number, carrier, seal number, and load type; the tool assigns a yard spot or dock door.
- A live "what's in the yard now" board - every trailer, where it's parked, how long it's been here.
- A detention clock per trailer - counting against each carrier's free-time window, turning red when it's blown.
- A seal check at gate-out - the tool flags any mismatch between the gate-in seal and the gate-out seal before the trailer can leave.
- A supervisor approval gate - a manager approves every gate-out and signs off on the detention claim summary before it leaves the building.
- A clean CSV detention report - the exact timeline and totals you hand to billing or a carrier dispute.
What's inside the Implementation Plan
- It starts by interviewing you about your yard. Before a single line is built, the plan has the AI agent ask you about your gate process, your carriers and their free-time rules, your seal and trailer-number conventions, your yard map, and your messy edge cases (drop trailers, live loads, swaps). It reads a short tailored spec back to you and waits for your thumbs-up - so you get a tool shaped to your yard, not a generic template.
- A step-by-step build you complete by pasting ready-made prompts into your AI coding agent.
- A data model tuned to your real fields and naming.
- The detention timer logic, free-time rules, and over-free-time email alert.
- The seal-mismatch validation and duplicate guard.
- A "No API yet?" fallback so you can run the whole thing from a Google Sheet / CSV today, with no integration to your TMS or WMS.
The governance it includes (this is the point)
This isn't a toy. The plan builds in the controls that make it safe to run a real yard on:
- Login so only your team can see and touch the yard.
- Row-level security so each site/org only ever sees its own trailers.
- A complete audit trail - who gated a trailer in, who assigned the spot, who approved the release, and exactly when.
- A human-in-the-loop approval gate - the tool drafts the gate-out and the detention claim, but a supervisor must review and approve before anything is finalized or exported.
- Duplicate guards - the same trailer can't be gated in twice for the same arrival.
Who it's for
Yard jockeys, shipping/receiving clerks, and dock managers who are tired of guessing what's in the yard and eating detention charges they can't dispute. If you can describe your gate process out loud, you can build this.
You've got this - paste the first prompt and let the interview tailor it to your yard.