I have a list of items. The app allows users to rate the items by inputting a user specific score (1 - 10). The values are stored in a data column that is specified to be a number, it is restricted to values 1 - 10 and is user specific. So far so good. For example, an item is an apple and receives 3…

First up, if you want an average, you must catch those ratings in separate rows, in another sheet. Then you can make a relation that match the item name in the current sheet with the item name in the newly created sheet, set to match multiple, then rollup the average of that relation’s ratings. We…

Thank you. This is a bit beyond me… do you have an example of the first part ‘you must catch those ratings in separate rows, in another sheet’? Where do those ratings go? In my Users sheet?

No, you should create a new sheet, let’s call it “Rating submissions”. The structure should be: Email | Item ID/name | Rating (number)

I have another idea that wouldn’t require additional rows in another sheet, but first I have a question. Once a rating is submitted, can the user ever change it again? To answer your last question, no you can’t use a math column to average a user specific column value from all users. The calculat…

Increment on 2 columns then a math to divide I guess?

Hi Jeff. - thanks for responding. I would be fine if users were only able to submit a rating once. Does that help?

Sorry for the delay. If a user won’t be allowed to change the rating, then what I’m thinking is that you can use something like a choice component so a user can choose a rating and it will be saved to the user specific column you already created. Next you would create two non-user specific columns…

[image] new Actions! zapzapzap And we can also rollup ratings now! I achieved something similar here. It uses compound actions. I will create a tutorial soon.

@Manan_Mehta that would be helpful, thanks

User specific column for 'rating out of 10'

Ask for Help

Manan_Mehta December 3, 2020, 9:45am 10

I achieved something similar here. It uses compound actions. I will create a tutorial soon.

Topic		Replies	Views
How do I personalize ratings? Ask for Help	11	522	June 21, 2020
Averaging Rating Data Ask for Help	10	1347	July 21, 2024
How can I find average value of a number in a user specific column Ask for Help	6	1245	March 24, 2022
Per user Rating Ask for Help	2	208	February 25, 2023
⭐️ Introducing the Rating Component General	20	2819	February 25, 2021

User specific column for 'rating out of 10'

Related topics