In-Process & Final Inspection Checklist: Catch Out-of-Spec Before the Lot Moves
Turn an inspection plan into a guided checklist that captures measurements against tolerance and pass/fail with photos, auto-flags out-of-spec results, and holds the lot until your QC lead approves the disposition.
A web tool where you load an inspection plan, an inspector records variable measurements and attribute pass/fail with photos per unit or lot, AI auto-flags anything out of tolerance, your QC lead reviews and approves pass/hold/scrap, the lot is held until finalized, hold notices go out via Resend, and results export as a clean CSV for SPC analysis.
Before you start
- A Supabase account (free)
- A Vercel account (free)
- A Resend account (free)
- Your inspection plan / characteristics list with specs and tolerances
- A sample of recorded inspection results (CSV or paper to mimic)
- Claude Code or any AI coding agent
The problem this kills
Your inspectors are recording quality checks on a clipboard or in a spreadsheet someone built three years ago. Specs and tolerances live in a separate document — or in someone's head. A measurement that's out of tolerance only gets caught if the inspector happens to do the arithmetic in the moment, and a failing lot can roll forward before anyone with authority weighs in. Photos of the defect end up on a phone and never make it to the record.
The result is the stuff quality teams dread: out-of-spec product shipped because nobody flagged it, lots released without a real disposition decision, the same serial inspected twice (or never), and an audit where you can't show who approved what. You don't need an expensive QMS and you don't need to be a developer to fix this — you need a checklist that does the math, flags the failures, and refuses to release a lot until a human signs off.
What you'll build
A simple internal web tool. You load your inspection plan — the list of characteristics, each with its spec, tolerance, and whether it's a variable measurement (a number, like a diameter) or an attribute check (pass/fail, like "no burrs"). An inspector picks the unit or lot, walks the checklist on a phone or tablet, types in measurements and pass/fail results, and snaps photos right into the record. The tool compares every measurement to its tolerance as it's entered and lights up anything out of spec. When the inspection is submitted, any out-of-spec result puts the lot on hold — it can't be released. Your QC lead opens the flagged inspection, reviews the readings and photos, and decides the disposition: pass, hold, or scrap. Only after that approval is the inspection finalized and the lot allowed to move. Hold notices go out automatically via Resend, and you can export all the results as a clean CSV for SPC (statistical process control) or any other analysis.
What's inside the Implementation Plan
The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your business — what you inspect and at which inspection points, what your inspection plans look like and how specs and tolerances are written, the exact naming of your characteristics, how you identify a unit or lot (serial, lot, batch, work order), your typical and peak inspection volumes, who has authority to disposition a failing lot, and the messy edge cases like rework, conditional accept, and partial lots — and then it tailors the data model, the tolerance checks, and every later step to your answers. This is not a generic template; the agent reflects a short spec back to you and waits for your thumbs-up before it builds anything. From there it walks the agent through loading the plan, the inspector capture screen with photos, the automatic out-of-spec flagging, the QC-lead review-and-disposition gate, the hold/finalize flow, the Resend hold notices, and the SPC-ready CSV export — each step with a ready-to-copy prompt. There's also a fallback so you can build and use the whole thing today even with no connection to your ERP or MES.
The governance it includes (this is the point)
This is real quality tooling, so it ships with the controls an auditor expects to see: login so only your team can use it, row-level security so each plant or organization only ever sees its own inspections, a complete audit trail of who inspected, who flagged, and who dispositioned which lot and when, a hard human-approval gate so no failing lot is released until your QC lead approves the disposition, and duplicate guards keyed on the lot/serial plus inspection-point so the same unit can't be inspected and finalized twice. Failing lots are held, not released — the tool will not let product move past an open out-of-spec result.
Who it's for
Quality inspectors, line QC, and quality leads who record in-process and final inspections on paper or in a generic spreadsheet and want a guided, photo-capturing checklist that does the tolerance math and won't let a bad lot slip through. If you can describe your inspection plan and how your shop decides pass, hold, or scrap, you can build this.
You've got this — start with the plan, paste the first prompt, answer the interview, and you'll see your first inspection checklist flagging out-of-spec results the same afternoon.