An app that calculates attendance from a certain point in rime

I use google forms to capture attendance into a google sheet. I would like to be able to calculate how many students attended between certain dates eliminating any duplicate names (for instance only counting a student once even if they were present multiple times within that time frame). I would also like to calculate how many students are new during that time frame as well.

so an example would be if the app had a form where someone could pick points in time (January 1 to December 31 for example) the app could tell them the number of students that attended in that time frame.

If this can be done how would I proceed with building such an app? I have never used AppSheet before.

SELECT( table[student] , AND( [date] > x , [date] < y ) , TRUE )
SELECT( table[student] , AND( [date] > x , [date] < y ) , TRUE )
-
SELECT( table[student] , [date] < x , TRUE )
1 Like