# Not sure how to create a running total of values that are calculated each day for a month **URL:** \ **Category:** Ask for Help\ **Created:** [November 7, 2020, 3:56am UTC](https://community.glideapps.com/t/not-sure-how-to-create-a-running-total-of-values-that-are-calculated-each-day-for-a-month/18075 "2020-11-07T03:56:57Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![sliu57](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sliu57/32/16172_2.png) [@sliu57](https://community.glideapps.com/u/sliu57)\ **Post date:** [November 7, 2020, 3:56am UTC](https://community.glideapps.com/t/not-sure-how-to-create-a-running-total-of-values-that-are-calculated-each-day-for-a-month/18075/1 "2020-11-07T03:56:57Z")
Hi, I’m trying to have a feature in the user profile that allows them to view a running total of the number of activities they have done each day. I’ve watched Robert Pettito’s “Gamify Your Glide App #1-4” and I was able to create a user profile sheet in a glide that uses templates from other sheets in order to track which specific activities each user has done every day. However, I would like to keep a record of all the activities the user has done every day for a month, but the ActivitiesDoneToday column(relation column) only grabs all the activities the user has done for that specific day. Since this ActivitiesDoneToday column only exists in glide I can’t use a script to keep track of these tallied up activities every day. Due to the beauty of glide, I have a separate spreadsheet that lists out all the activities a user can do, and how much each activity is worth. Like is Robert’s Video, I used a template column that used the currently signed-in user’s email and had each activity linked to the signed-in user. This way I don’t have to create a spreadsheet for each individual user, which is definitely not ideal. Also, I need the log of activities that keep track of activities done each day by the users to be cleared each day. One way that I can think of is writing a script for the log sheet that keeps track of the activities that have been submitted each day, but I’m not exactly sure how to do that either. I am pretty new to glide, so I apologize if there is some terminology that I am missing or seems confusing. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 7, 2020, 4:08am UTC](https://community.glideapps.com/t/not-sure-how-to-create-a-running-total-of-values-that-are-calculated-each-day-for-a-month/18075/2 "2020-11-07T04:08:14Z")
Hi Steven, welcome to our community! Do you have a form that users can submit the activities that they have done? Or it’s simply a checkbox for each day? ---
**Author:** ![sliu57](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sliu57/32/16172_2.png) [@sliu57](https://community.glideapps.com/u/sliu57)\ **Post date:** [November 7, 2020, 4:28am UTC](https://community.glideapps.com/t/not-sure-how-to-create-a-running-total-of-values-that-are-calculated-each-day-for-a-month/18075/3 "2020-11-07T04:28:10Z")
Each activity has its own mini-form and that data goes in a separate spreadsheet called Activity Log. My User Profile’s sheet gets its relation from the Activity Log spreadsheet. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 7, 2020, 4:44am UTC](https://community.glideapps.com/t/not-sure-how-to-create-a-running-total-of-values-that-are-calculated-each-day-for-a-month/18075/4 "2020-11-07T04:44:27Z")
I assume you can extract the month and get the number of activities for current month, is that what you want? ---
**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:** [November 7, 2020, 6:31am UTC](https://community.glideapps.com/t/not-sure-how-to-create-a-running-total-of-values-that-are-calculated-each-day-for-a-month/18075/5 "2020-11-07T06:31:14Z")
I have done almost similar thing in one of my App. You can set a Relation to the Log entries and then Rollup the count of total number of entries for each user. ---
**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:** [November 7, 2020, 6:32am UTC](https://community.glideapps.com/t/not-sure-how-to-create-a-running-total-of-values-that-are-calculated-each-day-for-a-month/18075/6 "2020-11-07T06:32:13Z")
you can roll-up the count to these Relation column. ---
**Author:** ![sliu57](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sliu57/32/16172_2.png) [@sliu57](https://community.glideapps.com/u/sliu57)\ **Post date:** [November 7, 2020, 8:20am UTC](https://community.glideapps.com/t/not-sure-how-to-create-a-running-total-of-values-that-are-calculated-each-day-for-a-month/18075/7 "2020-11-07T08:20:18Z")
But the roll-up only counts to the relation column. And the relation column only shows once the user checks off activities they do each day. If the logs are cleared every day, how can the roll-up column have a running total for the whole month? ---
**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:** [November 7, 2020, 9:14am UTC](https://community.glideapps.com/t/not-sure-how-to-create-a-running-total-of-values-that-are-calculated-each-day-for-a-month/18075/8 "2020-11-07T09:14:03Z")
> [@sliu57](#): > > Also, I need the log of activities that keep track of activities done each day by the users to be cleared each day. Okay Sorry, I missed this sentence. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 7, 2020, 11:03am UTC](https://community.glideapps.com/t/not-sure-how-to-create-a-running-total-of-values-that-are-calculated-each-day-for-a-month/18075/9 "2020-11-07T11:03:26Z")
> [@sliu57](#): > > If the logs are cleared every day, how can the roll-up column have a running total for the whole month? What do you currently have to “clear” the log? ---
**Author:** ![sliu57](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sliu57/32/16172_2.png) [@sliu57](https://community.glideapps.com/u/sliu57)\ **Post date:** [November 7, 2020, 8:35pm UTC](https://community.glideapps.com/t/not-sure-how-to-create-a-running-total-of-values-that-are-calculated-each-day-for-a-month/18075/10 "2020-11-07T20:35:23Z")
The email, the activity, how many points the activity is worth, and a checkbox that is checked. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 7, 2020, 10:11pm UTC](https://community.glideapps.com/t/not-sure-how-to-create-a-running-total-of-values-that-are-calculated-each-day-for-a-month/18075/11 "2020-11-07T22:11:38Z")
> [@ThinhDinh](#): > > I assume you can extract the month and get the number of activities for current month, is that what you want? So would it work for your case?