The star rating component is quite confusing and the Adalo documentation does not help much.
I want to create a system where everyone can rate everyone else on multiple categories.
Do I need to create a separate rating collection in relation to users (multiple to multiple)? And then add each category as a property to the ratings collection?
I just added the categories into the user collection but it doesn’t seem right. Seems like each user can only be rated once. And I do not know how to show the average star rating because the only option is average of all users.
In order to connect users in multiple categories, you need to create a category collection that contains all the categories you want & a relationship many to many with the user’s collection.
Yes, once the user clicks on the review button, a modal or screen should appear with a text input field and a star rating component, but when the user clicked on the review button before the modal or screen, you must create a review collection record so the star rating screen will have the current review flow.
As you mentioned, a user can review another user across multiple categories.
I hope this will help, if not let me know I’ll share a screen recording for you.
Yes. Are you able to record a screen recording of at least the DB setup part. I am very confused here on the DB setup (what properties go where and the relationships). I think it would be more clear to see a recording of the DB setup.
I also don’t understand why category to users is many to many. Shouldn’t it be the reviews fall into 5 categories? I am trying to create an app where every user can review other users based on 5 different categories. Each person can rate another person and comment once per category. So I can rate you and comment on you five times, once per each category.
Everything you posted before was absolutely working but i had a problem here. I am unable to get the average score of the reviews by category. And unable to get the count of reviews by category.
I’ve created a list of All categories on each user profile. I want to include the average rating for the category. And the count of reviews for the category. But none of the options are working. The values produced are always 0.
I think the problem is there is no option for me to go “Current User > Current Category > etc etc”
Many of my list screens are showing everything instead of just specific to the current user + current category.
Do I need to somehow add the categories to the users? There seems to be no way except manually doing it in the database.