Yes, you can now filter using built-in āin-appā filters on several columns for the same collection or list, it was a great news when they released this update as it was highly requested! 
It works as an AND operator for all the filters where you select at least 1 value, and does not filter the columns where you select all or none of the values in the filter.
The built-in āin-appā filters are excelent.
The caveat here is just the translation, that is not fixed yet, as we indicated in another post:
great job @gvalero, but how did you show the number of filtered items on screen āpeersonnel Foundā ā¦ i wish you can advise me .
If you can create a query that represents how you are filtering items on the screen, you can use a rollup on top of that to count the number of items that match the query.
You can then also use that query to display the filtered items on the screen.
Thanksā¦ Creating the query is actually the hardest part for me, and unfortunately, Iām not able to get it right. Itās not as straightforward as something like COUNTA in an Excel sheet. Iād really appreciate some guidance or examples if possible.
Have you reviewed the videos and examples in the docs?
They are pretty good.
Yes, the one uploaded by @ gvaleroā¦but itās not a tutorial, it was just 3 minute overview only. I would be much appreciated if someone make more detailed video to show exactly how to display count number of filtered data
There are two videos in the Glide Docs that I linked to - have you looked at those?
There are also example use cases in the docs with step by step instructions.
Hola @sc0o0py .. sorry for my delay to reply.
My demo app is very old (classic) and this method was an alternative way to filter data avoiding creating manual filters. In those days, the Query column didnāt exist, but now it may be an easier solution to achieve what I wanted to do in most cases.
But coming back to your question to get the number of filtered items created by the relation, what you do is create a Rollup column based on that relation and count the items found. Itās something very easy as you can see.
If you are going to use newer Glide APPs with the Query column, your Rollup column must now point to your Query column instead the Relation column.
I hope it helps.
Saludos!
Thank you so much for your help @gvaleroāit worked perfectly and solved my issue! I really appreciate you taking the time to guide me through it
