How to get a number of reviews and average ratings of products

lawgpt.team · 2024-07-10T11:54:55.365Z

Hello everyone,

I am new to bubble

I would like to show the number of reviews and average ratings for each product like dashboard. Could anyone let me know how to implement this?

My tables are as below…

Simply there are 3 tables - Products, Reviews and Ratings

Products table

name
created date

Reviews table

content
creator
product (points to Product)
created date

Ratings table

number
creator
product (points to Product)
created date

boston85719 · 2024-07-10T12:42:45.225Z

Ratings table is unnecessary.

Do a search for Reviews constrain by the Product field then you will have all reviews for the Product.

Add to the Reviews table a field for Rating that is of type number.

Then when you want to show the total number of reviews just use the :count operator after your search for Reviews. And when want to show the average rating reference the search for reviews each items Rating then the :average operator.

lawgpt.team · 2024-07-10T14:58:41.340Z

I appreciate for your solution!! it’s exactly what I wanted! And you are right - no need for Ratings table Thank you again!

olaidemuheeb · 2024-12-17T08:53:26.088Z

Thank you