Trouble with "joins"

shiftyclyde · 2024-12-15T05:59:17.868Z

Hey Everyone - Only been working in bubble for the last month or two and could use some help. So I’ve got a table called movies which is in a repeating group. Users can mouse over it and rate each movie, and I’d like to store that in a separate table called ratings. I’m getting stuck because I’m getting caught between type show and type ratings. I started off by having the rating input create a new thing in ratings that saves the show, the rating (and the user who created it by default). But the user could also update their rating in which case it would be a changes to a thing, so dont know how to write that conditional so it does a change to a thing if it finds a value for that show for that user in the ratings table. And furthermore, I would like to show the rating and am trying to sort out how to pull the rating for that show for that user from the ratings table and create a conditional rule around it… Any advice would be super helpful. I’m including snips of the tables…

image700×425 14.9 KB

image1104×707 53.9 KB

boston85719 · 2024-12-15T06:28:45.300Z

Rating needs field for movie and field for user, which can be built in field of creator.

Search ratings with constraints creator is current user and movie is current cells movie

shiftyclyde · 2024-12-16T06:18:36.521Z

hey boston - are you suggesting I create a user field in ratings in addition to creator? And in order to search ratings, doesnt this have to be a type ratings? and if its a type ratings, I dont know how it pulls the show info. Thats’s where I’m getting spun around.

boston85719 · 2024-12-16T07:08:46.551Z

shiftyclyde:

are you suggesting I create a user field in ratings in addition to creator

For this use case, no, that is not necessary as the ratings will only ever be created by a logged in user.

shiftyclyde:

And in order to search ratings, doesnt this have to be a type ratings?

boston85719:

Rating needs field for movie and field for user, which can be built in field of creator.

Search ratings with constraints creator is current user and movie is current cells movie

This being rating? Yes, it would need to be of the data type rating.

shiftyclyde:

I dont know how it pulls the show info.

boston85719:

Rating needs field for movie and field for user

Use the related field of movie

shiftyclyde · 2024-12-16T09:02:03.000Z

gotcha! So i put the icons in another container and set that container to type ratings, leaving its parent as movie. I guess i didnt think I could do that for some reason. And then did this and its all working swell. Thanks for the brain bump Matt! You da man.

image.png778×469 21.3 KB