So I’m trying to make an app for my school where stydents can complete fun, mindful, and educational chllanges to earn points. Different challenges have different point values, and I approve student’s submissions after they submit, and they get points. I want the app to record the total points someone has (assigned to their email) and show it, and use the points to place the students in a ranking system.
I can’t figure out how to do the rollup to calculate each individual person’s total points.I’ve tried this method:
In my submissions table,
Created a Template column that pull in the values from the user’s email column
Created a relation column to link the emails in the template column to the emails that students enter in the submissions table.
Tried to create a rollup column to roll up values from my relation column.
It seems like I can’t use a relation column as a source for my rollup. Is there a work around for this?
Do you have the ‘Multiple’ check box selected in the relation?
Instead of a relation you could use a Query column and eliminate the need for template columns.
Also, I noticed you have emails that sometimes have uppercase letters and sometimes don’t. Be careful with that because relations and queries will be looking for exact matches. If letter case doesn’t match, the relation or query won’t return a match.
At a basic level, you could use case number 2 in the following post. Instead of pointing the lookup at the entire table, you would point it at your sorted query. This works at a basic level, but gets complicated if you start to have ties. All depends on how you would expect ties to be handled.
I’ve tried using rollup columns and templates and query columns multiple times to try to make a ranking system..
It seems like glide won’t let me use a template or query column as a source for a rollup column.
what other simpler way can I use to create a ranking system?
I’m trying to do everything through my “Users” tab (photo attatched below).
What’s the purpose of the template column? Using that will cover a number to text, which can’t be rolled up using sum.
Why are you trying to create a relation using points? I thought you were trying to create a relation using the student email. Isn’t that what you want, so you can summarize points for each student? Isn’t that what you already have to get the total points already?
Like I said above, if you ate using the template column, it’s not going to give you a number, so you can’t use it for a sum. You didn’t have to always use a template column to create a relation. And like I said earlier, you could have used a query column to create your initial relation and not need template columns at all.
Not sure I follow what the purpose of this is for.
I think we need to back up a bit. You already have total points for each student. Go back and look at Darren’s case #2 video. Create a query column in place of a relation that retrieves all rows for the students, but sorts the results by total points. The rest of Darren’s steps should be the same.
Could you walk me through the steps?
