Attendance app w multiple teachers - help

Hi everyone

I’m trying to create an Attendance app for the after school activity that I run. I have so far created a table in Glide labeled students - with their names, email addresses, and the different classes they’re taking.
I also have a table named ‘Classes’ where I list all of the classes we offer + their day and the time, as well as a column with a Relation to have all students who are enrolled in the class listed there.

Next, I have a table called Attendance with columns for ‘date’, ‘class’, ‘student’ and a boolean ‘present?’ yes/no.

However, I’m stuck. If a teacher would open the app, they can select the class they teach from a list. Then, all students in that class are listed. This is how far I got.

What I want now is for all the students to be marked as present by default (I tried using a checkbox but I cannot get this to work :sob:. Then, preferably with just one click of a button, the teacher could tap ‘confirm attendance’ or something and it would track all students that are marked/checked as present to present and the unchecked ones as absent.

I worry my question is quite complicated/convoluted/complex, but any help would be greatly appreciated. I’ve been reading through some other help posts and was honestly pleasantly surprised by how helpful and non-condescending the replies were.

Thanks for reading and any possible help you can give me!

1 Like

Does it have to be a checklist?

If by default, most people will attend, would it be possible for you to store something like this:

Date Absent List (IDs) Full List (IDs)
2025-06-28 102, 105 101, 102, 103, 104, 105, 106
2025-06-29 104 101, 102, 103, 104, 105, 106
2025-06-30 101, 102, 103, 104, 105, 106

Then you can use some Glide array columns to figure out the list of people who attended.

In your “attendance form”, you can have a choice component that writes to the absent list. Assuming you don’t have too many absentees, that shouldn’t be too difficult.

Then, a special column to write the current date to the table above.