Multiple Filters? Question answered many times, but never satisfactorily

Multiple Filters? Question answered many times, but never satisfactorily

Hi. I love Zoho Creator.
 
However, I would like to know more about creating a view that allows users to easily filter the records, using several filters at once.
 
I know many people have asked this before, and mostly the answer given is "Use the search function, and search in each column for the required parameter"
 
However, this is not a satisfactory solution for a number of reasons:
 
1) You have to know the exact value to search for (sometimes the value might be a two or three word answer)
2) It takes a long time to filter by a dozen columns, having to type into each one
3) Using the search as a method for filtering by multiple fields means you have to include all the columns you wish to use as filters. This is no problem for small applications, but for larger applications, it means including dozens of columns making the application overly complicated to view and use.
 
Could someone give me a definitive answer than there is no way of creating an application that allows several filters (including filters on fields that are hidden).
 
If there is no option using the standard GUI, is it possible to create an HTML view which uses deluge script to create a filter interface that does what I am looking for? If so has anyone got an example of how you would add dropdowns and checkboxes via HTML and link this up with deluge script to perform filter actions on the currently viewed records.
 
If even this is not possible, are there any plans to add such functionality?
 
A huge thanks in advance for taking the time to reply.
 
Tom
    • Sticky Posts

    • Share your success story

      We would like to hear from our passionate users how much Zoho Creator has changed the way you work and benefited you. If you would like to share your story to us and be featured as a proud user of Zoho Creator, then this is for you. Fill up the form below and if you want to be included in a case study, we will get in touch with you to get further details. So what are you waiting for? Tell us your story. Charles
    • Merge and Store v1 API depreciation

      Hi Zoho Writer users, The Merge and Store v1 API allows you to store the merged document in Zoho WorkDrive. The response of this API will be returned with the document's ID only after the merge is complete. In Deluge, the maximum timeout for operation
    • Zoho Creator Developer's Conference 2017 !!!

      We welcome all our Creator Developers! You're invited to join us for our annual Zoholics Developers conference August 29th–31st! This is your chance to get training and guidance on Zoho Creator from our most knowledgeable custom app builders.       Zoholics Developers is a three-day event where you'll participate in interactive workshops to hone your app-building skills, get questions answered by Creator experts with personal one-on-one sessions, and connect with other Creator developers from around