# Automatic star rating based on likes and dislikes

This trick is for the ones that want to make a rating mechanism that depends on the number of likes and dislikes of a given row.

Columns youāll need:
[likes] - normal column - Decimal - hidden
[dislikes] - normal column - Decimal - hidden
[rating] - virtual column - Decimal - shown

Formula for the column [rating]: IF(AND( [likes]>0, [dislikes]>0), ([likes]/([likes]+[dislikes]))*100.00, 0)

So, based on that formula from above weāll get a score between 0 and 100 wich is the percentage that the likes represent in the global sum of likes and dislikes (the 100% of ratings). If we divide 100 by 5 (the number of stars we want) we get 20 wich is the ratio of increase we set for each rule. So a score from 1 to 19 is true for 1star rule, 20 to 39 is true for 2stars rule and so on.

Format rules for [rating] column

• 0stars - Highlight color: gray - text color: white - Formula: [rate]=0.00
• 1 star - Highlight color: #FFD300 - Text color: white - Formula: [rate]>0.00
• 2stars - Highlight color: #FFD300 - Text color: white - Formula: [rate]>20.00
• 3stars - Highlight color: #FFD300 - Text color: white - Formula: [rate]>40.00
• 4stars - Highlight color: #FFD300 - Text color: white - Formula: [rate]>60.00
• 5stars - Highlight color: #FFD300 - Text color: white - Formula: [rate]>80.00

We use a custom color #FFD300 because the default yellow doesnāt look so good. And we use white for the text to hide the score. And Youāll get this in your detail view: or this if it has no stars

Actions:
like - Display inline into [rating] - Data: set the values from some columns - [likes]+1
dislike - Display inline into [rating] - Data: set the values from some columns -
[dislikes]+1

Formatting for like and dislike actions

• like action - icon: smile - Highlight color: green
• dislike action - icon: meh - Highlight color: red
Yuāll get this in your detail view:

Select āNo headingsā in your detail view. And customize as you wish. Depending on what youāre doing, this is the final result:

I hope it helps! Would you like a sample app?

Hi @Francios, hereās the app but I donāt know how to make it a sample app.

13 Likes

Thatās cool!

1 Like

Cool @Rene_Casana_Amaya. Sample app would be appreciated thanks.

1 Like

This is a nice implementation of ratings system @Rene_Casana_Amaya

Thank you

1 Like

Hi Rene,

Thanks! I understand that you use 5 formatting rules for 5 [rating] scenarios. But format rules, you can chose 1 star but not 5 consecutive starsā¦ . See Picture

No, each formatting rule only shows up if the rating is above a certain number. Since 100 is above all
Of the set numbers for all 5 rules, 5 stars would show up, but if the value was only above 3 of the set values in the formulas, 3 stars show up.

1 Like

Yes! Got it! Just came back from a long travel. Need to warm up again to appsheetā¦Thanks!

Exactly, thatās why we make five formatting rules, because a single rule wonāt give you all the stars you need, each star will show up depending on the score.

Letās say our item to score has 343 likes and 299 dislikes, with the formula we get a score of 54. The first rule will trigger true and will show the first star because the score is major than 0, the second rule will trigger true too because the score is major than 20 and the third will trigger too because is major than 40, forth and fifth rule wonāt trigger showing a star because the score is lower than the vale upon they trigger true wich is 60 and 80 respectively. And we get three stars.

Make sure that all five format rules are applied to the column [score].
Iād like to see the results.

Thanks @Rene_Casana_Amaya.

1 Like

@Rene_Casana_Amaya Thank you for sharing this Tipp.
You could add extra format rules to show also grey stars. So you will have also 5 stars in sum like this:

3 Likes

That was my first thought when I was making the formatting rules but unfortunately I think this is not possible because each formatting rule overrides the previous colors over the icons so when you apply the last rule all of the other icons adopt the same color, basically we end up with all gray stars.

Thank you @Rene_Casana_Amayaā¦ I have tried and it worksā¦ How to limit one user one response (like or dislike)?

To do that youāll need that the people sign in and it has a cost of \$5 per user.

