Hi. Does anyone know how to search within the search bar for one value and than sub search from those values with anonter value? like a filter and than export that data.
Thanks
Shakeel
You can’t do that in the integrated search bar. Here are a couple examples of how to do multiple field filtering.
[Ad hoc filtering/slicing?](https://community.appsheet.com/t/ad-hoc-filtering-slicing/19185) Questions
Is there a way for a user to create a quick ad hoc filter of a view? For example, say a view contains a long list of addresses. One user might want to see only addresses in Texas. Another user might (at about the same time) like to filter by zip code. Can this be done? Or do I have to anticipate every possible find users might want to do and create slices for all of them? Just to say that out loud reveals how crazy that would be so I feel sure I’m missing something. But I’ve looked and can’t fin…
[Row Filter Condition Combinations For User Filters](https://community.appsheet.com/t/row-filter-condition-combinations-for-user-filters/27730/12) Questions
That’s the second expression that Steve provided which works better than the one in my gif but still requires all fields to be filled in before seeing data. AND( IN([Client], Filter[Client]), IN([Stage], Filter[Stage]), IN([Communication Cycle], Filter[Communication Cycle]), OR( ISBLANK(Filter[Days Since Last Communication]), (ANY(Filter[Days Since Last Communication]) <= [Days Since Last Communication]) ) )
1 Like