Averaging numbers for star rating system

[jtruitt]

I would like to add a star rating system for reviews as part of a dining guide I'm building. Is there a way to calculate the average rating based on all those given for a particular business?

[bahar_vm]

Hello,

This would require a calculation from the backend database so on submit of a new review, a trigger runs and calculate the average and update the table. I would suggest you going through Caspio Professional Services department by submitting your request to http://www.caspio.com/services/services.asp and have a consultation with a Caspio technical advisor.

Best,

Bahar M.

[Nuschool]

Hi,

This can also be accomplished for free or a small-monthly fee using a service like http://www.rating-system.com

They provide you with a snippet of code that you could place in the details page (or other) of your application.

You will need to have unique IDs for your database.

You will have to edit this part of the provided code:

var r_itemid = encodeURIComponent(window.location.href);

Change to url where the rating will be displayed and then give it a unique ID.

"http://www.yourwebsite.com/pagename?id=[@field:ApplicationID]"

(must include quotes "")

I think it would be great if Caspio would begin to include some of these features as part of their basic services as the cost to have this custom developed would be very pricey and unrealistic for many users.

Hope this helps and let me know if you have any further questions.

[NailDyanC]

Just to add and update this post, may this help as well. In Caspio Release 25, you may now use unicodes. Caspio now supports Unicode symbols so you can display emoji characters and other symbols directly in your apps. They can be used in Tables, Views, DataPages, Email/SMS Notifications, Localizations, Formulas, Triggered Actions and Application Tasks. The supported symbols are listed at https://unicode.org/emoji/charts/full-emoji-list.html.

[NailDyanC]

Hi, just to add some information about creating rating system, Caspio has now an app extension that showcase this feature, you may check it here: https://www.caspio.com/services/app-extensions/?cat=ui_controls