Using Creator for many filtered views

Using Creator for many filtered views

I've used Creator extensively. It has many excellent features but there is one glaring weakness - the inability to display many different filtered views.

For example, I have a database with a state field. There are 50 states. On my web page I need to give the user the option to select a state (either through link or picklist) and display the database filtered by that state.

How can I do that with Zoho Creator today?

There does not seem to be a reasonable solution. I can create a duplicate view filtered for that state and display that view. That's fine for a few filtered views. But it is not practical if you have 50. Furthermore it's a dead end because if I change any element of the view, then I have to manually change each similar view, which is a ridiculous waste of time.

I should be able to set a parameter on the iframe that adds a restriction to the view, such as ?state="CA" so I'm just using one view filtered by that parameter.

Another option would be to use Deluge scripting for the view. But there does not seem to be any way to pass data from the URL calling the view to set a variable that could be used in the script to change how the view is displayed by filter.

Thank you,
Marc Freedman
dallasblue
dallasblue