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 value.

Then you can have a math column to have the average rating of the item, while also keep the user-specific rating to show it right on the same screen.

2 Likes