I want to generate a weekly report for our teachers. I want this report to show them all the students in their class, their total attendance hours, and test results.
I have a Students table that has all this data (the attendance hours and test results are in VCs drawn from related tables). This Students table is also a child table of the Class Table, which contains each teacher’s email.
I’m hoping I can tell AppSheet to do something like, “For each class in the Class table, send a report to [Teacher’s Email] that contains columns X, Y, and Z from all related records in the Students table”.
I’m not sure if that’s possible. I do have an idea for accomplishing the same thing. But I’m hoping/wondering if there is a more efficient way.
The way I think will work is to create a separate slice from the Students table for each and every class, set so that only records in that class are shown. Then create a separate report for each and every class.
Will this work? Is there a better way?