Rating in multiuser environments

[Ganymed]

Ratings are really nice way to provide feedback.

In a multiuser environment I would need a simple way to calculate the average value of the feedback or maybe even show based on how many. Does anyone have a light solution?

[ThinhDinh]

Here’s my way to approach this.

Preserve visibility of star ratings after being submitted by user

I have never used a rating component outside a form. I usually write the rating via a form/add row action to a Ratings sheet so I can do rollups and show ratings afterwards. There’s another method that you can do with compound action, which is: Show a rating component Have a button that says something like “Send your rating”. Increment a “Global rating total” column by the rating value. Increment a “Global rating count” column by 1. Increment a “User rating” user-specific column by the rating…

[Ganymed]

Thanks… .did not thing of it but than how do you display the result…star and such…

[ThinhDinh]

I use Unicode characters. ★ and ☆.

[Ganymed]

Ah way beyond my current skill, could you help?

[Darren_Murphy]

https://unicode-table.com/en/search/?q=star

Just copy/paste the ones you want to use.

[Ganymed]

Thanks, and how do I represent a 3.2 rating?

[Darren_Murphy]

haha, I have no idea. I guess you’d need to get a bit creative

[ThinhDinh]

I have a solution ready.

Experimental Code link:

https://thinhdinhlca.github.io/rating-stars/

Then display the result in a rich text component.

[Darren_Murphy]

hehe, nice

but… I was just looking at your source. Is a code column actually necessary? I mean, couldn’t you just use a standard template column and use the calculated perc value as a replacement?

[ThinhDinh]

Yes, that’s true, I was lazy so I just want to paste the link to generate it the next time

[JuanM]

I was also lazy and I made it simple