HOSPITAL APPOINTMENT SCHEDULING SYSTEM

Abstract

The City Care Hospital Appointment Scheduling System is a lightweight serverless web application that coordinates appointment intake, capacity validation, patient status retrieval, and preliminary symptom guidance without a dedicated database server. The implementation combines an HTML5, CSS3, JavaScript, and Bootstrap 5 portal with Google Forms, Google Apps Script, and Google Sheets. Script-level mutual exclusion prevents concurrent submissions from consuming the same final slot, while date and capacity rules automatically assign CONFIRMED, Rejected(Past Date), or Rejected(Full) states. A browserbased keyword routing engine maps symptom descriptions to a specialist and first-aid guidance, and a sanitized phone lookup returns the latest booking result. Project evaluation recorded a 142 ms average lock-acquisition time, less than 5 ms client-side triage latency, 100% phone-format matching, zero capacity overbooking, and zero past-date acceptance. The resulting architecture offers a low-cost and maintainable outpatient scheduling prototype for small and medium healthcare facilities.