I am trying to create a filter that will allow me to filter the data and show all matches regardless of whether or not the first field is selected. Currently, when my first field (Sessions) is not selected the formula will not filter the data say when a day of the week is selected (my second column). It will still show all results. How can I change my expression to filter the data regardless of what fields are selected?
It looks like youâre doing what you should be doing for this with the OR( ISBLANK()...)
I would suspect that maybe the CONTAINS() isnât what you should be using. Can you provide more info?
Is the table name really âEdscapeâŚâ, or is that an extra âdâ in there?
Check out my sample app here for something very similar:
[Sample App: Multiple (and optional) dependent dropdown filters](https://community.appsheet.com/t/sample-app-multiple-and-optional-dependent-dropdown-filters/23653) Tips & Tricks ?
I created a sample app to demonstrate setting up multiple search filters to narrow down the possibilities in a final Ref-type column. âMulti Filter Exampleâ here: https://www.appsheet.com/portfolio/546920 This app does NOT utilize Appsheetâs implicit dependent dropdown feature, as described in the following post. The reason for this is to allow the user the option to filter by any, or all, or none, of the 4 filters, independently. Whereas the implicit dependent dropdown will auto-hide the âŚ
2 Likes