When I go to the detailed card for a specific movie, I want to see reviews for that movie only. If I open another movie, it should show reviews for that movie. My movies are from an external collection, TMDB. In my case, this list only displays all existing reviews, which is not what I need. The same thing applies to the “comments” list for a specific review. It either displays all of them or none. It doesn’t understand which review a comment is about.
I also can’t set up the “like” icon so I can like or remove a like from a review or comment for a specific user. I really need help! I would be very grateful to you! Perhaps I’m doing something wrong with the collections and the relationships between them.
You need to have a relationship between the collections. Check this video out recorded by @pauladams as an example. : https://youtu.be/yoW7rwGQkHU?si=eX__zAc9NNqY86Aa
Would you be able to include some screenshots or a screen recording about your setup?
Thank you and have a great day!
I watched the video and managed to set up links between collections, but there’s one thing I still can’t get right:
-
I can’t implement the “remove like” feature for a review. I want the heart to turn yellow when clicked, indicating a like (I did this), and when clicked again, the heart turns gray, indicating the like is removed. But if I select “remove,” there’s no option to select the “likes” collection.
-
And yet, the biggest problem is how can I link reviews to a specific movie? For example, if I go to the “Avatar” movie card, there are reviews for that movie, and then I go to the “Barbie” movie card, there are reviews for that movie. How can I do this? I can’t seem to get it working…
If it’s a many to many relationship, connecting that property into the toggle would be enough and no need for additional actions. (read more : Toggles | Adalo Resources) But it looks like you’re using a joint table/collection to store the likes and toggle is not suitable in here. @Victor already covered this! : https://www.youtube.com/watch?v=_jPUMDLVwoA
Have you created a relationship between the reviews and movies collections? It would be as one movie can have many reviews but a review can only have an one movie.
Thank you and have a great day!
1 Like
Regarding reviews: the problem is that, as I understand it, it’s not possible to set up a relationship between an external collection and an internal one.
Here’s my functionality: I type a movie into the search bar, and the results appear below in the list (this is an external TMDB movie collection linked via API). When I click on a specific movie in the list, I’m taken to its detailed card, and below that, I see a list of user reviews for that movie (this is my internal “Reviews” collection). But all the reviews are listed there, not the specific ones I need. Is there a way to link this somehow? So that the right reviews appear under the right movie? Since the collections are different, is there a solution?
In that case, this would be the solution which storing the TMDB movie_id as a foreign key in the reviews collection. : https://drive.google.com/file/d/15uvC2GamLmnRfTofRnTzwJnC8WLtooEQ/view?usp=sharing
Thank you and have a great day!
Wow, now I’ll know I can use Movie ID! Thank you so much! I learn something new every time, thanks for helping each of us!
1 Like