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