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
-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?
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?