I have a list of users where I want to filter it through a collection with a relationship to the users collection (so two collections in a relationship - users and category)
A list of users with a custom filter created by selecting
-current user’s category → All
-contains
-category drop down box from another screen.
All works fine but my problem is if the user doesn’t select a category I expect the list to show all users but right now it seems Adalo wants to list users with “empty” category. How can I make Adalo ignore the filter if its empty or treat it as “show all”.
On the other hand if I am filtering a property in the user collection then empty works as “all” (i.e. it doesn’t filter the list). Is there a way to make selecting empty in a relationship collection behave that way too?
This is a nice workaround. I was also able to do it by creating an input field and having an action update it based on “empty” or not then linking to different screens.
I would like to reopen this topic. I have 7 related collections that I want to filter through which unfortunately means I will have to create 128 conditions.
So in your example you had to select a category and you used two lists with one visible when there is a category selection. What if we had to select 7 different drop downs?
My solution is to have an input field that gets updated depending if there has been a selection or not and then link to a screen depending on the input field number. However with 7 dropdowns I will have to create 128 screens (the combination of every dropdown being selected or not). Does this make sens?
Correct me if I’m wrong. In this example the results will show users with either selection not both right?
So for favorite no code bubble and country england, the result will show users who either have bubble or from england not both (like bubble AND from england)