Filtering a list based on a relationship?

I’m entirely perplexed by this, so much so that I feel like I must be missing something that’s right in front of my face. The video explains but I’m expecting to be able to filter a list based on a value within a collection and it seems I cannot do this.

Hi @tanner ,

You need to use category as collection for horizontal list, and the action would be to change input value or update logged in user>tmp relationship field.

Then you can use another list which is course collection that is filtered by input value or that relationship field, depending which one you like.

I’m sorry but this doesn’t make sense to me. I’ve selected “Course Category” as the value for “What is this a list of?” but then you say “the action would be to change the input value or update logged in user>tmp relationship field.”

Do you mean the link action? And I don’t know what you mean by “update logged in user>tmp relationship field”

I am very lost and am feeling very dumb.

Hi Tanner @tanner,

May be these topics could help:

Best regards, Victor.

This is helpful @victor, but when I follow the instructions, the data from Course Category doesn’t appear in the chip list. It’s just blank. As if there’s no value in the field I’ve chosen to use as text.

Hi @tanner,

Then you’re doing something wrong :slight_smile:

Just try to add the horizontal “chip” list, make it a list of categories. In your app you should see 2 entries there - Audio and Video (according to your DB).

Then the easiest way to proceed will be adding an auxiliary property to Users collection, call it “selected category”. On a chip list you add an action “Update Logged-in User → Selected Category” with Category Name. As a result you will get a value of “Video” when you click on “Video” category, and “Audio” - when on “Audio”,

And then in your main courses list, you add a filter that Course → Category → Name is equal to Logged-in User → selected category.


1 Like

You’re right, I was doing something wrong. I have it sorted now. Thank you for your help. My only database experience is with SQL and so I’m used to writing queries with a certain flexibility to them, I guess I was having a hard time grasping how to do the same thing with Adalo.

This has also helped me to understand the bad reviews Adalo gets when compared to some other options. It’s not that those other options are better, it’s that Adalo is more powerful and thus a bit more difficult to learn. If I had zero database experience, I could see how this would be very frustrating… but I think that more suggests that Adalo is the best!

Anyway, thanks!

1 Like