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
Tables
Patients, Visits, Medications
Fields
40
Views
grid, calendar, form
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.
17 fields · 3 sample rows
| PatientText | MRNAutonumber | Date of BirthDate | AgeFormula | SexSingle select | Blood GroupSingle select | PhonePhone | AddressAddress | Emergency ContactText | AllergiesMultiple select | Chronic ConditionsMultiple select | Primary PhysicianText | VisitsLink to another table | Visit CountCount | Last VisitRollup | MedicationsLink to another table | Current MedicationsLookup |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sunil Bhatt | MRN-00001 | 11 Aug 1964 | 62 | Male | B+ | +91 98250 11223 | 21 Shanti Nagar, Ahmedabad, Gujarat, 380015, India | Hema Bhatt (wife) +91 98250 44556 | Penicillin | Type 2 diabetes, Hypertension | Dr. Desai | 21 Aug 2026, 19 Nov 2026 | 2 | 1795046400000 | Metformin 500 mg, Amlodipine 10 mg | Metformin 500 mg, Amlodipine 10 mg |
| Claire Dubois | MRN-00002 | 29 Mar 1987 | 39 | Female | O+ | +33 6 55 55 02 34 | 8 Rue Lafayette, Paris, 75009, France | Luc Dubois +33 6 55 55 07 89 | No known allergies | Asthma | Dr. Desai | 5 Nov 2026 | 1 | 1793836800000 | Budesonide-formoterol inhaler | Budesonide-formoterol inhaler |
| Meenakshi Sundaram | MRN-00003 | 5 Nov 1949 | 77 | Female | A+ | +91 94440 77889 | Karthik (son) +91 98400 22113 | Sulfa drugs, NSAIDs | Hypothyroidism, CKD | Dr. Raman | 16 Nov 2026 | 1 | 1794787200000 | Levothyroxine 50 mcg | Levothyroxine 50 mcg |
16 fields · 4 sample rows
| Visit DateDate | PatientLink to another table | Visit TypeSingle select | ProviderText | Chief ComplaintText | SystolicNumber | DiastolicNumber | BPFormula | PulseNumber | Temp (°F)Number | SpO₂ (%)Number | Weight (kg)Number | DiagnosisText | Plan & PrescriptionLong text | Follow-up DateDate | ReportsAttachment |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21 Aug 2026 | Sunil Bhatt | Annual check-up | Dr. Desai | Routine diabetes review | 142 | 90 | 142/90 | 80 | 98.2 | 98 | 84.0 | T2DM, uncontrolled HTN | Increase amlodipine to 10 mg. HbA1c in 3 months. | 19 Nov 2026 | |
| 19 Nov 2026 | Sunil Bhatt | Follow-up | Dr. Desai | BP and sugar review | 130 | 82 | 130/82 | 76 | 98.4 | 98 | 82.5 | T2DM, HTN – improving | Continue current medicines. Diet counselling. | 17 Feb 2027 | |
| 5 Nov 2026 | Claire Dubois | New problem | Dr. Desai | Wheezing for 3 days | 118 | 74 | 118/74 | 96 | 99.1 | 95 | 61.0 | Acute asthma exacerbation | Nebulisation in clinic. Budesonide-formoterol inhaler. | 12 Nov 2026 | |
| 16 Nov 2026 | Meenakshi Sundaram | Teleconsult | Dr. Raman | Fatigue, swelling of feet | 136 | 84 | 136/84 | 58.0 | CKD stage 3 – fluid retention | Renal function tests. Reduce salt intake. | 23 Nov 2026 |
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.
7 fields · 4 sample rows
| MedicationText | PatientLink to another table | DoseText | FrequencySingle select | StartedDate | Prescribed ByText | ActiveCheckbox |
|---|---|---|---|---|---|---|
| Metformin 500 mg | Sunil Bhatt | 1 tablet after meals | Twice daily | 19 Dec 2024 | Dr. Desai | Yes |
| Amlodipine 10 mg | Sunil Bhatt | 1 tablet | Once daily | 21 Aug 2026 | Dr. Desai | Yes |
| Budesonide-formoterol inhaler | Claire Dubois | 2 puffs | Twice daily | 5 Nov 2026 | Dr. Desai | Yes |
| Levothyroxine 50 mcg | Meenakshi Sundaram | 1 tablet empty stomach | Once daily | 7 Aug 2023 | Dr. Raman | Yes |
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