I have been trying to build an app for my business. While Appsheet addresses most of the requirements that are expected in todays, I dont seem to be finding a way to add Advanced / Dynamic filter that would filter the current view to show the records based on user inputs and would stay in that state until the user clears the filter so that user could further filter the records from that state on. And this I feel is the most basic feature that any app would need irrespective of the category. I found a few samples that did address my requirements of this dynamic filter but with limitations -
While the apps aforementioned do the filtering, there are a lot of limitations I found
The filter is temporary . I would be expected to do the filter all over again if I want to further filter the records from that state.
The filter form should be dynamic and should be the part of navigation menu like a burger menu besides the search icon and can slide from right or an action sheet and should load the form dynamically based on the current view. For instance I might have 2 views - Customers and Items. When clicked the advanced filter button when in a specific view, say Customer, it should load the form with fields relevant to that particular view, fields relating to customer in this view.
This I feel is not anything advanced but a very basic feature I believe. I could see content related to LinktofilteredView() , security filters but nothing clearly seems to address this requirement.
Am I missing out on something ?