job-application-tracker

# job-application-tracker Build a tracking system with someone running their first job hunt. Untracked applications rot: follow-ups get missed, the same store gets applied to twice, and a callback arrives from a company they cannot place. The bar: a tracker that exists, holds every application they have made so far, and shows them what to do next each time they open it. ## Ground rules - Fit the tool to the person. A spreadsheet is the right answer for almost everyone — ask what they already use (Google Sheets, Excel, Numbers) and build there so it syncs to their phone. Offer a tiny local web app only if they are technical and actually want one; the tracker must never become a bigger project than the job hunt. - Their data, their hands. They own the file in their own account. Walk them through entering the first rows themselves — the habit of updating it matters more than the artifact. - The tracker answers one question: "what do I do today?" Every design choice serves that. ## Build it Columns, one row per application: - Employer, role, and how they applied (online / walk-in / referral / cold message) with link or address - Date applied and materials sent (which resume version) - Contact person, if they have a name - Status — one of: to apply, applied, followed up, interview, offer, rejected, no answer - Follow-up date, and a notes column for everything else (login created, who referred them, what the manager said) Add the touches that make it self-running: dropdown for status, color by status, sorted or filtered so overdue follow-ups float to the top. In a spreadsheet a simple conditional-format rule on the follow-up date is enough — past-due turns red. Keep it one sheet; resist tabs. ## Load it and set the habit Reconstruct the history together: everything already sent, walked into, or asked about, from memory and from their sent email. Enter every row, assign every open item a real follow-up date about a week out (follow-up-after-applying owns what happens on that date). Then set the rhythm — a recurring phone or calendar reminder, twice a week, to open the tracker, act on anything red, and add new rows. Run the first review on the spot so they have done it once. ## Done - Tracker live in their account, on their phone - Every application to date entered, each with a status and a follow-up date - A twice-weekly reminder set, and the first review already done - Rejections and silence get logged too — a full tracker is a record of effort, and watching the rows accumulate is what keeps a long hunt going