# How-To: Custom Rating Component

**URL:** <https://community.glideapps.com/t/how-to-custom-rating-component/11286>\
**Category:** Project Showcase\
**Created:** [June 22, 2020, 9:58pm UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286 "2020-06-22T21:58:12Z")\
**Posts on this page:** 19\
**Page:** 2

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [August 29, 2020, 7:12pm UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286/21 "2020-08-29T19:12:37Z")

</div>

Prettty neat that. Very useful, thanks 🙏

---

<div class="post-metadata">

**Author:** ![South\_Pigalle](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/south_pigalle/32/14367_2.png) [@South\_Pigalle](https://community.glideapps.com/u/South_Pigalle)\
**Post date:** [September 29, 2020, 10:24am UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286/22 "2020-09-29T10:24:10Z")

</div>

Hey @Robert_Petitto, thanks for this tutorial. It is very interesting and helped me a lot! I have just one question still outstanding (maybe as I am pretty new on Glide and don’t know how to code). During the video you ask to convert a rounded number into a string thanks to a template column. I am clueless to do that. Can you please elaborate ?  
Thanks  
Fred

---

<div class="post-metadata">

**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:** [September 29, 2020, 10:32am UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286/23 "2020-09-29T10:32:22Z")

</div>

In the math column, you round up the number up until how many decimals you like, then make a template column pointing to the math column to “lock” the format in, then you’re good to go.

---

<div class="post-metadata">

**Author:** ![South\_Pigalle](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/south_pigalle/32/14367_2.png) [@South\_Pigalle](https://community.glideapps.com/u/South_Pigalle)\
**Post date:** [September 29, 2020, 10:52am UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286/24 "2020-09-29T10:52:57Z")

</div>

🤯 thanks for your help @ThinhDinh … It was really easy indeed but I had no clue that it was possible and so… looked for complicated solutions and failed!

---

<div class="post-metadata">

**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:** [September 29, 2020, 11:04am UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286/25 "2020-09-29T11:04:19Z")

</div>

Do tell us if you need more help my friend, have a nice day!

---

<div class="post-metadata">

**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\
**Post date:** [November 19, 2020, 9:35pm UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286/26 "2020-11-19T21:35:58Z")

</div>

Ghosh! this is the one I was looking for.

---

<div class="post-metadata">

**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\
**Post date:** [November 19, 2020, 10:11pm UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286/27 "2020-11-19T22:11:44Z")

</div>

@Robert_Petitto was there any particular reason why you did not use say a rating from 1-5 wrapped in an ITE so that if rating received equals 1, then 1 star, and so forth. I did not have to use any choice components; just one of the Glide 1-5 star ratings. My use case is different and serves my purpose, but just wanted to know since your example avoided USC.

---

<div class="post-metadata">

**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:** [November 20, 2020, 1:35am UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286/28 "2020-11-20T01:35:56Z")

</div>

This was an older post—at the time the rating component didn’t work in forms nor did it allow for a display value apart from from the choice value. I only use this method now when creating dynamic choice components based off a relation/

---

<div class="post-metadata">

**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\
**Post date:** [November 20, 2020, 1:48am UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286/29 "2020-11-20T01:48:12Z")

</div>

Got it ! Thanks.

---

<div class="post-metadata">

**Author:** ![A\_Healy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/a_healy/32/20240_2.png) [@A\_Healy](https://community.glideapps.com/u/A_Healy)\
**Post date:** [January 22, 2021, 6:10am UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286/31 "2021-01-22T06:10:26Z")

</div>

I’m new to Glide and might be in over my head but I’ve attempted to replicate the roll up averages. I have 17 development options that I want to show roll up ratings on, and noticed that the rating I give to one type of option, ends up showing up as the rating for not just that option but for the 16 other options on my list. Is there something obvious I missed?

Here’s a screenshot of my data that I tried to follow your tutorial with

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/b/fbba6ce2eb8a531aa54f2f0127eb3e1b688b2c0f.png)

---

<div class="post-metadata">

**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:** [January 22, 2021, 8:41am UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286/32 "2021-01-22T08:41:50Z")

</div>

What are you using for the relation to the ratings sheet?

---

<div class="post-metadata">

**Author:** ![A\_Healy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/a_healy/32/20240_2.png) [@A\_Healy](https://community.glideapps.com/u/A_Healy)\
**Post date:** [January 22, 2021, 5:19pm UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286/33 "2021-01-22T17:19:18Z")

</div>

Thanks for your reply! I hope I’m able to answer your question correctly, still very much getting my bearings on everything…

I have a “Reviews” tab that I populated the submitted ratings with, and then used that column to relate to the Ratings column I created in my “Resources” tab (attempting to follow Robert’s tutorial). My “Options List” tab has a relation column where I tried to pull in the ratings from the “Reviews” tab to then generate the rollup rating display. For what it’s worth, below is a screenshot of my “Reviews” tab that I have related as a column in my “Options List” tab

 ![Screenshot 2021-01-22 091807](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/4/145a46b8c7dee885a102ddb64e34c9a730b58dfc.png)

---

<div class="post-metadata">

**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:** [January 22, 2021, 11:23pm UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286/34 "2021-01-22T23:23:14Z")

</div>

So you’re linking the two sheets using the scenario option column, is that correct?

Can you tell me where it doesn’t work as expected?

---

<div class="post-metadata">

**Author:** ![A\_Healy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/a_healy/32/20240_2.png) [@A\_Healy](https://community.glideapps.com/u/A_Healy)\
**Post date:** [January 22, 2021, 11:46pm UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286/35 "2021-01-22T23:46:24Z")

</div>

That’s correct. The part that doesn’t seem to be working is that the star ratings that are submitted across _different_ types of scenario options are all being averaged together- I was hoping/expecting that the star ratings submitted for one type of scenario would be averaged and separate from star ratings for another type of scenario option.

Is this where creating a UUID (attached to each scenario option) would help?

---

<div class="post-metadata">

**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:** [January 23, 2021, 12:38am UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286/36 "2021-01-23T00:38:07Z")

</div>

Are you rolling things up on the relation you created? (The AvgRating column)

---

<div class="post-metadata">

**Author:** ![ehdubya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ehdubya/32/24087_2.png) [@ehdubya](https://community.glideapps.com/u/ehdubya)\
**Post date:** [January 23, 2021, 1:24am UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286/37 "2021-01-23T01:24:44Z")

</div>

You can roll up relations, but no User Specific data - correct?

---

<div class="post-metadata">

**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:** [January 23, 2021, 4:27am UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286/38 "2021-01-23T04:27:04Z")

</div>

Correct.

---

<div class="post-metadata">

**Author:** ![ehdubya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ehdubya/32/24087_2.png) [@ehdubya](https://community.glideapps.com/u/ehdubya)\
**Post date:** [January 23, 2021, 4:34am UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286/39 "2021-01-23T04:34:22Z")

</div>

👌🏻 Thanks!

---

<div class="post-metadata">

**Author:** ![everys](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/everys/32/10724_2.png) [@everys](https://community.glideapps.com/u/everys)\
**Post date:** [January 23, 2021, 5:33am UTC](https://community.glideapps.com/t/how-to-custom-rating-component/11286/40 "2021-01-23T05:33:11Z")

</div>

well-crafted!

[Previous page](https://community.glideapps.com/t/how-to-custom-rating-component/11286.md?page=1)
