Student Attendance Sheet

Mark daily attendance, record absence reasons and parent contact, and flag students slipping below the attendance threshold.

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

Fields

18

Views

grid, 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.

Students

10 fields · 5 sample rows

  • Students (Grid)
StudentTextStudent IDTextGradeSingle selectParent emailEmailRecordsLink to another tableDays markedCountDays presentRollupUnexcused absencesRollupAttendance %FormulaAt riskFormula
Advait KulkarniS-4012Grade 5[email protected]19 Nov 2026, 18 Nov 2026220100.0%OK
Chloe DuboisS-4013Grade 5[email protected]19 Nov 2026, 18 Nov 20262000.0%At risk
Farhan AliS-4014Grade 5[email protected]19 Nov 2026, 18 Nov 20262020.0%At risk
Grace WanjiruS-4015Grade 5[email protected]19 Nov 2026110100.0%OK
Tanvi DesaiS-4016Grade 5[email protected]19 Nov 2026110100.0%OK
Field details
Student · Text
Student ID · Text
Grade · Single select
Grade 4, Grade 5, Grade 6
Parent email · Email
Records · Link to another table
Links to Attendance
Days marked · Count
Days present · Rollup
sum of Present via Records
Unexcused absences · Rollup
sum of Unexcused via Records
Attendance % · Formula
IF({Days marked} > 0, {Days present} / {Days marked}, BLANK())
At risk · Formula
IF(AND({Days marked} > 0, {Attendance %} < 0.9), 'At risk', 'OK')

Attendance

8 fields · 8 sample rows

  • Daily (Grid)
  • Absences (Grid)
  • Calendar (Calendar)
  • Report an absence (Form)
DateDateStudentLink to another tableStatusSingle selectAbsence reasonSingle selectParent notifiedCheckboxPresentFormulaUnexcusedFormulaNotesLong text
19 Nov 2026Advait KulkarniPresent10
19 Nov 2026Chloe DuboisAbsentIllnessYes00
19 Nov 2026Farhan AliAbsentNo reason given01
19 Nov 2026Grace WanjiruLate10
19 Nov 2026Tanvi DesaiPresent10
18 Nov 2026Farhan AliAbsentNo reason givenYes01Left voicemail
18 Nov 2026Chloe DuboisExcusedMedical appointmentYes00
18 Nov 2026Advait KulkarniPresent10
Field details
Date · Date
Student · Link to another table
Links to Students
Status · Single select
Present, Absent, Late, Excused
Absence reason · Single select
Illness, Medical appointment, Family emergency, Travel, No reason given
Parent notified · Checkbox
Present · Formula
IF(OR({Status} = 'Present', {Status} = 'Late'), 1, 0)
Unexcused · Formula
IF(AND({Status} = 'Absent', OR({Absence reason} = 'No reason given', NOT({Absence reason}))), 1, 0)
Notes · Long text

Form view “Report an absence” asks for: Date, Student, Status, Absence reason, Notes.

Student 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