Multiple Custom Filters

[dilon_perera]

@paige.scholes

I got help from an Adalo expert who advised that using a search index and last filter would be best.

@paige.scholes

The search index is suppose to be used to filter with any of the options, for example the logged-in user could fill out every dropdown or just 3 different ones and still end up with a result of users that contain the chosen filters because they are combined in their individual search index. Once the logged-in user clicks “apply” after choosing filters, it creates the last filter. The results list then filters by every user’s search index according to the last filter, so if a user has one of the chosen filters in their search index they would show up in the list, but this isn’t working well because I need users that contain all the chosen filters.

The options are stored in the the search index property for each user and when the user clicks the button the chooses options from drop-downs are saved right?
I think you don’t need a property called last filter because you don’t need to save the results from drop downs and you can use the drop downs values in any screens to filter!
You can remove that last filter,filter and add the other filters as OR and try again ( you can use AND too to see the results that you get ).

Made a video to see if I’m correct : Loom | Free Screen & Video Recording Software | Loom

In here if you want to get all users that matches for selected filters you can use OR.