Dashboard
Clinic summary and patient overview
Total Patients
–
All registered
Active Patients
–
Currently monitored
Pending Doses
–
Upcoming vaccine
Low Stock Items
–
Need restocking
| Patient ID | Name | Age/Sex | Bite Date | Category | Branch | Status |
|---|
Patients
All registered patients
| Patient ID | Name | Age/Sex | Bite Date | Category | Barangay | Branch | Status | Actions |
|---|
Vaccine Schedule
Auto-generated Essen protocol schedule
| Schedule ID | Patient | Dose | Target Date | Status | Date Given | Actions |
|---|
Inventory
Vaccine stock management
Total Items
–
Vaccine types
In Stock
–
Adequate supply
Low Stock
–
Below minimum
Out of Stock
–
Zero quantity
| Item Name | Brand | Unit | Qty | Min Stock | Stock Level | Expiry | Branch | Actions |
|---|
Billing
Patient charges and payment records
Total Billed
–
This month
Paid
–
Completed payments
Unpaid
–
Pending collection
| OR Number | Patient | Date | Service | Amount | Paid | Balance | Status | Actions |
|---|
Setup Sheets
Connect to Google Apps Script backend
Setup Guide
1
Open your Google Spreadsheet → Extensions → Apps Script
2
Paste all code from Code.gs → Save → Run setup() → Authorize
3
Deploy → New Deployment → Web App. Execute as: Me. Access: Anyone
4
Copy the Web App URL and paste it above → Save → Test Connection
5
Click Create / Fix Sheet Headers to initialize all sheet columns
Multi-branch: Each branch can share the same spreadsheet. Patient IDs include branch prefix (e.g.,
SABC-MAIN-2026-0001).