Patient Tracker Template

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

Healthcare

Tables

Patients, Appointments

Fields

25

Views

grid, kanban, calendar, form, dashboard

Tables, columns and sample rows

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.

Patients

16 fields · 4 sample rows

  • Patients (Grid)
  • Treatment board (Kanban)
PatientTextDate of BirthDateAgeFormulaPhonePhoneEmailEmailPrimary ProviderSingle selectConditionTextTreatment StatusSingle selectInsurance ProviderTextPolicy NumberTextAppointmentsLink to another tableTotal VisitsCountLatest AppointmentRollupBilledRollupDocumentsAttachmentNotesLong text
Anil Deshmukh9 May 197155+91 98220 11223[email protected]Dr. Rahul VermaLower back pain (L4-L5 disc bulge)Under treatmentStar HealthSH-778123455 Nov 2026 00:00, 12 Nov 2026 00:00, 20 Nov 2026 00:0031795132800000₹3,100
Rachel Green17 Feb 198541+1 646 555 0175[email protected]Dr. Sophia MartinsGeneralised anxietyMonitoringAetnaAET-5512016 Nov 2026 00:00, 19 Nov 2026 00:0021795046400000₹2,000
Mohammed Irfan26 Sep 199927+91 99000 44556Dr. Neha KapoorACL reconstruction rehabUnder treatmentNiva BupaNB-3021987621 Nov 2026 00:0011795219200000₹1,200
Saroja Reddy12 Dec 195372+91 94400 66778Dr. Rahul VermaKnee osteoarthritisDischarged20 Sep 2026 00:0011789862400000₹1,000
Field details
Patient · Text
Date of Birth · Date
Age · Formula
IF({Date of Birth}, DATETIME_DIFF(TODAY(), {Date of Birth}, 'years'), BLANK())
Phone · Phone
Email · Email
Primary Provider · Single select
Dr. Neha Kapoor, Dr. Rahul Verma, Dr. Sophia Martins
Condition · Text
Treatment Status · Single select
New, Under treatment, Monitoring, Discharged, Inactive
Insurance Provider · Text
Policy Number · Text
Appointments · Link to another table
Links to Appointments
Total Visits · Count
Latest Appointment · Rollup
max of Appointment via Appointments
Billed · Rollup
sum of Fee via Appointments
Documents · Attachment
Notes · Long text

Appointments

9 fields · 7 sample rows

  • Appointment book (Grid)
  • Calendar (Calendar)
  • Status board (Kanban)
  • Request an appointment (Form)
  • Practice stats (Dashboard)
AppointmentDatePatientLink to another tableProviderSingle selectReasonTextLengthDurationStatusSingle selectFeeCurrencyPaidCheckboxVisit NotesLong text
5 Nov 2026Anil DeshmukhDr. Rahul VermaInitial assessment0:45Completed₹1,500YesMRI reviewed. Start physio 3×/week.
12 Nov 2026Anil DeshmukhDr. Rahul VermaPhysio session0:30Completed₹800Yes
20 Nov 2026Anil DeshmukhDr. Rahul VermaPhysio session0:30Scheduled₹800
16 Nov 2026Rachel GreenDr. Sophia MartinsTherapy check-in0:50No-show₹0
19 Nov 2026Rachel GreenDr. Sophia MartinsRescheduled therapy check-in0:50Checked in₹2,000
21 Nov 2026Mohammed IrfanDr. Neha KapoorWeek 6 rehab review0:30Scheduled₹1,200
20 Sep 2026Saroja ReddyDr. Rahul VermaDischarge review0:20Completed₹1,000Yes
Field details
Appointment · Date
Patient · Link to another table
Links to Patients
Provider · Single select
Dr. Neha Kapoor, Dr. Rahul Verma, Dr. Sophia Martins
Reason · Text
Length · Duration
Status · Single select
Scheduled, Checked in, Completed, No-show, Cancelled
Fee · Currency
INR
Paid · Checkbox
Visit Notes · Long text

Form view “Request an appointment” asks for: Appointment, Patient, Provider, Reason.

Patient Tracker Template: questions

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.

Related templates