// work / software development
Clinic appointments and patient records system
A booking and patient-records web app for a multi-doctor clinic, with doctor schedules, SMS reminders and a records screen built around the consultation.
- Client
- Private outpatient clinic
- Industry
- Healthcare
- Year
- 2024
- Role
- Full-stack developer
- Duration
- 8 weeks
Context
A four-doctor outpatient clinic booked everything in a paper diary and kept patient notes in folders. It worked, until it did not: double bookings when two receptionists were on, no-shows at around one in five appointments, and finding a returning patient’s history meant a trip to the filing room while the doctor waited.
The problem
The clinic wanted three things: a booking system the front desk could learn in a morning, fewer no-shows, and patient notes available in the consultation room. They did not want a cloud subscription that held their patient data, and the budget was fixed.
Approach
Booking. The calendar is a week view with one column per doctor, mirroring the paper diary so the front desk did not have to relearn their mental model. Slot lengths, breaks and leave are set per doctor. Booking a returning patient is a name search and two clicks.
Reminders. Each appointment gets an SMS the evening before and a second one two hours ahead, through Twilio. Replies of “C” cancel the slot and free it; the reminder status shows on the calendar so staff can see who has confirmed.
Records. The patient screen is built around the consultation: demographics at the top, visit history in reverse order, current prescriptions, allergies always visible. Doctors add notes during or straight after the visit on a tablet.
Hosting. The whole thing runs on a small server in the clinic’s office in Docker containers, with nightly encrypted backups copied off-site. I wrote the restore procedure and ran it with the practice manager so they know it works.
I built the system in weekly slices with the practice manager testing each one on a staging copy, which is why the front desk needed almost no training when it went live.
Outcome
Missed appointments fell by about 38% in the first three months, almost entirely from the reminders and the ability to cancel by text. Double bookings stopped. Doctors have the patient history in front of them before the patient sits down.
The clinic has since added a fifth doctor, which took ten minutes of configuration rather than a new diary.