Hi, we need to set up an attendance tracker (I know how to do the student and class dataset) for teachers to track students attendance in three activities each afternoon (same teacher tracks all three, and there are 6 teachers / classrooms). I know how I could do this in the form but are limited to each student with the three activities. I want to give the teachers a form to fill it that looks like a excel table, with all the students names on the left, and the three activities on the right for them to mark as present, absent, or partial. We do not want to use a portal as those are expensive. Will I need to use another application on top of this to do it? If so, which one if we want one place that the teachers go to for a drop down list of their classrooms, and then to fill out the matrix.
In addition, how would you set up the attendance data table in airtable. Thanks!
