I haven't used Zoho in a while and I can't remember the best way to do the following.  I know how I could do it using an HTML view, but I don't want to because of the built-in functionality of the Zoho View's.

 

I need to filter the records in a view based on criteria selected by the user in a form.

 

I have a table of three different size criteria of an item in the "Item" table. Let's say, width, length and height.

 

I want a user to be able to enter specific criteria in a stateless form "Search" for width, length and height, and for a view to display the results based on something like this formula

 

(Item.width - Search.width <= 3) && (Item.length - Search.length <= 3) && (Item.height - Search.height <= 3)

 

Just meaning that the item needs to be larger, but within 3, in all catagories to be displayed.

 

The question is where do I even start building a formula?  I can't pass the search variables to be used in a view's criteria, or am I forgetting something obvious.

 

My first instinct was use deluge script on submit of the Search form to fetch the records with the given criteria, but how do I display that list with a Zoho View and not an HTML one?

 

Second instinct was to use a filter in the view, but I don't believe I can pass a variable to be used in the filter, can I?