COVID-19 Patient Symptom Tracker

Follow COVID-19 patients through isolation with daily temperature, SpO₂ and symptom check-ins that flag anyone who needs escalation.

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, Daily Check-ins

Fields

27

Views

grid, kanban, form, calendar

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)
  • Care board (Kanban)
PatientTextDate of BirthDateAgeFormulaPhonePhoneTest TypeSingle selectTest ResultSingle selectSymptom OnsetDateIsolation EndsFormulaRisk FactorsMultiple selectCare SettingSingle selectAttending DoctorTextCheck-insLink to another tableDays MonitoredCountLast Check-inRollupLowest SpO₂RollupPeak Temp (°F)Rollup
Arvind Kulkarni19 Jul 195868+91 98230 44556RT-PCRPositive15 Nov 202622 Nov 2026Age 60+, DiabetesHome isolationDr. Shah17 Nov 2026, 18 Nov 2026, 19 Nov 20263179504640000093102.1
Maria Gonzalez2 Nov 198937+1 213 555 0144Rapid antigenPositive16 Nov 202623 Nov 2026Home isolationDr. Shah18 Nov 2026117949600000009899.5
Farida Begum30 Mar 196660+91 99010 33445RT-PCRPositive13 Nov 202620 Nov 2026Hypertension, Asthma / COPDHospital wardDr. Iyer19 Nov 2026117950464000009299.1
Tom Becker14 May 199531RT-PCRPendingHome isolation0
Field details
Patient · Text
Date of Birth · Date
Age · Formula
IF({Date of Birth}, DATETIME_DIFF(TODAY(), {Date of Birth}, 'years'), BLANK())
Phone · Phone
Test Type · Single select
RT-PCR, Rapid antigen
Test Result · Single select
Positive, Negative, Pending
Symptom Onset · Date
Isolation Ends · Formula
IF({Symptom Onset}, DATEADD({Symptom Onset}, 7, 'days'), BLANK())
Risk Factors · Multiple select
Age 60+, Diabetes, Hypertension, Asthma / COPD, Heart disease, Immunocompromised, Pregnancy
Care Setting · Single select
Home isolation, Hospital ward, ICU, Recovered
Attending Doctor · Text
Check-ins · Link to another table
Links to Daily Check-ins
Days Monitored · Count
Last Check-in · Rollup
max of Date via Check-ins
Lowest SpO₂ · Rollup
min of SpO₂ (%) via Check-ins
Peak Temp (°F) · Rollup
max of Temperature (°F) via Check-ins

Daily Check-ins

11 fields · 5 sample rows

  • All check-ins (Grid)
  • Escalations (Grid)
  • Daily check-in (Form)
  • Calendar (Calendar)
DateDatePatientLink to another tableTemperature (°F)NumberSpO₂ (%)NumberPulseNumberSymptomsMultiple selectSeveritySingle selectAlertFormulaMedicationsMultiple selectChecked ByTextNotesLong text
17 Nov 2026Arvind Kulkarni101.29692Fever, Cough, Body acheMildStableParacetamolTele-nurse Priya
18 Nov 2026Arvind Kulkarni102.19398Fever, Cough, BreathlessnessModerateEscalateParacetamol, AntiviralTele-nurse PriyaAdvised in-person review.
19 Nov 2026Arvind Kulkarni100.49590CoughModerateStableParacetamol, AntiviralDr. Shah
18 Nov 2026Maria Gonzalez99.59880Sore throat, Loss of taste/smellMildStableParacetamolTele-nurse Priya
19 Nov 2026Farida Begum99.192104BreathlessnessSevereEscalateSteroid, Oxygen supportDr. IyerOn 2 L oxygen.
Field details
Date · Date
Patient · Link to another table
Links to Patients
Temperature (°F) · Number
SpO₂ (%) · Number
Pulse · Number
Symptoms · Multiple select
Fever, Cough, Sore throat, Breathlessness, Body ache, Loss of taste/smell, Diarrhoea
Severity · Single select
Mild, Moderate, Severe
Alert · Formula
IF(OR(AND({SpO₂ (%)}, {SpO₂ (%)} < 94), {Temperature (°F)} >= 103, {Severity} = 'Severe'), 'Escalate', 'Stable')
Medications · Multiple select
Paracetamol, Cough syrup, Antiviral, Steroid, Oxygen support
Checked By · Text
Notes · Long text

Form view “Daily symptom check-in” asks for: Date, Patient, Temperature (°F), SpO₂ (%), Pulse, Symptoms, Severity, Medications, Notes.

COVID-19 Patient Symptom Tracker: 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