· Back to the setup

AI Setups That Work

Build your own job and bid tracker

Researched

What it does

Build a small job and bid tracker with Claude Code that runs on your own computer, so you can drop a paid tracker you only use for lists and follow-up dates.

Who it is for

Solo trades and small shops that pay for a job tracker but only use it to list jobs, bids, statuses and follow-up dates.

Tools

Steps

  1. Check whether the paid tool lets you export your jobs, usually as a CSV file. Do this first. If it does not, stop here and keep the tool.
  2. Write down what you actually use, in a short list: the fields on a job, the statuses, the views and the reminders. Anything not on the list stays out of the app. Invoices, payments and customer messages stay in the tool or in your usual process.
  3. Make a new folder and open Claude Code in it in Manual mode (cd into the folder, then claude --permission-mode manual). In Manual mode Claude Code stops and asks before most consequential actions, such as editing files or running commands, though not before every read. Newer versions start in auto mode by default, so check the mode indicator.
  4. Paste the prompt below with your fields and statuses. Read what Claude Code wants to do and approve each action.
  5. Start the app as Claude Code tells you. Load the made-up jobs, then check each view, the follow-up list, the search and the export.
  6. Check the network behavior. Look at the address the app is listening on and confirm it is the local address only, then try opening it from another device on the same network; it should not load. Do this before any customer data goes in.
  7. Import your real export only after those checks pass. Compare the number of jobs in the old tool with the number in the app, and spot-check a handful of jobs against the originals.
  8. Run both tools for a full cycle of jobs. Cancel the paid tool only after that, and keep the export file.
  9. Set up the backup. Copy the data file to a second place on a schedule you can keep, and try a restore once.

The prompt

Build a small job and bid tracker that runs only on this computer. Use a language and tools you can run here. Keep it simple.

What it must do:
- A web page I open in my browser, served only on this computer (localhost), so nobody else on the network can open it.
- One data file in this folder, in a format I can open in a spreadsheet (CSV is fine). All jobs live in that file.
- Each job has: customer name, phone, address, job type, status, bid amount, date bid sent, follow-up date and notes.
- Statuses: Lead, Bid sent, Follow up, Won, Lost, Done.
- Views: all jobs, a "Follow up today or overdue" list, and a search by name or address.
- Add, edit and delete a job, with a confirm step on delete.
- A button to export all jobs to a CSV, and a button that saves a dated backup copy of the data file.
- An import from a CSV with the same columns, which shows how many rows it will add before it adds them.

What it must not do:
- No sending of email, text or anything else. No internet access. No accounts or payments.
- No change to files outside this folder.

First load 5 made-up jobs so I can try it, for example "Pat Ortiz, 14 Birch Lane, furnace repair, Bid sent, 850, sent Nov 9, follow up Nov 16". Then tell me how to start it, and what to check. Before you run anything, say what you will do.

Tips

Sources