Fixture & Tooling Location Registry: Find the Right Jig in Seconds

The problem this kills

A setup tech needs the fixture for job 4471. Where is it? Maybe it's on the rack by cell 3. Maybe it's still on the last machine that ran the part. Maybe it went out for repair last month and nobody wrote it down. So the tech walks the plant, asks three people, opens four cabinets, and a half-hour later either finds it or gives up and starts hunting for the backup. Meanwhile the machine sits idle and the schedule slips.

The "system" is usually somebody's memory, a label maker, and a spreadsheet that's three moves out of date. Nobody knows which jigs are damaged until they're clamped on a part. Tools get scrapped that someone needed, and tools get "borrowed" and never come back. You don't need an MES or a six-figure tooling-management suite to fix this — and you don't need to be a developer.

What you'll build

A simple internal web tool. You import your fixture / tooling list — each fixture's ID, what part or job it's used for, its storage location, its status (in use, in storage, out for repair, scrapped), and its condition. Then anyone on the team can search by part or job number and instantly see which fixture they need, where it is right now, and whether it's healthy enough to run. When a fixture moves — onto a machine, into storage, out to a vendor for repair, or to the scrap pile — someone proposes the change, and a tool-room lead reviews and approves it before the registry updates. Damaged and out-for-repair fixtures are flagged so nobody grabs one that won't hold tolerance. At any point you can export the whole registry as a clean CSV.

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 — how setup people find fixtures today, what you call your fixtures and how their IDs are numbered, exactly which columns your list uses, how you link a fixture to the parts and jobs it serves, what statuses and conditions you track, your typical and peak fixture counts, and the messy edge cases (one fixture for many parts, a fixture loaned between cells, a duplicate ID) — and then it tailors the data model, the search, 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 the import, the search-by-part screen, the location/status change request, the tool-room approval gate, and the registry export — each step with a ready-to-copy prompt. There's also a fallback so you can build the whole thing today even with no link to your ERP or MES.

The governance it includes (this is the point)

This is real shop-floor tooling, so it ships with the controls a plant needs: login so only your team can use it, row-level security so you only ever see your own plant's fixtures, a complete audit trail of who moved or re-classified which fixture and when, a hard human-approval gate so no location, status, or scrap change is committed until the tool-room lead signs off, and duplicate guards keyed on fixture ID so the same fixture can't be entered twice. The riskiest changes — sending a fixture out for repair or scrapping it — always pass through a person.

Who it's for

Setup techs, tool-room and crib staff, and production supervisors who lose time every shift tracking down fixtures, jigs, and special tooling. If you can describe how your shop names its fixtures and decides where they live, you can build this.

You've got this — start with the plan, paste the first prompt, answer the interview, and you'll be searching for fixtures by job number the same afternoon.