Hello AppSheet Users,
I have created a register app which tracks the attendance of students. When teachers make entries for the students, the select whether the student was present or not. Then, in the ‘Students’ Table, it devides the amount of times a student was present by the total amount of lessons. This gives me a total attendance percentage for a particular student.
However, I have been wondering if it is possible for me to search the attendance by date range. At the moment, the attendance is based on all of the lessons. Is it possible to be able to check a student’s particular attendance based on the date. For example, if I chose 01/07/18 - 31/07/18 then it would give me the total attendance for only July. How could I achieve something like this?