This requires deep knowledge over the several funcitons and features of Appsheet.
Yes, not easy, but tough.
But to see is to believe.
This is sample app where I demonstrate the custom feature for searching and filtering table view. The filter conditions are retained per app users.
As you asked, i placed the reset function as well.
It should take time to understand how it structured and works , but clues are inside here.