If you canāt pay for each user, then what you can do is use a date field that disables the like action after is triggered and enables it again after 1 day passed. This will ensure that the user can give likes only once a day, is not a good solution but is enough to prevent users from overliking an item.

1 Like

You could leverage the Device UUID is via CONTEXT(āDeviceā)

3 Likes

I use one column [Likes] show as Action button, and have another VC showing [Likes] as total of the Likes. What expression to achieve limit by Device UUID using CONTEXT(āDeviceā), should I add a column of UUID and using SELECT and COUNT?

I would create a child table of likesā¦
Everytime they like, or unlike the āparentā item, it fires an action to add/delete a record with the Device UUID and Parent ID datetime, etcā¦ then a VC on the parent item that looks for thatā¦ to know if it is liked or notā¦

You may also want to build an āentry formā in which they can add their name or other infoā¦ One way push, security filter set to FALSEā¦ This will allow you collect the device IDs so that you correlate likes with other things down the road, or even perform technical support backend in which you merge multiple devices, etcā¦

This also creates a referenced situation that you could show that device their ālikedā contentā¦

6 Likes

1 Like

Some variations/ expansion based on excellent concept shared by @Rene_Casana_Amaya to show half stars and empty stars in addition to full stars

1. The example below shows half star rating such as (0.5. 2.5 etc. on a scale of 5) and also to include the empty stars to always show 5 stars.
Examples Below:

This was done in response to the following question thread.

1. The column in this example where the user enters the numerical rating is called [NumberPart]

Column Type- Decimal, Increase /decrease steps of 0.5, decimal digits of 1 , minimum value of 0 and max of 5

1. The format rules for empty stars are. as below There are 5 such format rules each with one empty star icon each.

A) [NumberPart]< 4.5
B) [NumberPart]< 3.5
C) [NumberPart]< 2.5
D) [NumberPart]< 1.5
E) [NumberPart]< 0.5
Example Below:

2. The format rule for half star rating is as below. Only one rule for half Icon

OR([NumberPart]=0.5 , [NumberPart]=1.5,[NumberPart]=2.5, [NumberPart]=3.5,[NumberPart]=4.5)

Example Below:

1. The format rules for full stars are as follows. here are 5 such format rules each with one * full star icon** each.

A) [NumberPart]> 4.5
B) [NumberPart]> 3.5
C) [NumberPart]> 2.5
D) [NumberPart]> 1.5
E) [NumberPart]>0.5

Example Below:

Miscellaneous:
6) Format Rules- Highlight color #FFD300 , Text Color #FFFFFF

1. Attach all the format rules to a text column with app formula ā.ā one may show this column only in detail and table views. This is done so that the column text does not occupy large space with the icons

2. Some reordering of format rules order may be required so that half star icons appear after full star icons. Initially they appeared in the beginning.

Hi @Kirk_Masden: As you had requested, I have tried to document. Hope it helps.

5 Likes

Now I finally understand. Thanks!

1 Like

Thanks to @Suvrutt_Gurjar for this ingenious solution.

I think itās the best that can be done under the current circumstances but Iām looking forward to the day when a completely text-based solution will be possible.

First, for those of you who may not have see it, I should point out that @Steve has provided us with a simple way of converting numbers into text stars, as long as we donāt need the half stars:

It should also be possible to do the same thing with half stars but, alas, most systems donāt support that yet. Hereās some information about the half star, which has been included in UNICODE:

This page has a link to a browser test page and that page, in turn, provides a list of fonts that support the half star. I downloaded the two truetype fonts (the third is bitmap and, hence, not really usable) and was pleased with the results:

I think that both are attractive as Japanese fonts and so, as someone who works with that language, Iām happy to add them to my arsenal. However, as far as I can tell, these fonts canāt be added to smartphones. (I may be wrong about this but I couldnāt figure out how to add them to phones.)

This little exercise has taught me that UNICODE is expanding nicely but that we are held back by lack of font support. I hope the day will come when all phones (and, of course, AppSheet fonts) will be able to display anything for which UNICODE has been established but, unfortunately, we donāt seem to be there yet.

2 Likes