Filter by multiple fields?

I'm trying to filter records by both a Dropdown (Category) and a text search of Product Name.

Is it possible to filter by 2 criteria but only if both search fields are not blank? Or, filter by the field that has search criteria entered.

e.g. when the category filter is showing Adapters, and in the Product Name field, I type VGA I'd like to show all products with VGA in the Product Name that are in the Category Adapters.

I wanted to implement a feature just like this and I found a solution (just read the answer):
https://community.retool.com/t/how-do-i-dynamically-filter-by-multiple-dropdown-boxs-will-this-work/9810

I hope you'll get the answers that you need from there, otherwise, do not hesitate to ask for help!

Hi there @MichaelPierce :wave:

Were you able to get the solution @Mendy presented a try?

Best

Pawan