Rollups for count

Ok, I will get to work on it for you :slight_smile:

How many students do you have currently, and what is the max capacity of students?

Can you provide a student list, just their names?

Thanks for the help @Drearystate . The list is variant (dynamic) and not static as it changes per training course, period varies from 4 week to six weeks to 8 weeks. If you would kindly explain the logic would be nice. All-in-all, Please find below the structure in mind

Blockquote
|No. |Student Name|Attended|
|—|---|—|
|1|Studen 1|Yes|
|2|Studen 2|No|
|3|Studen 3|Yes|
|4|Studen 4|Yes|
|5|Studen 5|Yes|
|6|Studen 6|Yes|
|7|Studen 7|Yes|
|8|Studen 8|No|
|9|Studen 9|No|
|10|Studen 10|No|

Hey @Aj2666

Try this one:

• If you’ll count in the same tab, First of all, create a relation of Student’s Name to Student’s Name (Matching multiple);

• Next, you create a Rollup column selecting this last relation you did and choosing the Attendance column, afterwards you select to Count only True;

So that, the Rollup will count the Attendance by Student’s Name :grin:

2 Likes

Ok, I will have it finished up today, I am using the toggles so you can just toggle real quick down the list. The reporting will consist of yesterday, last week, and current month. If you need any adjustments after I get it to you let me know.

Thank you. Much appreciated.

1 Like

I got our 1st draft ready for you. Since you didn’t give me names or a max total on students I went with 12 students and just put in stdent 1, student 2, etc. The reports are setup to come from the sheet tab titled reports. But they will be in the app as well here in a minute.

https://l.glideapps.com/75a86

I will be off and on today so if you need anything fixed let me know. If you need the reporting explained and the cell formulas explained, again just let me know :slight_smile:

1 Like

Ok, you now have charts in the monthly reporting section of the app, if you use the link it should update automatically.

1 Like

Hi guys! super helpful reading through your advice here

I’ve got an issue where the the DONE button isn’t clickable when i try to count TRUE values.

I have a similar case of wanting to show a graph of attended classes per student. I’ve created a relationship in the ‘student’ sheet to the ‘class calendar’ sheet. Each student has multiple items referenced in the ‘student’ sheet now. Next, I want to count these items…but I can’t work out how https://share.getcloudapp.com/geuWKQQE. Notice the done button is not clickable

thanks in advance

Here’s a picture

Can you send a screenshot of the google sheet? Does it already have true values in thta column?

Is your relation a single or multiple relation?

It’s a multiple relation

image

Here it shows 6 classes associated to the top record image

and the goal is to rollup the count of reserved classes for the selected student. This is the boolean ‘reserved’ column

image

Thanks for helping out, really appreciate it

That’s strange. I don’t know why you wouldn’t be able to add the rollup. Can you try to make a duplicate of your app and try it in the duplicate? Also would you make able to allow your app to be copied so we could take a look? Nothing is jumping out to me based on your screenshots.

I’ve tried duplicating. No luck.

I’ve allowed the app to be copied temporarily https://8eng5.glideapp.io/

I have a copy if you want to stop sharing.

I think you definitely identified a bug. Possibly with the new ability to rename columns in combination with using a rollup against a renamed relation. Did you happen to rename the relation column after you created it?

I was able to reproduce the problem. First I created an identical relation and then created a rollup column against that relation. Everything worked fine and I was able to get a count of the true reserved checkboxes. It wasn’t until I renamed the relation column that I could no longer create a rollup against that relation with the ‘Done’ button being grayed out.

Deleting and recreating the relation with the name already set would fix this issue.

@Mark I think we definitely have a bug here. I have a copy of the app in this state if you need it.

2 Likes

Awesome Jeff! Much appreciated. Have a lovely day

1 Like

@Jeff_Hager Could you share the app, please?

There are two relations in the Students sheet of the app. The original one and one that I created. Here is the url: https://tr0uy.glideapp.io/

This is the original one that @lancscheese created and I suspect was renamed after being created.
image

When attempting to create a Rollup against the relation, the Done button is disabled on nothing shows in the column for counts.
image

This is the relation that I created and set the name on creation without later changing it.
image

When I create a Rollup against my relation, the Done button is enabled and you can see that counts are showing.
image