Thanks for the video. I think that shines much more light on your data structure.
It’s not gonna be easy to replicate all of this in Glide but I think that’s the way you must go to make this work for multiple users.
Firstly without knowing how you’re getting the ratings from the user, I say still make it a user-specific column.
Then you can calculate the percentages by: adding a rollup column to sum the whole user-specific column and then a math column to divide it then times 100 to get the percentage.
Next, after having the percentages, we then need to restructure the countries database a bit.
I imagine you should have a table with:
- Raw score for each of those categories (that you can use some kind of relation and lookup to derive from your Scoring table)
- Final score for each of those categories (math column, based on the raw score and the user input)
Then from those final score, plug that final score back to your “Scoring Sheet” and use multiple math columns to derive each category’s user-specific score and then the final “country scoring”.
Finally I believe you can use an inline list to show top 5 scores of countries.
When you use a user-specific column for the input then your output of this whole process will also be user-specific.
All in all, this is still a very hard rebuild. Hope someone else can chime in with their ideas and good luck!