I’ve created an “attendance sheet” with in the first row the student’s name and in the first column the date : [Appel] I’d like to make a report with datas of each row (each date). Does somebody have an idea for the followings things ? 1. Calculate number of students “Present” for each row ? I …

Thank you for your help… I have found a method : array formula with “rows” for calculate nimber of students “present” and list with détail view for student presents for each date. You can watch this : https://gestiondeclub-appel.glideapp.io/ => Tap Logo > Tap U8 Float button = relevance and “Bil…

I would consider restructuring your data to have the list of names in Column A. Then you could add additional columns like “Date” and “Attended”. Now back in glide you could use filters such as “attended is true” If you are using a form or a custom action somewhere in the flow, you could use the “…

I have done similar thing in one of my template for board meetings. Directors and Board Meetings This App will help a Company Secretarial Department or Law Department of any organisation to keep 1. Track of the list of Directors 2. Their membership in different Committees 3. Their Atten…

I’ve used a form with one choice button for each student … That’s why student’s name are on first row and not first column… I can use “transpose” function on the sheet in order to have name on Column A. If i do that i can easily calculate number of student but idon’t find to show on the Glide a list…

Again I would consider reorganizing the data structure. You could make a new tab for your choice component with a list of student names. So instead of many choice components for each student you would have 1 choice component for ALL students. Perhaps your approach is better, I will have to yield to…

I have also used transpose in my sheet. I will share the sheet on Monday with you if that is helpful.

I like the little “more” button :sunglasses: ▶ Summary

add a location search … and switch combine … it will give you actual students attending

This may help…though it’s in Spanish. [image] Classroom observation record Project Showcase Here you have another app to record what happens in your classrooms. You can: attendance tracking delays tracking good and bad interventions tracking any kind of participations…

May be somthing like this? ( attendance app ) The number of persons present each day is calculated in Glide with a math column. [image] The drawback is that both dates and students should be fixed

I need help structuring data for my attendance app

Ask for Help

Eric_Penn February 7, 2021, 1:43pm 10

This may help…though it’s in Spanish.

Topic		Replies	Views
Google Sheet columns of computed dates Ask for Help	16	642	February 12, 2022
Need Dashboard Help Ask for Help	2	218	September 27, 2023
Attendance application ideas Ask for Help	4	987	October 8, 2021
Attendance tracker Ask for Help	2	33	September 18, 2025
Attendance app with multiple events and switches Ask for Help	3	459	October 13, 2022

I need help structuring data for my attendance app

Related topics