An app that calculates attendance from a certain point in rime

[Leameana]

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.

[Marc_Dillon]

Leameana:

I would like to be able to calculate how many students attended between certain dates eliminating any duplicate names

help.appsheet.com

SELECT()

Gather column values from row in table or slice

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

Leameana:

I would also like to calculate how many students are new during that time frame as well.

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

Leameana:

I have never used AppSheet before.

help.appsheet.com

App Design 101

How to think about building your app