# How to create a summaries for individual users? **URL:** \ **Category:** Ask for Help\ **Created:** [October 12, 2022, 12:36pm UTC](https://community.glideapps.com/t/how-to-create-a-summaries-for-individual-users/51547 "2022-10-12T12:36:25Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![KPT](https://avatars.discourse-cdn.com/v4/letter/k/eb9ed0/32.png) [@KPT](https://community.glideapps.com/u/KPT)\ **Post date:** [October 12, 2022, 12:36pm UTC](https://community.glideapps.com/t/how-to-create-a-summaries-for-individual-users/51547/1 "2022-10-12T12:36:25Z")
I have time taking app, where I want to make a dashboard where each user can see how many hours they’ve logged and how much they need to invoice for the month - ideally shown on a card. But I’m a little stuck on how to do this, as I can’t figure out how to roll up individual users monthly data. ![Screenshot 2022-10-12 at 13.22.09](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/0/90b0c1803cf4aaff2daf63c95849a021de0f1636.jpeg) Currently I have tap called ‘WorkHour’, where people log hours with a form. Then I have an inline list set to card and restricted to showing only 1 record (I’ve seen other people use cards to show summaries, but not sure this right way around this?) Finally i tried to make a rollup for salaries - somehow hoping it would automatically split it out pr user - but it off-course rolls everything up. I also played around with filtering, but no matter what I do It does not work. ![Screenshot 2022-10-12 at 13.23.55](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/e/2e71e50d1b60d94699ecce38d4478742b2b82be8.png) I have the feeling Im going at this the complete wrong way, can someone point me in the right direction? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 12, 2022, 12:39pm UTC](https://community.glideapps.com/t/how-to-create-a-summaries-for-individual-users/51547/2 "2022-10-12T12:39:35Z")
Create a multiple relation from your Users table to your Work Hours table matching the Username/UserID in each table. Then do a rollup through that relation. ---
**Author:** ![KPT](https://avatars.discourse-cdn.com/v4/letter/k/eb9ed0/32.png) [@KPT](https://community.glideapps.com/u/KPT)\ **Post date:** [October 12, 2022, 1:15pm UTC](https://community.glideapps.com/t/how-to-create-a-summaries-for-individual-users/51547/3 "2022-10-12T13:15:49Z")
Thank you… It all makes sense once it works 😉 I also had the wrong source for the summary page. Is it possible to only let it summarise todays month? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 12, 2022, 1:24pm UTC](https://community.glideapps.com/t/how-to-create-a-summaries-for-individual-users/51547/4 "2022-10-12T13:24:50Z")
> [@KPT](#): > > Is it possible to only let it summarise todays month? hehe yes, I knew that would be the next question 🙂 A few different approaches, here is one: - Create two math columns in your Work Hours table. Both should use the following formula: ```auto Year(Date) * 100 + Month(Date) ``` - In one of the columns, replace Date with the row date. In the other replace Date with “Now” - Add an if-then-else column that compares the two math columns: – If Math1 equals Math2, then Salary - Now do your rollup using the if-then-else column (still through the multiple relation) ---
**Author:** ![KPT](https://avatars.discourse-cdn.com/v4/letter/k/eb9ed0/32.png) [@KPT](https://community.glideapps.com/u/KPT)\ **Post date:** [October 12, 2022, 1:37pm UTC](https://community.glideapps.com/t/how-to-create-a-summaries-for-individual-users/51547/5 "2022-10-12T13:37:22Z")
> [@Darren\_Murphy](#): > > hehe yes, I knew that would be the next question 🙂 hahah being a Glide wizard comes with the capability to look into the future 🧙‍♂️ I got a little bit of a problem getting the second column to work. The first column looks like this. ![Screenshot 2022-10-12 at 14.40.37](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/3/23a78778a7cb9e1a581bf9d18a7201dc9639571f.png) The output is a long number - what sort of value is this…? Can it be convert to an actual month name? Second column I can’t really to work - tried both with “NOW” and NOW ![Screenshot 2022-10-12 at 14.40.27](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/c/1c3f97dc109b8c4c3f493cc863fba031ab6b675d.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 12, 2022, 1:47pm UTC](https://community.glideapps.com/t/how-to-create-a-summaries-for-individual-users/51547/6 "2022-10-12T13:47:05Z")
> [@KPT](#): > > What sort of value is this…? It’s an integer that represents the Year and Month. ie. for today you will get 202210. Whenever you’re wanting to match one date to another, it’s always best to first convert them to either integers or a string. This is because dates contain a time component - which isn’t always apparent - so direct comparisons can lead to unexpected results. > [@KPT](#): > > Second column I can’t really to work - tried both with “NOW” and NOW When I said “Now”, I meant this: ![Screen Shot 2022-10-12 at 9.45.59 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/2/821c9156d5f6b0a5985bca00cf155c64bf4ffa05.png) > [@KPT](#): > > Can it be convert to an actual month name? Not directly. Again, there are a few ways to get a Month name from a Date. Some people might suggest that you use the Format Date plugin. I won’t do that, because I don’t trust it. But you’re welcome to use it if you want. Here is what I do: - Add a column somewhere (anywhere) that lists the Month names - Jan to Dec in a single column - Determine the Month index number using the following math: ```auto Month(Date) - 1 ``` - Add a Single Value column that takes From Start-\>Month Index, from the column that contains your list of month names. ---
**Author:** ![KPT](https://avatars.discourse-cdn.com/v4/letter/k/eb9ed0/32.png) [@KPT](https://community.glideapps.com/u/KPT)\ **Post date:** [October 12, 2022, 1:51pm UTC](https://community.glideapps.com/t/how-to-create-a-summaries-for-individual-users/51547/7 "2022-10-12T13:51:33Z")
> [@Darren\_Murphy](#): > > When I said “Now”, I meant this: > > ![Screen Shot 2022-10-12 at 9.45.59 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/2/821c9156d5f6b0a5985bca00cf155c64bf4ffa05.png) 😲 Did not see that, but works now - thank you again ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [October 13, 2022, 1:51pm UTC](https://community.glideapps.com/t/how-to-create-a-summaries-for-individual-users/51547/8 "2022-10-13T13:51:41Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.