Inspired by a grumpy client who could only see one item when there should have been 70, I want to see if there is a work around to this issue, while we wait for Glide to fix what is, as one person said, a very bad user experience on the search bar and the filter drop down:
One thought I had was to be able to show a hint to the user that would display at the top of the page if list is filtered by either the filter or the search box. If you could access the state of either of those (which you probably can’t) or could somehow count the number of items that are being displayed against the total number of items, you could use that with the visibility setting to display the hint. Is that sort of thing possible? Any other ides on workarounds. It’s a pretty annoying issue.
The only way you can access this value is building your own “search bar” with a text entry and a user-specific column.
Then, if the user navigates somewhere in your app (except tab clicks), you can take advantage of that to add a set column action to clear the search value, but if they never go anywhere and just close the app then you’re stuck with it.
There was a bug in Classic Apps that if you clicked the red ‘x’ to the right of the search field to clear the search box, it would clear the search box, but the search would still be in effect. You would still see only the items selected by your search term.
Glide recently fixed that, and at the same time modified the search so that if you select a searched item, when you return from the detail screen the search will be cleared and you will see all items again.
That is the behavior I am seeing lately. In fact, the behavior change is so noticeable that one user complained about it recently in this forum. I don’t imagine Glide will be modifying this behavior again; their focus is now on Apps.
So I figured out a workaround in addition to the one suggested by @ThinhDinh which deals with the situation where they don’t close the app. It’s not perfect but it will work for now.
Basically, the search field itself is hidden by default and a button that says “search” appears. Clicking search hides the button and displays the search field. After sometime, the search field is hidden again and the button appears.
Clicking the “search” button tiggers an action that both clears the search value (if any) from the column (essentially clearing the search field) and adds a time stamp to a timestamp column.
A math column calculates how much time has elapsed between “now” and the time in the time stamp column (I.e. how long as it been since the person interacted with the search button). In a duration column I have set the time for how long I want to pass between when a person clicks search and when the process resets (e.g. 30 minutes).
In an ITE column called “hide search field”, I ask:" Is the time since the button was clicked, higher than the duration I’ve set? If so true; otherwise false." Finally, I created a “dummy” search field that is an ITE column that says “if hide search field is true, then blank; otherwise, display the value of this search field.” The value in the dummy column is the source of filter for the search, so when the time elapses and it clears, the list is restored to its full, unfiltered state. At the same time, the search field is hidden and the button is displayed. Clicking the button restarts the timer and the process…