How to build user reviews and ratings in Bubble

Go to the Data tab and click New type. Name it Review and add fields: product (type: Product), reviewer (User), rating (number, 1-5), title (text), body (text), is_approved (yes/no, default yes for auto-publish or no for moderation), is_flagged (yes/no, default no), and flag_reason (text). This gives you everything needed for full reviews with moderation support.

On your product detail page, add a Group for the review form below the product details. Inside, add five star Icon elements in a Row group for the rating (same pattern as a standalone rating system — highlight on hover, set on click using a Custom State called selected_rating). Add an Input for the review title, a Multiline Input for the review body, and a Submit Review button. Add a condition on the form group: only visible when Current User is logged in and has not already reviewed this product.

Go to the Workflow tab. Create: When Button Submit Review is clicked — Only when selected_rating > 0 and Multiline Input's value is not empty. Action 1: Create a new Review with product = Current Page Product, reviewer = Current User, rating = Custom State selected_rating, title = Input Title's value, body = Multiline Input's value, is_approved = yes. Action 2: Reset the form inputs. Optionally, update a cached average_rating field on the Product data type for performance.

Above the review form, add a section showing the average rating: Search for Reviews (product = Current Page Product, is_approved = yes):each item's rating:average formatted to one decimal. Next to it, show the total count. Below, add a Repeating Group with type Review, data source: Search for Reviews (product = Current Page Product, is_approved = yes), sorted by Date created descending. Each cell shows: reviewer name, star icons (filled based on rating), title in bold, body text, and date. Add a Flag button visible to logged-in users.

Add a Flag as inappropriate link or icon in each review cell, visible only when Current User is not the reviewer. The workflow: When Flag is clicked — show a popup asking for the flag reason (Dropdown with options: Spam, Offensive, Irrelevant, Other). On submit: Make changes to the Review — set is_flagged = yes and flag_reason = selected reason. Add a conditional on the flag link: when this Review's is_flagged is yes, change it to Flagged (disabled) so users cannot flag the same review twice.

Create a page called admin-reviews restricted to admin users. Add a Repeating Group showing Reviews where is_flagged = yes, sorted by Date modified descending. Each cell displays the review content, the flag_reason, and two buttons: Approve (sets is_flagged = no, keeps is_approved = yes) and Remove (sets is_approved = no, hiding it from public view). Add a second tab showing all reviews for browsing and search. For apps with high review volume that need automated moderation, consider working with RapidDev for expert Bubble development.