hi, i have developed a star rating system in google sheet, but how do display this rating in my app? here is an example i have created in google sheet.
please advise with thanks
Hi @Beauchic_Sdn_Bhd! Welcome to the community!
Perhaps you could combine the stars in your Google spreadsheet using concatenate and then bring that into your app.
By the way, how do you get half stars and the empty stars? Could you share the formula you are using?
1 Like
I got interested in this and found that half stars are available in newer UNICODE but I don’t seem to be able to display the half stars on my Mac. So, I suspect that they will not display easily on various devices. Still, I’m very interested in how you are doing this on Google sheets.
hi @Kirk_Masden, i dont think is possible to combine the stars into 1 cell by using concatenate. i have tried the formula, but is not showing up the stars.
here is the link to the file for the stars, you can see the formula an you can try it out too (please make a copy and customize it for yourself):
Please do share with me if you have the solution, thank you
I made a little app with a virtual column that has the following expression:
concatenate(ifs(floor([yournumber])=1,"★",
floor([yournumber])=2,"★★",
floor([yournumber])=3,"★★★",
floor([yournumber])=4,"★★★★",
floor([yournumber])=5,"★★★★",),
if(floor([yournumber])=[yournumber],"","☆"))
Here is what the result looks like:
It’s not the same as yours because I couldn’t find a half-star character.
Also, I don’t think that AppSheet has the equivalent of a rept() function. That would be convenient in such circumstances.
1 Like
It seems that the half star isn’t quite ready for prime time yet, in terms of general adoption.
But, SVG might work for you. SVG can be used in AppSheet:
[SAMPLE APP: Custom SVG App Icons](https://community.appsheet.com/t/sample-app-custom-svg-app-icons/28157) Tips & Tricks ?
Intro SVG images can be used in AppSheet, but the formatting is a little tricky. Luckily, several other community members have posted some great tips that I used in the creation of this sample app. See credits at the end of this post for more background on using SVGs. I found a free resource for generating SVG app icons, with adjustable size, color and stroke. https://tablericons.com/ [2020-07-21 19.34.07] When you click an icon, the SVG code is copied to the clipboard and is ready to pa…
Please see
1 Like
Try:
left(
concatenate(
left(
"★★★★★",
floor([yournumber])
),
"☆☆☆☆☆"
),
5
)
4 Likes
Brilliant! I knew there had to be a better solution but couldn’t think of it. The double use of left() is something that I couldn’t imagine but will try to remember. The left at the top just fills the spots that are "left"over from the second left. Now, if only there were a half star!
2 Likes
opps… try this>>
hoping with this, i can get a better solution on how to appear this stars in the app. thanks.
I see. You’ve combined images. Personally, I think @Steve’s solution is the best one for you, but it doesn’t have the half stars.
If you want a graphic solution, the SVG solution might be good. Or, you could make 11-images, one for each point on your scale (0.0, 0.5., 1.0, 1.5 etc) and use an expression to invoke the proper image based on the value.
1 Like
Another option is based on the tip and trick mentioned below and given by @Rene_Casana_Amaya
[Automatic star rating based on likes and dislikes](https://community.appsheet.com/t/automatic-star-rating-based-on-likes-and-dislikes/24947) Tips & Tricks ?
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 t…
The AppSheet icon set has half star icons. So that may be used. However to show combination of empty, half and full stars, the workaround does require around 13 format rules. So this option will also take a bit longer to set up The test app’s screen with with those many format rules shown below.
1 Like
Wow! Thanks! Do you have a sample app? The original sample app seems to have been taken down.
Hi @Kirk_Masden,
Thank you. As you can see in the screen, I had added that star rating configuration to the sample app “Order Capture”. It basically revolves around just two columns and a bunch of similar but numerous format rules, each one for a rating.
I will be glad to share the details of all the format rules and other configuration. I plan to add that as an addendum post in that tips and tricks post thread by @Rene_Casana_Amaya referred above. That I believe will be a proper thread since it expands on idea in the thread.
Hope that will suffice. I will be glad to put together a sample app just in case required.
2 Likes
Great! I’ll follow the thread!
Hi all, I Don’t know why my app just show 1 star only, [D/A size 1-5] type Decima (display name how important It is), I created 5 format rule 1 star to 5 star
Hi @Phong_Lam
I dont believe you can do that using formatting. You could use an enum with star icons copy pasted in.
2 Likes
Hi @Lynn, How can I made It have colors ? I don’t know where I can find the icons to copy so I take the stars above from @Steve , thanks
1 Like
Hi @Phong_Lam
I didnt read back through the thread, I dont know how you colour those ones.