Daily Attendance Sheet

Mark a class or team present, late or absent each day and see every person’s attendance rate and hours roll up automatically.

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

Attendance Sheets

Tables

People, Attendance

Fields

20

Views

grid, dashboard, calendar, form

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.

People

10 fields · 5 sample rows

  • Roster (Grid)
  • Summary (Dashboard)
NameTextIDTextGroupSingle selectEmailEmailAttendanceLink to another tableDays markedCountDays presentRollupDays lateRollupHoursRollupAttendance %Formula
Ishaan Verma8A-01Class 8-A[email protected]18 Nov 2026, 19 Nov 20262206.50100%
Maya Patel8A-02Class 8-A[email protected]18 Nov 2026, 19 Nov 20262216.08100%
Daniel Okoro8B-07Class 8-B[email protected]18 Nov 2026, 19 Nov 202620000%
Sneha RaoEMP-114Operations[email protected]18 Nov 20261108.75100%
Tom BeckerEMP-121Sales[email protected]18 Nov 202610.50450%
Field details
Name · Text
ID · Text
Group · Single select
Class 8-A, Class 8-B, Operations, Sales
Email · Email
Attendance · Link to another table
Links to Attendance
Days marked · Count
Days present · Rollup
sum of Counts as present via Attendance
Days late · Rollup
sum of Late flag via Attendance
Hours · Rollup
sum of Hours via Attendance
Attendance % · Formula
IF({Days marked} > 0, {Days present} / {Days marked}, BLANK())

Attendance

10 fields · 8 sample rows

  • Register (Grid)
  • Calendar (Calendar)
  • Mark attendance (Form)
DateDatePersonLink to another tableGroupLookupStatusSingle selectCheck-inDurationCheck-outDurationHoursFormulaCounts as presentFormulaLate flagFormulaNotesText
18 Nov 2026Ishaan VermaClass 8-APresent8:0014:306.5010
18 Nov 2026Maya PatelClass 8-ALate8:2514:306.0811Bus delayed
18 Nov 2026Daniel OkoroClass 8-BAbsent000No message from parent
18 Nov 2026Sneha RaoOperationsPresent9:3018:158.7510
18 Nov 2026Tom BeckerSalesHalf day9:3013:3040.50
19 Nov 2026Ishaan VermaClass 8-APresent7:55010
19 Nov 2026Maya PatelClass 8-APresent7:58010
19 Nov 2026Daniel OkoroClass 8-BExcused000Medical certificate received
Field details
Date · Date
Person · Link to another table
Links to People
Group · Lookup
Group via Person
Status · Single select
Present, Late, Absent, Excused, Half day
Check-in · Duration
Check-out · Duration
Hours · Formula
IF(AND({Check-in}, {Check-out}), ROUND(({Check-out} - {Check-in}) / 3600, 2), 0)
Counts as present · Formula
SWITCH({Status}, 'Present', 1, 'Late', 1, 'Half day', 0.5, 0)
Late flag · Formula
IF({Status} = 'Late', 1, 0)
Notes · Text

Form view “Mark attendance” asks for: Date, Person, Status, Check-in, Check-out, Notes.

Daily Attendance 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