My end-user is trying to achieve this effect.
(1) The default filter has already sorted the database by Sub-Category (asc). Result is shown below. However if you notice, there are 170 rows viewable - which means 170 entries exist. Now within those 170 entries, lie some entries which pertain to teacher documentation....
(2) ... so, my novice user types the word "teacher" in the quick search like so (below), and expects that the list will further refine by showing only all entries that contain the text "teachers" in any field, with the rows being sorted by Sub-Category (which is the first column)...
(3) ...however, the result is that the default filter shuts off, and the Quick Search mode takes over, so that the result now shows:
Notice that the result is no longer sorted by Sub-Category as the Quick Search has been implemented.
My question is this: is there a way for Dataform to behave so that the initial filter can be further refined (cut down) based on a subsequent and immediate-following search? That would make Dataform behaviour according to the natural tendency of the novice user to list the entries based on further-refinement by a subsequent search (also known as on the fly divide-and-conquer)?
I know that there is the option of using the "Advanced Filter" (you can see that I activated the pattern by looking at the screenshots above) which will do the job, but we're talking about middle-aged and novice end-users here who will struggle (some will give up) to fill in the Advanced Filter form. See below.
Even if I were to make it 'easier' for them by providing videos or step-by-step guides, many of them 'can't hack it' if the form is too 'complicated' for them.