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
Tables
People, Attendance
Fields
20
Views
grid, dashboard, calendar, form
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.
10 fields · 5 sample rows
| NameText | IDText | GroupSingle select | EmailEmail | AttendanceLink to another table | Days markedCount | Days presentRollup | Days lateRollup | HoursRollup | Attendance %Formula |
|---|---|---|---|---|---|---|---|---|---|
| Ishaan Verma | 8A-01 | Class 8-A | [email protected] | 18 Nov 2026, 19 Nov 2026 | 2 | 2 | 0 | 6.50 | 100% |
| Maya Patel | 8A-02 | Class 8-A | [email protected] | 18 Nov 2026, 19 Nov 2026 | 2 | 2 | 1 | 6.08 | 100% |
| Daniel Okoro | 8B-07 | Class 8-B | [email protected] | 18 Nov 2026, 19 Nov 2026 | 2 | 0 | 0 | 0 | 0% |
| Sneha Rao | EMP-114 | Operations | [email protected] | 18 Nov 2026 | 1 | 1 | 0 | 8.75 | 100% |
| Tom Becker | EMP-121 | Sales | [email protected] | 18 Nov 2026 | 1 | 0.5 | 0 | 4 | 50% |
10 fields · 8 sample rows
| DateDate | PersonLink to another table | GroupLookup | StatusSingle select | Check-inDuration | Check-outDuration | HoursFormula | Counts as presentFormula | Late flagFormula | NotesText |
|---|---|---|---|---|---|---|---|---|---|
| 18 Nov 2026 | Ishaan Verma | Class 8-A | Present | 8:00 | 14:30 | 6.50 | 1 | 0 | |
| 18 Nov 2026 | Maya Patel | Class 8-A | Late | 8:25 | 14:30 | 6.08 | 1 | 1 | Bus delayed |
| 18 Nov 2026 | Daniel Okoro | Class 8-B | Absent | 0 | 0 | 0 | No message from parent | ||
| 18 Nov 2026 | Sneha Rao | Operations | Present | 9:30 | 18:15 | 8.75 | 1 | 0 | |
| 18 Nov 2026 | Tom Becker | Sales | Half day | 9:30 | 13:30 | 4 | 0.5 | 0 | |
| 19 Nov 2026 | Ishaan Verma | Class 8-A | Present | 7:55 | 0 | 1 | 0 | ||
| 19 Nov 2026 | Maya Patel | Class 8-A | Present | 7:58 | 0 | 1 | 0 | ||
| 19 Nov 2026 | Daniel Okoro | Class 8-B | Excused | 0 | 0 | 0 | Medical certificate received |
Form view “Mark attendance” asks for: Date, Person, Status, Check-in, Check-out, Notes.
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.
A discreet, first-name-only sign-in for recovery meetings, with sobriety milestones and attendance verification for those who need it.
2 tables · 20 fieldsChild Care Attendance SheetDaily drop-off and pick-up log for a daycare, with authorised pickups, allergies and per-child attendance rates.
2 tables · 24 fieldsMeeting Attendance SheetRecord who attended each board, team or committee meeting, check quorum automatically and keep agendas and minutes alongside.
2 tables · 24 fieldsSafety Meeting Sign In SheetToolbox-talk register: log each safety briefing and collect a signed acknowledgement from every worker who attended.
2 tables · 20 fields