# I need help structuring data for my attendance app **URL:** \ **Category:** Ask for Help\ **Created:** [February 6, 2021, 1:57pm UTC](https://community.glideapps.com/t/i-need-help-structuring-data-for-my-attendance-app/22325 "2021-02-06T13:57:38Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![Alexis\_AZOULAI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexis_azoulai/32/20550_2.png) [@Alexis\_AZOULAI](https://community.glideapps.com/u/Alexis_AZOULAI)\ **Post date:** [February 6, 2021, 1:57pm UTC](https://community.glideapps.com/t/i-need-help-structuring-data-for-my-attendance-app/22325/1 "2021-02-06T13:57:38Z")
I’ve created an “attendance sheet” with in the first row the student’s name and in the first column the date : ![Appel](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/0/306101fdcae61ca2345ceda556ebeb21a8635fbc.png) 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 think that Arrayformula doesn’t work in row with Countif. **2. Is it possible to show in Glide which student were “present” for each Date ?** I think about that but i can’t find a solution. ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [February 6, 2021, 2:04pm UTC](https://community.glideapps.com/t/i-need-help-structuring-data-for-my-attendance-app/22325/2 "2021-02-06T14:04:14Z")
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 “current date” component to capture dates. ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [February 6, 2021, 3:55pm UTC](https://community.glideapps.com/t/i-need-help-structuring-data-for-my-attendance-app/22325/3 "2021-02-06T15:55:21Z")
I have done similar thing in one of my template for board meetings. > **[Directors and Board Meetings](https://go.glideapps.com/app/Suj9FnPjqxgMX1QsjuyW-template)** > > 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 Attendance in various meetings etc. > in systematic manner. > > This... ![Screenshot_2021-02-06-21-23-42-586_com.android.chrome](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/d/0da78ec479fd82b12e8e813a90246af200f81e4f.jpeg) ![Screenshot_2021-02-06-21-23-16-571_com.android.chrome](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/0/d0821dee115319e7efa378e8137f8cfc8ecd4ff5.jpeg) ---
**Author:** ![Alexis\_AZOULAI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexis_azoulai/32/20550_2.png) [@Alexis\_AZOULAI](https://community.glideapps.com/u/Alexis_AZOULAI)\ **Post date:** [February 6, 2021, 5:32pm UTC](https://community.glideapps.com/t/i-need-help-structuring-data-for-my-attendance-app/22325/4 "2021-02-06T17:32:41Z")
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 of the date and for which the list of students ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [February 6, 2021, 10:37pm UTC](https://community.glideapps.com/t/i-need-help-structuring-data-for-my-attendance-app/22325/5 "2021-02-06T22:37:09Z")
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 the experts on this one. Good luck! ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [February 7, 2021, 4:25am UTC](https://community.glideapps.com/t/i-need-help-structuring-data-for-my-attendance-app/22325/6 "2021-02-07T04:25:54Z")
I have also used transpose in my sheet. I will share the sheet on Monday with you if that is helpful. ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [February 7, 2021, 5:56am UTC](https://community.glideapps.com/t/i-need-help-structuring-data-for-my-attendance-app/22325/7 "2021-02-07T05:56:44Z")
I like the little “more” button 🕶 > **Summary** > > ![Screen Shot 2021-02-07 at 12.54.06 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/8/c837e342dc76362a7e656a3f3df576fa68c0307b.jpeg) ---
**Author:** ![Alexis\_AZOULAI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexis_azoulai/32/20550_2.png) [@Alexis\_AZOULAI](https://community.glideapps.com/u/Alexis_AZOULAI)\ **Post date:** [February 7, 2021, 9:44am UTC](https://community.glideapps.com/t/i-need-help-structuring-data-for-my-attendance-app/22325/8 "2021-02-07T09:44:31Z")
Yhank you very much ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 7, 2021, 10:51am UTC](https://community.glideapps.com/t/i-need-help-structuring-data-for-my-attendance-app/22325/9 "2021-02-07T10:51:22Z")
add a location search … and switch combine … it will give you actual students attending ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [February 7, 2021, 1:43pm UTC](https://community.glideapps.com/t/i-need-help-structuring-data-for-my-attendance-app/22325/10 "2021-02-07T13:43:16Z")
This may help…though it’s in Spanish. > [@Classroom observation record](https://community.glideapps.com/t/classroom-observation-record/22366): > > 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 tracking take note of some global issue take note of some individual issue One tap on a student record marks absence; two opens the student’s profile in order to mark any other issue. A google script runs every night from monday to friday to save day’s records on a separate sheet and clears the day’s record. This h… ---
**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\ **Post date:** [February 7, 2021, 3:20pm UTC](https://community.glideapps.com/t/i-need-help-structuring-data-for-my-attendance-app/22325/11 "2021-02-07T15:20:36Z")
May be somthing like this? ([attendance app](https://lowly-bird-7255.glideapp.io/)) The number of persons present each day is calculated in Glide with a math column. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/0/306ef529c1307ee2d959d33cc127c36e6de0ddc0.png) The drawback is that both dates and students should be fixed ---
**Author:** ![Alexis\_AZOULAI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexis_azoulai/32/20550_2.png) [@Alexis\_AZOULAI](https://community.glideapps.com/u/Alexis_AZOULAI)\ **Post date:** [February 7, 2021, 3:59pm UTC](https://community.glideapps.com/t/i-need-help-structuring-data-for-my-attendance-app/22325/12 "2021-02-07T15:59:18Z")
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/](https://gestiondeclub-appel.glideapp.io/) =\> Tap Logo \> Tap U8 Float button = relevance and “Bilan de séance” = Report of relevance ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [February 7, 2021, 5:22pm UTC](https://community.glideapps.com/t/i-need-help-structuring-data-for-my-attendance-app/22325/13 "2021-02-07T17:22:09Z")
I’ve improved the title of this topic. Please be more specific than “I need help” next time. ---
**Author:** ![Alexis\_AZOULAI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexis_azoulai/32/20550_2.png) [@Alexis\_AZOULAI](https://community.glideapps.com/u/Alexis_AZOULAI)\ **Post date:** [February 7, 2021, 5:24pm UTC](https://community.glideapps.com/t/i-need-help-structuring-data-for-my-attendance-app/22325/14 "2021-02-07T17:24:19Z")
Excuse me… I’ll be more specific nest time 🙏 ---
**Author:** ![Wim\_De\_Coninck](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wim_de_coninck/32/28179_2.png) [@Wim\_De\_Coninck](https://community.glideapps.com/u/Wim_De_Coninck)\ **Post date:** [November 14, 2021, 6:48pm UTC](https://community.glideapps.com/t/i-need-help-structuring-data-for-my-attendance-app/22325/15 "2021-11-14T18:48:42Z")
has someone a copy of the mentioned app [https://gestiondeclub-appel.glideapp.io/](https://gestiondeclub-appel.glideapp.io/) because link seems to be dead. ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:49pm UTC](https://community.glideapps.com/t/i-need-help-structuring-data-for-my-attendance-app/22325/16 "2024-01-17T16:49:39Z")