The challenge
For years, Burns Auto Repair ran its entire schedule out of a paper appointment book. It worked — right up until it didn't. Reschedules meant whiting out the old entry and rewriting every detail on a new page. When two employees were on the phone at once, one had to wait for the book or walk to the other office to find it. Nobody could check availability without flipping through pages, and more than once a handwritten entry was anyone's best guess.
None of those are catastrophic on their own. Added up across every workday, they were a steady drain on time and patience — and the rules the shop wanted to enforce depended entirely on everyone remembering them.
What we did
We built a custom scheduling application running on a small server set up on a computer at the shop. A few decisions there were deliberate:
- Self-hosted, on-site. Running on the shop's own hardware means no monthly hosting or software fees, and the system is only reachable from inside the Burns Auto network — not sitting open on the public internet, which is the right call for anything holding customer and scheduling data.
- Works on any device. Because it's a web application, it runs in a browser on desktop, phone, or tablet. We set up a dedicated iPad for floor employees without their own desktop, so everyone can reach the schedule from where they actually work.
- Built on the shop's real rules. Rather than bending Burns Auto's process to fit an off-the-shelf tool, we rebuilt their existing scheduling logic directly into the system.
Under the hood it's a Node and Express backend with a MySQL database, and a React frontend the server builds and serves itself. In day-to-day use, that means: searching upcoming appointments by last name, seeing open days at a glance, rescheduling in a couple of clicks instead of with whiteout, enforcing limits on appointment counts and types automatically, multiple people working the schedule at once from different rooms, a printable daily copy for anyone who wants one, and a single running cancellation list for customers who want to be called if something opens up earlier.
It also tracks work schedules for the full-time mechanics and office manager, and set the stage for fully automated text reminders.
The result
The system has been running live for over three months and has handled 1,300+ appointments in that time — proof it's not a demo in the corner, but the thing the shop runs on every day. Finding an open day dropped from flipping through pages to a couple of seconds, roughly 90% faster, and double-bookings and whiteout reschedules are gone — not because everyone got more careful, but because the system makes them difficult by design.
If your business is running on a paper book, a spreadsheet, or a process that lives in one person's head, a tool built around how you already work can be simpler and cheaper than you'd expect. Get in touch and we'll talk through what would help.