Class Attendance Tracking

5348 10
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I’ve read through a number of posts on how to set up attendance tracking, and I haven’t found exactly the solution I’m hoping I can build.

What seems to make sense to me is something like this:

Student Table:
Unique Student ID# | Student Name | Sessions Attended

Course Sessions Table:
Date of each class meeting | Topic | Assignment | Students who attend

Attendance Table:
Date/time stamp (collected on student entering class) | Student ID

Eventually, I’d like to be able to have them scan a QR code as they enter, but I don’t mind working manually for a while. I mention that just so you won’t think I’m too obsessive for collecting the date/time.

I need to be able to record whether each student was On Time (including early), Late, or Absent. It seems to me like I could setup a calculation in the Session table that would check the attendance timestamps and record every student as on time, late, or absent for that session.

For example: 9 am class. John shows up at 8:55, he’s recorded as on time. Susan at 9 on time. Jason at 9:05, late. And Charlie no time stamp on that date - absent.

Is that possible in Airtable? I’m new to Airtable. I’ve worked with Filemaker quite a bit at the “dangerous amateur” level.

Thanks in advance for any help.

10 Replies 10
6 - Interface Innovator
6 - Interface Innovator

Hi @Chinazor_KALU , Sorry, but no. I cobbled something together, but there was a lot of duct tape on it in the end, and I never went back to refine it once classes went online.