Monthly Attendance Sheet

Track daily attendance for a class, team or programme and roll it up month by month for each member.

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

Members, Daily records

Fields

14

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.

Members

8 fields · 4 sample rows

  • Members (Grid)
MemberTextGroupSingle selectJoinedDateEmailEmailRecordsLink to another tableDays markedCountDays presentRollupAttendance rateFormula
Pooja VermaMorning batch22 Jul 2026[email protected]19 Nov 2026, 18 Nov 20262150%
Daniel OkaforMorning batch21 Aug 2026[email protected]19 Nov 2026, 18 Oct 202622100%
Sana SheikhEvening batch3 May 2026[email protected]19 Nov 2026, 17 Oct 20262150%
Lucas MartinVolunteers5 Oct 2026[email protected]18 Nov 2026, 16 Oct 202622100%
Field details
Member · Text
Group · Single select
Morning batch, Evening batch, Volunteers
Joined · Date
Email · Email
Records · Link to another table
Links to Daily records
Days marked · Count
Days present · Rollup
sum of Present via Records
Attendance rate · Formula
IF({Days marked} > 0, {Days present} / {Days marked}, BLANK())

Daily records

6 fields · 8 sample rows

  • By month (Grid)
  • Calendar (Calendar)
  • Monthly trend (Dashboard)
DateDateMemberLink to another tableStatusSingle selectMonthFormulaPresentFormulaRemarksText
19 Nov 2026Pooja VermaPresent2026-11 · November1
19 Nov 2026Daniel OkaforLate2026-11 · November1Traffic
19 Nov 2026Sana SheikhPresent2026-11 · November1
18 Nov 2026Pooja VermaAbsent2026-11 · November0
18 Nov 2026Lucas MartinPresent2026-11 · November1
18 Oct 2026Daniel OkaforPresent2026-10 · October1
17 Oct 2026Sana SheikhExcused2026-10 · October0Family function
16 Oct 2026Lucas MartinPresent2026-10 · October1
Field details
Date · Date
Member · Link to another table
Links to Members
Status · Single select
Present, Absent, Late, Excused
Month · Formula
IF({Date}, DATETIME_FORMAT({Date}, 'YYYY-MM · MMMM'), BLANK())
Present · Formula
IF(OR({Status} = 'Present', {Status} = 'Late'), 1, 0)
Remarks · Text

Monthly 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