⭐️ Introducing the Rating Component

We have been waiting for user-specific rollups for a long time but there’s no ETA on that.

The only way, for now, with a single user-specific column, is to convert the user-specific column into another sheet, with each value for each user stored into its own row. Then you use a relation + rollup to get back the value you want, but it would consume a lot of rows.

Another way to do it is to have 2 columns, let’s say for ratings of an article.

  • Global total likes for the post
  • Global total ratings for the post
  • Signed-in user’s like for the post (user-specific)

Users will submit a rating through a compound action, let’s say I want to rate 5 for the post:

  • Add 5 to global likes
  • Add 1 to global total ratings
  • Add 5 to signed-in user’s like

Average rating = Global likes/Global total ratings

3 Likes