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 Entr…

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.

@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. [image] Function that increases points in a cell in another sheet Hi I am building an app for our school. We have a positive reward syst…

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

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.

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…

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

This future function may help. [image]

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/ Only thing I’m trying to figure out is how to have an inline list that CANT be clicke…

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.

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…

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?

Accumulating Points

Ask for Help

George_B September 23, 2019, 6:17pm 3

@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.

Topic		Replies	Views
Function that increases points in a cell in another sheet Ask for Help	14	798	September 20, 2019
🏆 House Points Template (updated 7/5/2021) Project Showcase	2	490	July 5, 2021
Evaluate a user's achievement Feature Requests	4	515	March 1, 2020
House Points for Middle School Ask for Help	1	219	November 30, 2021
Will you help a teacher? Ask for Help	7	286	February 3, 2023

Accumulating Points

Related topics