Class Attendance Sheet

A class register: mark each student per period and see every student's attendance rate update 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

Education

Tables

Students, Register

Fields

15

Views

grid, calendar, dashboard

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.

Students

8 fields · 5 sample rows

  • Roster (Grid)
StudentTextRoll noNumberSectionSingle selectGuardian phonePhoneAttendanceLink to another tableClasses markedCountClasses attendedRollupAttendance %Formula
Riya Sharma18A+91 98200 1122319 Nov 2026, 18 Nov 202622100%
Ethan Brooks28A+44 7700 90012319 Nov 202611100%
Kabir Singh38A+91 99100 4455619 Nov 2026, 18 Nov 2026200%
Meera Nair48A+91 98450 7788919 Nov 202611100%
Noah Kim58A+1 415 555 014219 Nov 2026, 18 Nov 20262150%
Field details
Student · Text
Roll no · Number
Section · Single select
8A, 8B
Guardian phone · Phone
Attendance · Link to another table
Links to Register
Classes marked · Count
Classes attended · Rollup
sum of Attended via Attendance
Attendance % · Formula
IF({Classes marked} > 0, {Classes attended} / {Classes marked}, BLANK())

Register

7 fields · 8 sample rows

  • By day (Grid)
  • Calendar (Calendar)
  • Overview (Dashboard)
DateDateStudentLink to another tablePeriodSingle selectStatusSingle selectMinutes lateNumberAttendedFormulaNoteText
19 Nov 2026Riya Sharma1 · MathsPresent1
19 Nov 2026Ethan Brooks1 · MathsLate101
19 Nov 2026Kabir Singh1 · MathsAbsent0Fever, parent called
19 Nov 2026Meera Nair1 · MathsPresent1
19 Nov 2026Noah Kim1 · MathsPresent1
18 Nov 2026Riya Sharma1 · MathsPresent1
18 Nov 2026Kabir Singh1 · MathsExcused0Doctor appointment
18 Nov 2026Noah Kim1 · MathsAbsent0
Field details
Date · Date
Student · Link to another table
Links to Students
Period · Single select
1 · Maths, 2 · Science, 3 · English, 4 · History
Status · Single select
Present, Absent, Late, Excused
Minutes late · Number
Attended · Formula
IF(OR({Status} = 'Present', {Status} = 'Late'), 1, 0)
Note · Text

Class 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