I am having some issues with creating an app that shows individuals an outcome based on their inputs.
Basically, users rate 14 categories from 1 to 5, these scores are then tallied and used to weight some background data in order to get an output for that user based on the scores given.
My issue is that as soon as a new user opens the app and starts rating category 1, this impacts the choices already submitted by someone say on category 10. How do I get a new instance of inputs for each user, and furthermore how would I then keep calculations seperate
Thanks, how do I then link this user specific column to cells used in the sheet to do calculations? I am allowing users to give a rating from 1-5 (stars) where this is then used to doe some weighting calculations on the google workbook
User Specific Column (USC) values are not brought back to G-Sheet.
The easiest is to do your calculations directly in the Glide dataeditor with “Maths” column
Ex.
(Column type Basic / Number with USC ticked) User Data
(Column type Basic / Number) Weight
(Column type Maths) Calculation => type the formula U * W, than state U = column User Data and W = Weight.
Then it will calculate automatically
Yes, but more advanced, and in addition it can have some lag (time to synchronize go & back between Glide and G-Sheet)
The principle is to copy the user specific value entered by the user in an other (non user specific) column that will be synchronised with G-Sheet.
This requires to trigger an “Action” to create the flow and therefore you’ll need a button that the user will click after selecting ones grade (1 to 5).
I don’t use G-Sheet, but the principle in action should probably be this:
Hum… you’re probably right indeed, sorry for the wrong idea (not very at ease with working with G-Sheet & User specific).
Finally, I wonder if you should use a Form hosting your Choice Components of grades. But the big drawback, is that it would require to create 1 row per selection per user (in another tab).
thanks for the insights so far. Have learned a lot. Do you think we could do a google meet or something so I can explain my issue to you both and we can try and solve it?
Maybe we need to know how you’re doing the Sheet calculations in order to make the full flow work with user specific columns. I always try to keep things in Glide, unless you absolutely need it to appear in the Sheets to do some third party integrations.
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.
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!
there are 2 ways to do that… (you did not show how users are ranking it in the App so my answer might not be relevant)
keep ranking entry on separate sheet with user ID, topic and rate columns and record each event separately, using action add row… then you just run query on that sheet to get your average rates.
have pre-calculated average rating for each option 1-5 and you will replace main score with this value using action set columns + increment +1 numbers of votes… this would be the easiest fix
I think I’d be looking to flip (transpose) how you have that laid out. So instead of lining your countries up in columns, have them all in a single column with one country per row. If you do it that way, then you only need to define each calculation once. The way you have it at the moment, it will be a nightmare to maintain, especially if you need to come back later and add/remove countries.