Vaccine Log Sheet

Record each employee’s vaccine, dose dates and certificate, with vaccination status and next-dose dates worked out for you.

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

Human Resources

Tables

Vaccination records

Fields

14

Views

grid, calendar, form, dashboard

Tables, columns and sample rows

The table in this template, with its real columns, field types and sample rows. Copy the template to edit it in Edesy Tables.

Vaccination records

14 fields · 5 sample rows

  • All records (Grid)
  • Next doses (Calendar)
  • Submit record (Form)
  • Coverage (Dashboard)
EmployeeTextEmployee IDTextDepartmentSingle selectEmailEmailVaccineSingle selectDose 1DateDose 2DateBoosterDateVaccination statusFormulaNext dose dueFormulaExemptionSingle selectCertificateAttachmentVerifiedCheckboxVerified byText
Aditi KulkarniEMP-0001Engineering[email protected]Covishield19 Dec 202413 Mar 202515 Oct 2025BoostedNoneYesSana Mirza
James WhitfieldEMP-0002Sales[email protected]Pfizer-BioNTech7 Jul 202522 Jul 2026Fully vaccinated22 Jan 2027NoneYesSana Mirza
Farhan QureshiEMP-0003Operations[email protected]Covaxin10 Oct 2026Partially vaccinated2 Jan 2027None
Mei LinEMP-0004Marketing[email protected]Moderna23 Jan 202622 Feb 2026Fully vaccinated22 Aug 2026NoneYesRachel Thomas
Harpreet SinghEMP-0005Sales[email protected]Not vaccinatedMedicalYesRachel Thomas
Field details
Employee · Text
Employee ID · Text
Department · Single select
Engineering, Sales, Marketing, Operations, Finance, People, Support
Email · Email
Vaccine · Single select
Covishield, Covaxin, Pfizer-BioNTech, Moderna, Corbevax, Other
Dose 1 · Date
Dose 2 · Date
Booster · Date
Vaccination status · Formula
IF({Booster}, 'Boosted', IF({Dose 2}, 'Fully vaccinated', IF({Dose 1}, 'Partially vaccinated', 'Not vaccinated')))
Next dose due · Formula
IF({Booster}, BLANK(), IF({Dose 2}, DATEADD({Dose 2}, 6, 'months'), IF({Dose 1}, DATEADD({Dose 1}, 84, 'days'), BLANK())))
Exemption · Single select
None, Medical, Other
Certificate · Attachment
Verified · Checkbox
Verified by · Text

Form view “Submit your vaccination record” asks for: Employee, Employee ID, Department, Email, Vaccine, Dose 1, Dose 2, Booster, Exemption, Certificate.

Vaccine Log Sheet: 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