Wondering if this is possible…
I’m building an attendance app for our school. There are 3 options - Present, Absent, and Tardy. I’m using a ValidIF expression to select the students based on the grade and college (homeroom) selected.
So a teacher selects the grade then the college, and based on those selections they are presented with the class roster. They select the students that are Present first and the form advances to the next list for Absent students.
My question is can I limit the Absent list options to only include the students who were not marked Present?
Pic 1 - students who are Present are selected Pic 2 - only students who were not selected in Pic 1 appear in Absent list
[EDIT] - not that it matters for my question, but it makes more sense for the teacher to select the kids who are Absent then Tardy, leaving the kids who are Present since there will be more of them.