Track each patient’s treatment status and insurance alongside a linked appointment book with providers, fees and no-shows.
Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.
Category
Tables
Patients, Appointments
Fields
25
Views
grid, kanban, calendar, form, dashboard
The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.
16 fields · 4 sample rows
| PatientText | Date of BirthDate | AgeFormula | PhonePhone | EmailEmail | Primary ProviderSingle select | ConditionText | Treatment StatusSingle select | Insurance ProviderText | Policy NumberText | AppointmentsLink to another table | Total VisitsCount | Latest AppointmentRollup | BilledRollup | DocumentsAttachment | NotesLong text |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Anil Deshmukh | 9 May 1971 | 55 | +91 98220 11223 | [email protected] | Dr. Rahul Verma | Lower back pain (L4-L5 disc bulge) | Under treatment | Star Health | SH-77812345 | 5 Nov 2026 00:00, 12 Nov 2026 00:00, 20 Nov 2026 00:00 | 3 | 1795132800000 | ₹3,100 | ||
| Rachel Green | 17 Feb 1985 | 41 | +1 646 555 0175 | [email protected] | Dr. Sophia Martins | Generalised anxiety | Monitoring | Aetna | AET-55120 | 16 Nov 2026 00:00, 19 Nov 2026 00:00 | 2 | 1795046400000 | ₹2,000 | ||
| Mohammed Irfan | 26 Sep 1999 | 27 | +91 99000 44556 | Dr. Neha Kapoor | ACL reconstruction rehab | Under treatment | Niva Bupa | NB-30219876 | 21 Nov 2026 00:00 | 1 | 1795219200000 | ₹1,200 | |||
| Saroja Reddy | 12 Dec 1953 | 72 | +91 94400 66778 | Dr. Rahul Verma | Knee osteoarthritis | Discharged | 20 Sep 2026 00:00 | 1 | 1789862400000 | ₹1,000 |
9 fields · 7 sample rows
| AppointmentDate | PatientLink to another table | ProviderSingle select | ReasonText | LengthDuration | StatusSingle select | FeeCurrency | PaidCheckbox | Visit NotesLong text |
|---|---|---|---|---|---|---|---|---|
| 5 Nov 2026 | Anil Deshmukh | Dr. Rahul Verma | Initial assessment | 0:45 | Completed | ₹1,500 | Yes | MRI reviewed. Start physio 3×/week. |
| 12 Nov 2026 | Anil Deshmukh | Dr. Rahul Verma | Physio session | 0:30 | Completed | ₹800 | Yes | |
| 20 Nov 2026 | Anil Deshmukh | Dr. Rahul Verma | Physio session | 0:30 | Scheduled | ₹800 | ||
| 16 Nov 2026 | Rachel Green | Dr. Sophia Martins | Therapy check-in | 0:50 | No-show | ₹0 | ||
| 19 Nov 2026 | Rachel Green | Dr. Sophia Martins | Rescheduled therapy check-in | 0:50 | Checked in | ₹2,000 | ||
| 21 Nov 2026 | Mohammed Irfan | Dr. Neha Kapoor | Week 6 rehab review | 0:30 | Scheduled | ₹1,200 | ||
| 20 Sep 2026 | Saroja Reddy | Dr. Rahul Verma | Discharge review | 0:20 | Completed | ₹1,000 | Yes |
Form view “Request an appointment” asks for: Appointment, Patient, Provider, Reason.
Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.
Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.
Record blood pressure and pulse readings with arm and posture, auto-classified into ACC/AHA stages with crisis readings flagged.
1 table · 14 fieldsBlood Sugar Log SheetA diabetes diary for glucose readings around meals, insulin, carbs and activity, with each reading checked against its target range.
1 table · 13 fieldsBMI TrackerLog weight and height check-ins per person, get BMI and its WHO category automatically, and track progress toward a goal weight.
2 tables · 20 fieldsCaregiver LogShift-by-shift care notes for each person you look after: meals, fluids, medication, mood, activities and handover notes.
2 tables · 27 fieldsCholesterol Screening SheetRecord lipid panels at screening camps or clinics, with non-HDL, ratios and NCEP risk bands calculated and follow-up dates suggested.
1 table · 18 fieldsCOVID-19 Log SheetScreen every clinic visitor at the door for temperature, symptoms and exposure, with an automatic cleared-or-refer result for contact tracing.
1 table · 15 fields