Medical Chart Template

A lightweight patient chart: demographics, allergies and conditions, every visit with vitals and diagnosis, and current medications.

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, Visits, Medications

Fields

40

Views

grid, calendar, form

Tables, columns and sample rows

The 3 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Patients

17 fields · 3 sample rows

  • Patients (Grid)
PatientTextMRNAutonumberDate of BirthDateAgeFormulaSexSingle selectBlood GroupSingle selectPhonePhoneAddressAddressEmergency ContactTextAllergiesMultiple selectChronic ConditionsMultiple selectPrimary PhysicianTextVisitsLink to another tableVisit CountCountLast VisitRollupMedicationsLink to another tableCurrent MedicationsLookup
Sunil BhattMRN-0000111 Aug 196462MaleB++91 98250 1122321 Shanti Nagar, Ahmedabad, Gujarat, 380015, IndiaHema Bhatt (wife) +91 98250 44556PenicillinType 2 diabetes, HypertensionDr. Desai21 Aug 2026, 19 Nov 202621795046400000Metformin 500 mg, Amlodipine 10 mgMetformin 500 mg, Amlodipine 10 mg
Claire DuboisMRN-0000229 Mar 198739FemaleO++33 6 55 55 02 348 Rue Lafayette, Paris, 75009, FranceLuc Dubois +33 6 55 55 07 89No known allergiesAsthmaDr. Desai5 Nov 202611793836800000Budesonide-formoterol inhalerBudesonide-formoterol inhaler
Meenakshi SundaramMRN-000035 Nov 194977FemaleA++91 94440 77889Karthik (son) +91 98400 22113Sulfa drugs, NSAIDsHypothyroidism, CKDDr. Raman16 Nov 202611794787200000Levothyroxine 50 mcgLevothyroxine 50 mcg
Field details
Patient · Text
MRN · Autonumber
Date of Birth · Date
Age · Formula
IF({Date of Birth}, DATETIME_DIFF(TODAY(), {Date of Birth}, 'years'), BLANK())
Sex · Single select
Female, Male, Other
Blood Group · Single select
A+, A−, B+, B−, AB+, AB−, O+, O−
Phone · Phone
Address · Address
Emergency Contact · Text
Allergies · Multiple select
No known allergies, Penicillin, Sulfa drugs, NSAIDs, Latex, Peanuts, Shellfish
Chronic Conditions · Multiple select
Type 2 diabetes, Hypertension, Asthma, Hypothyroidism, CKD, None
Primary Physician · Text
Visits · Link to another table
Links to Visits
Visit Count · Count
Last Visit · Rollup
max of Visit Date via Visits
Medications · Link to another table
Links to Medications
Current Medications · Lookup
Medication via Medications

Visits

16 fields · 4 sample rows

  • All visits (Grid)
  • Follow-ups (Calendar)
  • Record a visit (Form)
Visit DateDatePatientLink to another tableVisit TypeSingle selectProviderTextChief ComplaintTextSystolicNumberDiastolicNumberBPFormulaPulseNumberTemp (°F)NumberSpO₂ (%)NumberWeight (kg)NumberDiagnosisTextPlan & PrescriptionLong textFollow-up DateDateReportsAttachment
21 Aug 2026Sunil BhattAnnual check-upDr. DesaiRoutine diabetes review14290142/908098.29884.0T2DM, uncontrolled HTNIncrease amlodipine to 10 mg. HbA1c in 3 months.19 Nov 2026
19 Nov 2026Sunil BhattFollow-upDr. DesaiBP and sugar review13082130/827698.49882.5T2DM, HTN – improvingContinue current medicines. Diet counselling.17 Feb 2027
5 Nov 2026Claire DuboisNew problemDr. DesaiWheezing for 3 days11874118/749699.19561.0Acute asthma exacerbationNebulisation in clinic. Budesonide-formoterol inhaler.12 Nov 2026
16 Nov 2026Meenakshi SundaramTeleconsultDr. RamanFatigue, swelling of feet13684136/8458.0CKD stage 3 – fluid retentionRenal function tests. Reduce salt intake.23 Nov 2026
Field details
Visit Date · Date
Patient · Link to another table
Links to Patients
Visit Type · Single select
New problem, Follow-up, Annual check-up, Emergency, Teleconsult
Provider · Text
Chief Complaint · Text
Systolic · Number
Diastolic · Number
BP · Formula
IF(AND({Systolic}, {Diastolic}), {Systolic} & '/' & {Diastolic}, BLANK())
Pulse · Number
Temp (°F) · Number
SpO₂ (%) · Number
Weight (kg) · Number
Diagnosis · Text
Plan & Prescription · Long text
Follow-up Date · Date
Reports · Attachment

Form view “Visit note” asks for: Visit Date, Patient, Visit Type, Provider, Chief Complaint, Systolic, Diastolic, Pulse, Temp (°F), SpO₂ (%), Weight (kg), Diagnosis, Plan & Prescription, Follow-up Date, Reports.

Medications

7 fields · 4 sample rows

  • Medications (Grid)
MedicationTextPatientLink to another tableDoseTextFrequencySingle selectStartedDatePrescribed ByTextActiveCheckbox
Metformin 500 mgSunil Bhatt1 tablet after mealsTwice daily19 Dec 2024Dr. DesaiYes
Amlodipine 10 mgSunil Bhatt1 tabletOnce daily21 Aug 2026Dr. DesaiYes
Budesonide-formoterol inhalerClaire Dubois2 puffsTwice daily5 Nov 2026Dr. DesaiYes
Levothyroxine 50 mcgMeenakshi Sundaram1 tablet empty stomachOnce daily7 Aug 2023Dr. RamanYes
Field details
Medication · Text
Patient · Link to another table
Links to Patients
Dose · Text
Frequency · Single select
Once daily, Twice daily, Three times daily, At bedtime, As needed
Started · Date
Prescribed By · Text
Active · Checkbox

Medical Chart 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