# Accumulating Points

**URL:** <https://community.glideapps.com/t/accumulating-points/513>\
**Category:** Ask for Help\
**Created:** [September 23, 2019, 2:59pm UTC](https://community.glideapps.com/t/accumulating-points/513 "2019-09-23T14:59:11Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Cody\_Wheeler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cody_wheeler/32/397_2.png) [@Cody\_Wheeler](https://community.glideapps.com/u/Cody_Wheeler)\
**Post date:** [September 23, 2019, 2:59pm UTC](https://community.glideapps.com/t/accumulating-points/513/1 "2019-09-23T14:59:11Z")

</div>

I am wanting to build a simple app for my school where we can add and track house points. This is something that all staff members might be adding points to throughout the day at any given time. I also want them to be able to ‘view only’ the point totals for each house. I tried using the Number Entry field, but since that is editing and pulling directly to the sheet, I fear there is too much opportunity for the number to get deleted and then lost. Is there a way to have a button that would just add a point each time it is pressed?

[Here is a link to a copy of my sheet](https://docs.google.com/spreadsheets/d/1VB0rlU4K6a-nIIt-Arh6LQrlU_0XeiNgBJqufmNMEfE/edit?usp=sharing)

---

<div class="post-metadata">

**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:** [September 23, 2019, 4:49pm UTC](https://community.glideapps.com/t/accumulating-points/513/2 "2019-09-23T16:49:08Z")

</div>

You should make a sheet called Awards where new points are created as new rows. Then use formulas to sum up these points on a per-house basis.

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [September 23, 2019, 6:17pm UTC](https://community.glideapps.com/t/accumulating-points/513/3 "2019-09-23T18:17:13Z")

</div>

@Cody_Wheeler Take a look at this post. I think what @Christie_Orich-Matth is doing is somewhat similar to what you may also be doing.

> [@Function that increases points in a cell in another sheet](https://community.glideapps.com/t/function-the-increases-points-in-a-cell-in-another-sheet/394):
>
> Hi I am building an app for our school. We have a positive reward system in place and I want to allow staff to submit points on the “Reward Submissions” sheet for spending (Bucks) and house points (similar to the House system in Harry Potter movies). I need a formula/function that will take staff submissions from the “Rewards Submissions” sheet and add them to individual student’s Buck column and House Points column on the “Students” sheet. Can you help me?

---

<div class="post-metadata">

**Author:** ![Cody\_Wheeler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cody_wheeler/32/397_2.png) [@Cody\_Wheeler](https://community.glideapps.com/u/Cody_Wheeler)\
**Post date:** [September 23, 2019, 6:33pm UTC](https://community.glideapps.com/t/accumulating-points/513/4 "2019-09-23T18:33:16Z")

</div>

I’m going with what @david said above. Works great!

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [September 23, 2019, 6:41pm UTC](https://community.glideapps.com/t/accumulating-points/513/5 "2019-09-23T18:41:47Z")

</div>

Great. You may want to take a look at what Christie did however as it may give you some ideas on what other teachers are doing for rewarding students.

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [September 23, 2019, 6:58pm UTC](https://community.glideapps.com/t/accumulating-points/513/6 "2019-09-23T18:58:17Z")

</div>

Another thing that Christie did was to allow teachers to award points to a team of students (up to 5) so the teachers would not have to add the points for each one individually. That did result in a pretty convoluted formula in the sheet but will save a bunch of time for the teachers when rewarding points for group efforts. There is also a link in that thread to a pretty interesting teacher in Canada that has a lot of information about “Gamification” of learning. It may be worth your time looking into it.

---

<div class="post-metadata">

**Author:** ![spencersRus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencersrus/32/69_2.png) [@spencersRus](https://community.glideapps.com/u/spencersRus)\
**Post date:** [September 24, 2019, 11:17pm UTC](https://community.glideapps.com/t/accumulating-points/513/7 "2019-09-24T23:17:15Z")

</div>

Not to point to a ‘competitor’. But my school uses ClassDojo for this. Quite successfully.

---

<div class="post-metadata">

**Author:** ![spencersRus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencersrus/32/69_2.png) [@spencersRus](https://community.glideapps.com/u/spencersRus)\
**Post date:** [September 24, 2019, 11:18pm UTC](https://community.glideapps.com/t/accumulating-points/513/8 "2019-09-24T23:18:05Z")

</div>

This future function may help.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/8d346caf30d20f7d672fcdd07bd888b924c43a0c.jpeg)

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [October 1, 2019, 1:31am UTC](https://community.glideapps.com/t/accumulating-points/513/9 "2019-10-01T01:31:45Z")

</div>

This is what I was thinking as well. Have a button for a form that auto submits variables defined by the app creator. As for house points, here’s a demo of one I was working on:

[https://housepoints.glideapp.io/](https://housepoints.glideapp.io/)

Only thing I’m trying to figure out is how to have an inline list that CANT be clicked upon.

---

<div class="post-metadata">

**Author:** ![Lfarley](https://avatars.discourse-cdn.com/v4/letter/l/90db22/32.png) [@Lfarley](https://community.glideapps.com/u/Lfarley)\
**Post date:** [May 27, 2020, 3:58pm UTC](https://community.glideapps.com/t/accumulating-points/513/10 "2020-05-27T15:58:07Z")

</div>

Looking at your House points app. Would that be editable with our own houses names etc…? And if we are just wanting house points and not individual students will this work? We are looking to total them each week and keeping them for a quarter and then starting points over.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [May 27, 2020, 4:02pm UTC](https://community.glideapps.com/t/accumulating-points/513/11 "2020-05-27T16:02:33Z")

</div>

For sure! You can customize with your own house names, images, etc. I’ve even helped other users add photo galleries and other feature requests. At the end of each quarter, you could just clear the sheet to start fresh or if you wanted to keep the legacy data, I could build a way for the value to simply check if it’s the current quarter and update the display appropriately.

---

<div class="post-metadata">

**Author:** ![Lfarley](https://avatars.discourse-cdn.com/v4/letter/l/90db22/32.png) [@Lfarley](https://community.glideapps.com/u/Lfarley)\
**Post date:** [May 28, 2020, 7:31pm UTC](https://community.glideapps.com/t/accumulating-points/513/12 "2020-05-28T19:31:55Z")

</div>

Ok I purchased your app. Where is the best place to go to get information on how to customize it? Should I be able to figure it out pretty easily?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [May 28, 2020, 8:30pm UTC](https://community.glideapps.com/t/accumulating-points/513/13 "2020-05-28T20:30:20Z")

</div>

https://www.loom.com/embed/2799e999788b485195fdedddc41a6a46

---

<div class="post-metadata">

**Author:** ![Lfarley](https://avatars.discourse-cdn.com/v4/letter/l/90db22/32.png) [@Lfarley](https://community.glideapps.com/u/Lfarley)\
**Post date:** [May 29, 2020, 5:19am UTC](https://community.glideapps.com/t/accumulating-points/513/14 "2020-05-29T05:19:06Z")

</div>

Ok I’ve worked on this and have made most of the changes I want although still struggling some with the images. But I can’t figure out how to get the points to add and total? I’m sorry feeling really helpless right now.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [May 29, 2020, 12:34pm UTC](https://community.glideapps.com/t/accumulating-points/513/15 "2020-05-29T12:34:05Z")

</div>

Want to book a time with me today to discuss? [https://wamstech.youcanbook.me](https://wamstech.youcanbook.me)

---

<div class="post-metadata">

**Author:** ![Lfarley](https://avatars.discourse-cdn.com/v4/letter/l/90db22/32.png) [@Lfarley](https://community.glideapps.com/u/Lfarley)\
**Post date:** [May 29, 2020, 4:41pm UTC](https://community.glideapps.com/t/accumulating-points/513/16 "2020-05-29T16:41:18Z")

</div>

Today is a bad day for me. I’m going to continue to work on it and I’ll sign up on Monday if I can’t figure it out. Thank you

---

<div class="post-metadata">

**Author:** ![rubengarza12](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rubengarza12/32/45457_2.png) [@rubengarza12](https://community.glideapps.com/u/rubengarza12)\
**Post date:** [July 28, 2022, 1:04pm UTC](https://community.glideapps.com/t/accumulating-points/513/17 "2022-07-28T13:04:51Z")

</div>

Hi Roberto,

I wanted to check your app out, but it asks for a password. Is there a demo that I can see to see if it’s what we are looking for?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [July 28, 2022, 7:09pm UTC](https://community.glideapps.com/t/accumulating-points/513/18 "2022-07-28T19:09:26Z")

</div>

Search House Points in the template store. It’s in there!

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [July 28, 2022, 7:45pm UTC](https://community.glideapps.com/t/accumulating-points/513/19 "2022-07-28T19:45:53Z")

</div>

Just sharing the House Points app that Robert created and mentioned above for you to find it easily!

> **[House Points Template • Glide](https://www.glideapps.com/templates/house-points-5s)**
>
> Use this app to award and display House Points. Point values can be modified. Enable sign in to make Give Points button accessible to admin only.

---

<div class="post-metadata">

**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/accumulating-points/513/20 "2024-01-17T16:49:25Z")

</div>


