User Specific Ratings & Ratings RollUp

Ask for Help
1

Hi Glide Community!

Just found out about Glide a few weeks ago and I’m looking forward to building with it!

My first test is to build a baby name app for my wife and I to use. The idea is to collect all names, allow each person to give their own rating to the name, favorite the names, etc.

I’m having trouble with the rating component. My goal is to have 3 ratings fields:

  • My rating
  • My wife’s rating
  • The average rating between the our two scores

image
image804×1414 97.1 KB

(apologies to all of the Anderson’s out there…)

I added the “Rating” field, but as this is a user-specific field, it doesn’t seem like there is a way to:

  1. Display the rating of another user on my view (ie here’s what you rated this name, and here’s what your wife rated the name)
  2. Create a formula field that would average the two together.
    image
    image588×768 39.6 KB

So please correct me if I’m wrong, but there’s no way to do this using the ‘Rating’ field type, right?

So then I thought about building a separate table of Ratings, holding the name (in a relation field), the rating, and the user who added the rating. Something like this should solve all my problems, right?

image
image1246×368 43 KB

image
image1252×1244 95.5 KB

But that doesn’t seem to work as on the record details view, there doesn’t seem to be a way to:

  1. Display the individual ratings without adding a related table (ugly - I’d prefer this all to be on the main detail view)
  2. Add/edit your own rating
    image
    image2828×1330 235 KB

I hope I’m not overcomplicating things here. Does anyone have any ideas on how to solve this?

Ideal end-solution:

  1. Individualized ratings by users (displayed and editable on name detail view)
  2. Separate field that displays the average between all of the ratings for that name, also visible (non editable) on the name detail view.

Thanks for any guidance and help!

1 Like
2

First of all, congratulations on this happy event !

:tada:

1 Like
3

Thanks! Excited it gave me a reason to play around with Glide! :slight_smile:

4

Also thinking simplifying it a bit, to take away the rating component and moving to a binary like/dislike style of rating. A “tinder-like” feature where we could each see the cards, swipe right to like, swipe left to dislike/remove, then have a separate tab that would show:

  1. Individual likes (my favorite names)
  2. Matches (both individuals liked this name)

I was thinking this would be a binary user-specific field (for #1 above), but I’m not sure how I could find matches for #2 when we both like something.

Any ideas here?

5
2 Likes
6

This works well for a big part of it, thank you! Admittedly it’s a bit clunky having to go around the rating component, and also having to use the button to launch the form vs adding your rating right on the detail page, but until Glide makes changes, this will solve one of my issues, thank you!