Call Let's talk

Kingsport, TN · 423-967-5584

Case study 03 / System build from a prototype Jonesborough, Tennessee

Work / Case study 03

Shop with a Cop and Firefighter, from prototype to working system.

A holiday program in Jonesborough came to me with a careful plan that ran in one browser. Making it real, secure and live was what I was hired to do.

Client
Shop with a Cop and Firefighter · Jonesborough, TN
Project type
System build from a prototype
Scope
Season one scope, public forms, staff system, security, launch
Live at
swacf.jonesboroughtn.org, on the town's own domain
When
2026
The live Shop with a Cop and Firefighter landing page in navy and red, with the program logo, the headline Every kid in Jonesborough deserves a holiday to remember, and three paths for parents and guardians, community sponsors, and volunteers.

The live site

The prototype landing page before the build, in green and burgundy with the town logo, the same headline, and the same three paths for parents, sponsors and volunteers.

The prototype, before

Fig. 1 · The live landing page beside the prototype I built it from. Visit the live site

01 The problem

The plan was good. There was just nothing under it yet.

Each December, police officers and firefighters in Jonesborough take local kids shopping. The program already had a detailed prototype covering every form, field and rule, the household numbering, the shopping sheets and the printable forms. It also ran in a single browser, with no shared database, no staff logins and no email. So the prototype stated the plan, and everything it would take to run that plan for real families was the job I was hired for.

02 What I did

  1. Scoped season one

    I cut the first season down to the jobs that take the most staff time. Event day stays on paper this season. The dashboard, check-in, wristbands and per-child bag tags are planned for a later one.

  2. Kept the prototype as the blueprint

    I didn't start over. I built the working system underneath the plan the program had already made.

  3. Built the public forms

    Child registration, sponsor sign-up and volunteer sign-up, built to WCAG 2.1 AA, working on phones, with spam protection on each one.

    The child registration form on a phone, opening with parent or guardian fields for full legal name, home address and telephone number.
    Fig. 2 · The child registration form on a phone.
  4. Built the staff side

    Staff sign in with a single-use link sent by email, with no passwords. A review inbox lets them approve or deny with recorded reasons and assign the event at approval. Household numbers assign themselves, and the roster keeps a full change history.

    The staff review inbox showing a made-up test household with two children, a suggested event for each child, and buttons to approve and add to the roster or deny.
    Fig. 3 · The review inbox, with made-up test families.
    A made-up test child's roster record with event, sizes, guardian and household details, the approval email that was sent, and staff changes showing each old value crossed out beside the new one.
    Fig. 4 · A test record and its change history.
  5. Left the sending to staff

    I built sponsor assignment and shopping sheets. Each sponsor gets one email with every sheet attached, and sheets print for children the program shops for. Email goes out only when staff choose to send it. I also built a printable forms library and spreadsheet exports.

    The shopping sheets screen showing a made-up test sponsor with three children marked sent or approved, a button to send, a button to print instead, and a section for children the program shops for.
    Fig. 5 · Shopping sheets grouped by sponsor, with test data.
  6. Protected the records and launched

    Family records delete automatically 90 days after the season's last event. I gave staff a separate review copy so they could test everything without touching real families, then took the real system live.

03 The outcome

  • Signed off Staff tested it thoroughly On a separate review copy
  • Nov 1, 2026 Registration opened on its own At midnight
  • Live On the town's own domain swacf.jonesboroughtn.org

Send me the messy version.

Describe the problem on the contact form. I read every message myself and tell you where I would start.