# Add a star rating review **URL:** \ **Category:** Feature Requests\ **Created:** [November 25, 2019, 2:36am UTC](https://community.glideapps.com/t/add-a-star-rating-review/2366 "2019-11-25T02:36:51Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Amy\_McPherson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/amy_mcpherson/32/1164_2.png) [@Amy\_McPherson](https://community.glideapps.com/u/Amy_McPherson)\ **Post date:** [November 25, 2019, 2:36am UTC](https://community.glideapps.com/t/add-a-star-rating-review/2366/1 "2019-11-25T02:36:51Z")
Mentioned this in an email with Glide some time back but thought I would add it here in case there was a workaround etc. Basically what I would like to do is have users be able to leave a star-rating/review of a place or product that is listed in my app. I understand this isn’t possible at the moment but does anyone have a workaround solution? ---
**Author:** ![zzoldan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zzoldan/32/452_2.png) [@zzoldan](https://community.glideapps.com/u/zzoldan)\ **Post date:** [November 25, 2019, 3:22am UTC](https://community.glideapps.com/t/add-a-star-rating-review/2366/2 "2019-11-25T03:22:43Z")
Hey there, You can create a Choice component in a form where there are 5 options: 1 star, 2 star, etc. One of the backend fields that users don’t touch must be the item/name they’re reviewing so that this choice matches the review. The user then opens the form, selects their rating/review, and using the Inline List component you can attach this back to the item they’re reviewing. Hope this helps! Please don’t hesitate to reach out for clarity. ---
**Author:** ![TSam](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tsam/32/599_2.png) [@TSam](https://community.glideapps.com/u/TSam)\ **Post date:** [November 25, 2019, 3:32am UTC](https://community.glideapps.com/t/add-a-star-rating-review/2366/3 "2019-11-25T03:32:07Z")
@zzoldan, I was looking for a solution to a similar issue. I already tried what you suggested, using a choice component. But it records the last user’s rating. Ideally, we should be able to display an average rating for each item rather than the last submitted rating. There should be a spreadsheet workaround to achieve this. I haven’t tried any yet. ---
**Author:** ![zzoldan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zzoldan/32/452_2.png) [@zzoldan](https://community.glideapps.com/u/zzoldan)\ **Post date:** [November 25, 2019, 3:36am UTC](https://community.glideapps.com/t/add-a-star-rating-review/2366/4 "2019-11-25T03:36:29Z")
That’s true, as it really depends if you’re looking for a list of ratings/review, or an average to display with the title. You can always take the user-submitted ratings and then use the Math component or an Average formula to display the average. For example, if User A gives 5 stars, and User B gives 3, you can run the Average formula to conclude that the “Current rating is roughly 4 Stars.” Alternatively, you can keep a list of all the users who have their reviews/ratings. Hope this helps a bit more! ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [November 25, 2019, 5:11am UTC](https://community.glideapps.com/t/add-a-star-rating-review/2366/5 "2019-11-25T05:11:18Z")
I implemented a solution and put a demo together. See this post: > [@How to implement star ratings - Demo \[Update: Glide released this as a native component.\]](https://community.glideapps.com/t/demo-of-how-to-implement-ratings/2371): > > In response to the topic linked below and other request for how to include some kind of rating system within a Glide app I wrote this [Ratings Demo App](https://ratingsdemo.glideapp.io). I seem to remember someone else implementing it but I couldn’t find it, so here is my take on how to do it. It’s copyable so you can take a look at the spreadsheet and the Glide components. It’s a little more work than I thought because you have to come up with an average of all ratings for a given item, but the magic of Google Sheets came thro… ---
**Author:** ![zzoldan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zzoldan/32/452_2.png) [@zzoldan](https://community.glideapps.com/u/zzoldan)\ **Post date:** [November 28, 2019, 7:16pm UTC](https://community.glideapps.com/t/add-a-star-rating-review/2366/6 "2019-11-28T19:16:46Z")
Great minds think alike! ---
**Author:** ![Les\_Henderson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/les_henderson/32/1142_2.png) [@Les\_Henderson](https://community.glideapps.com/u/Les_Henderson)\ **Post date:** [November 28, 2019, 9:25pm UTC](https://community.glideapps.com/t/add-a-star-rating-review/2366/7 "2019-11-28T21:25:32Z")
And fools seldom… …copy @George_B’s great apps while they can. ---
**Author:** ![MI\_I](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mi_i/32/2794_2.png) [@MI\_I](https://community.glideapps.com/u/MI_I)\ **Post date:** [February 15, 2020, 5:11am UTC](https://community.glideapps.com/t/add-a-star-rating-review/2366/10 "2020-02-15T05:11:05Z")
I want to sort the appearance of the user on the app based on the rating value. Those with high ratings are on the app’s display while the low ratings are listed below, is there a way ??? And that will appear that only a few sellers with a radius of 2 kilometers from the distance of the seller to the consumers is now updated… by the way, I can’t give a star color to Rating, do you know how ?? ---
**Author:** ![Ms\_Mere](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ms_mere/32/10341_2.png) [@Ms\_Mere](https://community.glideapps.com/u/Ms_Mere)\ **Post date:** [June 26, 2020, 5:46am UTC](https://community.glideapps.com/t/add-a-star-rating-review/2366/11 "2020-06-26T05:46:17Z")
> [@zzoldan](#): > > One of the backend fields that users don’t touch must be the item/name they’re reviewing so that this choice matches the review. Hello. How do I go about choosing a backend field. In my instance, I have an item seleceted that the user can’t touch, but it isn’t being added to my sheet when when the reveiw is submitted. All reviews are appearing on all products. Thanks for any assistance you can provide. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [June 26, 2020, 7:43am UTC](https://community.glideapps.com/t/add-a-star-rating-review/2366/12 "2020-06-26T07:43:54Z")
Here’s my take on a rating component: > [@How-To: Custom Rating Component](https://community.glideapps.com/t/how-to-custom-rating-component/11286): > > wave Hey all! I know Glide came out with their own Ratings component, but it doesn’t Roll up averages over user specific columns. I managed to come up with a custom-built solution that’s an improvement to a simple drop down menu of ratings. Here’s how: [[Glide: Create your own 5-Star (or whatever) Rating Component] ](https://www.youtube.com/watch?v=O7TEF5z5t7U) If you’d like to play around with an example, visit my Experiments app and visit the Ratings tab: ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 29, 2020, 11:07pm UTC](https://community.glideapps.com/t/add-a-star-rating-review/2366/13 "2020-06-29T23:07:50Z")
When using a form, there are components you can add that fall under to column values category. These are all of the column values from the detail record where you placed the form button. You can use those components to automatically pass the value along with the form submission. Here you would submit the item name or ID along with the review. To display only the reviews that belong to that item, you need to create a relation column to link the item to the item name/id in the form response sheet. The relation is what you use in an inline list to display all of the reviews for that item. > **[Column values](https://docs.glideapps.com/all/reference/privacy-and-per-user-data/special-values/column-values)** > > Submit existing column values on behalf of the user. ---
**Author:** ![Yevhen\_Lopukhin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yevhen_lopukhin/32/1410_2.png) [@Yevhen\_Lopukhin](https://community.glideapps.com/u/Yevhen_Lopukhin)\ **Post date:** [July 22, 2020, 10:04am UTC](https://community.glideapps.com/t/add-a-star-rating-review/2366/14 "2020-07-22T10:04:17Z")
Z2:Z ={ “Rate Sum”; ARRAYFORMULA(IF(NOT(ISBLANK(A2:A)), (SUMIF(A2:A,A2:A,R2:R)),))} AA2:AA ={ “Rate Count”; ARRAYFORMULA(IF(NOT(ISBLANK(A2:A)), (COUNTIF(A2:A,A2:A)),))} ={ “Rate Average Calc”; ARRAYFORMULA(IF(NOT(ISBLANK(A2:A)), ((Z2:Z)/(AA2:AA)),))} Where A2:A - Identifier, not necessary ID, and R2:R - Glide Rating (1,2,3,4,5) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 22, 2020, 10:28am UTC](https://community.glideapps.com/t/add-a-star-rating-review/2366/15 "2020-07-22T10:28:09Z")
You can do rollups with this inside Glide editor.