Suggestions for Zoho Creator

Suggestions for Zoho Creator

Hi,

I have been using Zoho Creator for about a week now. It seems like a promising tool but I have come across a few blocks that were quite frustrating especially since it seems that they could have easily been added to the current feature set of Zoho Creator. Maybe these features are available but I have not been able to find them or at least not in a directly convenient way. If not, then I would like to list them here as possible feature requests which I think would give ZC a big umph.

1 - More Flexibility with Query Parameters for Forms & Reports

Forms use query parameters for auto-filling fields and reports uses them for filtering but that's as far as it goes. There are many more uses for query parameters but although the potential is there, we are limited by only these two types of query params for Forms and Reports.

For example if I could pass a custom query parameter to a form I may be able to hide/show fields or auto-populate fields differently based on the value of that parameter but the Deluge script does not accept any query parameter variables other than the fields in the form. This limits if we want to add our own stateless query parameters like "hideField1" for example which we can then refer to in our onLoad scripts.

For reports filtering on query parameters seems to work only on fields that are in the "Configure Fields for Web". So unfortunately if I need to filter on the ID of the lookup field (which is meaningless number to the user) I need to have that ID field displayed so I can use the parameter to filter on it even though the lookup itself is in the form but I need to make sure it is part of the "Configure Fields for web".

2 - Deluge Script for Reports

Basically I would like to pass a custom query parameter to a report and then run some script on the onLoad of the report to show/hide columns dynamically, or to run some script to do more complex filtering & sorting. For example we currently cannot do any filtering if the filter criteria is from a table that is related two or more levels away from the report.

3 - Adding buttons to HTML snippets

I haven;t investigated this one fully but it looks like if I have an HTML snippet on a page, I would like that snippet to also have some "action" on it but there is no direct/easy way to connect the snippets to the Deluge actions. I saw a pre-built app that takes a very round about way by openUrl to add a parameter which then is used in another snippet to do something else. Would be great if we could simply add a button like in ZML with the action that we require.