Context
A mid-size medical clinic was managing all appointments exclusively by phone. The receptionist handled a paper schedule and sent reminders manually. The process was slow, error-prone, and resulted in a high no-show rate.
Problem
The no-show rate reached 28% of scheduled appointments, causing direct revenue loss and wasted availability. Peak morning call volume also overwhelmed the front desk, creating wait queues and patient frustration.
Solution
I built a full-stack web portal with Next.js, enabling patients to book, reschedule, and cancel appointments on their own. The system sends immediate email confirmations and automatic reminders 48h and 2h before each appointment via SMS (Twilio) and email (Resend).
I chose a simple, low-cost architecture: PostgreSQL on Supabase (free tier), a Node.js API, and Vercel deployment. The admin dashboard lets the clinic configure available slots, view occupancy reports, and export billing data. Google Calendar integration keeps the schedule synchronized in real time.
Result
Within 60 days, the no-show rate dropped from 28% to 8%, a result directly attributable to automatic reminders. Schedule occupancy grew by 35% because cancellations were now made in advance, freeing slots that were filled from a waitlist. The reception team shifted focus from managing calls to in-person patient care.