# How to implement ⭐ ratings - Demo \[Update: Glide released this as a native component.\]
**URL:** https://community.glideapps.com/t/how-to-implement-ratings-demo-update-glide-released-this-as-a-native-component/2371
**Category:** Project Showcase
**Created:** [November 25, 2019, 5:10am UTC](https://community.glideapps.com/t/how-to-implement-ratings-demo-update-glide-released-this-as-a-native-component/2371 "2019-11-25T05:10:12Z")
**Posts on this page:** 15
**Page:** 1
### Author:  [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [November 25, 2019, 5:10am UTC](https://community.glideapps.com/t/how-to-implement-ratings-demo-update-glide-released-this-as-a-native-component/2371/1 "2019-11-25T05:10:12Z")
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 through with its very versatile QUERY function. Enjoy!
> [@Add a star rating review](https://community.glideapps.com/t/add-a-star-rating-review/2366):
>
> 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:  [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)
#### Post date: [November 25, 2019, 6:07am UTC](https://community.glideapps.com/t/how-to-implement-ratings-demo-update-glide-released-this-as-a-native-component/2371/5 "2019-11-25T06:07:14Z")
George, I give you 5 ⭐ for this demo! 👍🏻
---
### Author:  [@Paul](https://community.glideapps.com/u/Paul)
#### Post date: [November 25, 2019, 12:23pm UTC](https://community.glideapps.com/t/how-to-implement-ratings-demo-update-glide-released-this-as-a-native-component/2371/6 "2019-11-25T12:23:30Z")
That some nice work George! I’ll be using that to learn more about QUERY, LEN and ARRAY formulas it seems. 🙂
---
### Author:  [@Ramo](https://community.glideapps.com/u/Ramo)
#### Post date: [November 28, 2019, 5:37pm UTC](https://community.glideapps.com/t/how-to-implement-ratings-demo-update-glide-released-this-as-a-native-component/2371/7 "2019-11-28T17:37:53Z")
George, this has been SUPER helpful! Thank you! I also wasn’t aware of the QUERY or ARRAY functions.
---
### Author:  [@jusembo](https://community.glideapps.com/u/jusembo)
#### Post date: [December 13, 2019, 3:26pm UTC](https://community.glideapps.com/t/how-to-implement-ratings-demo-update-glide-released-this-as-a-native-component/2371/8 "2019-12-13T15:26:20Z")
Could you please add several ratings in order to rate several different topics? Thanks
---
### Author:  [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [December 13, 2019, 3:32pm UTC](https://community.glideapps.com/t/how-to-implement-ratings-demo-update-glide-released-this-as-a-native-component/2371/9 "2019-12-13T15:32:39Z")
Welcome to the community.
Just duplicate the demo sheets that I have and give it a try yourself. It shouldn’t be too hard to clone the concept.
---
### Author:  [@jusembo](https://community.glideapps.com/u/jusembo)
#### Post date: [December 13, 2019, 10:47pm UTC](https://community.glideapps.com/t/how-to-implement-ratings-demo-update-glide-released-this-as-a-native-component/2371/10 "2019-12-13T22:47:40Z")
 [quote=“George\_B, post:1, topic:2371, full:true”]
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 through with its very versatile QUERY function. Enjoy!
> [@Add a star rating review](https://community.glideapps.com/t/add-a-star-rating-review/2366):
>
> 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?
[/quote]
I’m looking to do something like on this screen shot
---
### Author:  [@jusembo](https://community.glideapps.com/u/jusembo)
#### Post date: [December 19, 2019, 9:11am UTC](https://community.glideapps.com/t/how-to-implement-ratings-demo-update-glide-released-this-as-a-native-component/2371/11 "2019-12-19T09:11:12Z")
Hello George, coul you give one more clue about how to make this think happen?
---
### Author:  [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [December 19, 2019, 3:10pm UTC](https://community.glideapps.com/t/how-to-implement-ratings-demo-update-glide-released-this-as-a-native-component/2371/12 "2019-12-19T15:10:08Z")
I don’t have any more clues than what I provided. It’s a working app, set up to be a template, that you can make a copy of. Open the spreadsheet and take a look at the formulas.
---
### Author:  [@Avery\_Rawlek](https://community.glideapps.com/u/Avery_Rawlek)
#### Post date: [January 3, 2020, 6:17pm UTC](https://community.glideapps.com/t/how-to-implement-ratings-demo-update-glide-released-this-as-a-native-component/2371/13 "2020-01-03T18:17:50Z")
Great template, thanks! I’m really enjoying learning to use Glide!
---
### Author:  [@moses5407](https://community.glideapps.com/u/moses5407)
#### Post date: [February 9, 2020, 11:11am UTC](https://community.glideapps.com/t/how-to-implement-ratings-demo-update-glide-released-this-as-a-native-component/2371/14 "2020-02-09T11:11:35Z")
Here’s a proper math framework for star rankings:
[http://www.evanmiller.org/ranking-items-with-star-ratings.html](http://www.evanmiller.org/ranking-items-with-star-ratings.html)
---
### Author:  [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [February 9, 2020, 12:42pm UTC](https://community.glideapps.com/t/how-to-implement-ratings-demo-update-glide-released-this-as-a-native-component/2371/15 "2020-02-09T12:42:56Z")
Interesting article. Reading the first paragraph made sense for sure.
_“The main problem addressed here is what to do with items that have a small number of ratings, since an item with a single perfect rating probably should not sit atop a list of top-rated items. Unlike my previous [Bayesian work](https://www.evanmiller.org/bayesian-average-ratings.html), the method here is not exact, but it should work pretty well in most cases, and has the virtue of being (relatively) easy to compute.”_
After that I was lost! Here is the easy to compute formula:
---
### Author:  [@Shannon\_Joseph](https://community.glideapps.com/u/Shannon_Joseph)
#### Post date: [May 29, 2020, 4:40pm UTC](https://community.glideapps.com/t/how-to-implement-ratings-demo-update-glide-released-this-as-a-native-component/2371/16 "2020-05-29T16:40:35Z")
Geoege,
How would I create this rating system when someone is viewing a listing?
---
### Author:  [@HeddaBO](https://community.glideapps.com/u/HeddaBO)
#### Post date: [July 10, 2020, 2:40pm UTC](https://community.glideapps.com/t/how-to-implement-ratings-demo-update-glide-released-this-as-a-native-component/2371/17 "2020-07-10T14:40:44Z")
Hi, I’m looking for a way for individuals to rate a place (like restaurants or hotels) and then aggregating the rating so that in the end the total rating might be 4.5/5.0 or similar. How to do this?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 10, 2020, 2:41pm UTC](https://community.glideapps.com/t/how-to-implement-ratings-demo-update-glide-released-this-as-a-native-component/2371/18 "2020-07-10T14:41:36Z")
You can see the video here.
> [@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: