Users who uploaded video to some category - how to get them?

Get Help
1

Hey guys,
I’m building social media app. My database looks like:

  • USERS
  • SPOT
  • VIDEO

USER can upload VIDEO on any SPOT. I need to display list of USERS who uploaded VIDEO on the same SPOT. How to make it work?

I can only display list of SPOTS and set filter to ALL SPOTS.

Please help me.

2

Anyone can help me? Still didn’t figure it out.

3
  1. Create a many to many relationship between users and spots. Because a user can upload to many spots and each spot has many users uploading the videos.
  2. Create a one to many relationship between spot and videos. A spot can have many videos, but each video belongs to only one spot.

Now when you filter by a spot, you’ll only see list of videos in that spot, uploaded by all the users.

4

Thank you.
I realized that I need to display ranking of videos on spot. Is it the same way? How should I sort these videos by sum of vote up and vote down?

ᐧ

5

Yup, count the number of votes and sort is accordingly

6

Thanks. Also, why when I duplicate screen some buttons change places in preview? How to fix that?

niedz., 15 sie 2021, 13:13 użytkownik Bhanu Vadlakonda via Adalo <adalo@discoursemail.com> napisał:

7

My suggestion would be not to duplicate the screens, I don’t have a right answer to this issue.

8

Is that a bug?

ᐧ

9

I’d say, it’s more a limitation than a bug. Copied components do have some alignment issues.

10

I’ve tried to replicate that and after click on buttons they change positions.

ᐧ

11

Hey man,
I’d love to ask one question. I’ve got up/down vote system. User who votes is adding to column “upvode” or “downvote”. I’ve created separate column “Score” in Videos collection to be able to sort my list of videos by Score - from high to low.

When I vote UP the nickname goes to “Upvote” column but if video is voted down and user votes up, it should be score +1 but I can only make 0 because I’m able to add or delete 1 when user clicks in “Score” table. How to make it work?

ᐧ

12

Hey @Dawid

Apologies, I don’t really understand your request, can you please rephrase it?

Maybe in a new post so that it wouldn’t confuse other forum members please?

Thanks!

13

I’ve moved that,
https://forum.adalo.com/t/reddit-like-voting-system-and-sorting-list-by-score/16061

Please check.

ᐧ

14

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.