Creator Help

Known Issues or Limitations

Limited number of Dropdowns/RadioButtons/Checkboxes in Report

The number of Dropdowns/RadioButtons/Checkbox fields put together, in a single view is limited to 30.The data will not be displayed if you exceed this limit. Also, the count of complex fields (such as Look Up/Dropdowns/RadioButtons/Check box) should not exceed 30. Here is how the number of such fields will be counted:

Each Look Up/Dropdowns/RadioButtons/Check box in Base Form is One field.
Each normal related field in another orm is ONE Field.
Each complex related field (Look Up/Dropdowns/RadioButtons/Check box) in another form is Two fields.

Removing fields/columns from Report Definition

The Report definition allows you to remove maximum of 50 fields at a time.

Grid View

Iif there is a client side Deluge Script configured in the form, Grid view is not supported. (i.e) On edit -> On load script (or) On user input script for any field.

Limited maximum number of Fields in a Form

Maximum number of fields in a form depends on the type of fields used and the maximum length of the field. Below are the limitations related to field types.
Single Line / Email Field:
Form can have maximum of 80 text fields with max length of 255(SingleLine and Email). 
List Fields (Dropdown/Checkbox/Radio/Multiselect):
If a form contains more than 60 list fields (Dropdown/Checkbox/Radio/Multiselect), there will be a problem fetching the form. This will affect the form access mode and lead to backup failure. Hence we recommend splitting the form into several forms with 60 such fields in it.
Multi Line/Rich Text Field:
Number of multi line fields which can be used in a single form will depend on the amount of data added per record. The maximum data size for a multi-line field in a row is about 64kb and the maximum row length is about 8000 bytes. Here, the first 768 bytes of 64kb will be considered for calculating the row length (8000 bytes). Hence, if all the multi line fields length exceeds 768 bytes, then the form can only have 11 multiline text fields.
In this case, we recommend you to split the form into smaller ones.

PDF Generation

Currently ZOHO Creator supports PDF rendering only for List views and HTML pages.  The PDF format of a list view does not support grouping and summation of numeric columns in the view.

HTML view to PDF

Conversion from HTML page to PDF does not support <div> based embedding of Forms/Reports and authenticated content like images/css that requires current credentials.  Iframes can be embedded if it is public.

Displaying custom action in a summary

Zoho creator supports the custom action only in the List and Grid views.

Reports Limitation

Zoho Creator does not support Multi-Select/Checkbox and SubForm fields in reports. Even if it enabled in underlying report it will not be available in Reports Builder for use.

Downloading application backup

Zoho Creator wll not backup the files uploaded using File upload field.

Creating Combined Views with Multi Select Lookup field

If you have a Multi select Lookup field in a Form, the corresponding report will not display related data for the selected field values.

Criteria Limitation

Criteria containing Multi Select field type is not supported.

Unavailability of Shared information in restored copy of the application

When you restore an application from the backed up copy, shared information will not be available. Only the structure of the application and its data will be available.

Deluge Script Limitation

Due to a limitation in Deluge Script, you cannot access DropDown/MultiSelect/CheckBoxes/RadioButtons/Lookup like (input/[COL]).lookup.(DropDown/MultiSelect/CheckBoxes/RadioButtons/Lookup).

Sent Mail Task Limitation

'\n' in the message content of 'plain text mail' will be rendered as newline character.

Formula Field Recalculation

In Live mode, the calculation of formula field will be triggered only if the dependent field values are changed by the user. The change in value of the dependent field by "onUserInput" script will not be considered for recalculating the formula field's value (in live mode add / edit form) but it will be considered while populating / updating the values in the report.

Multi-column layout

Multi-column layouts are not supported if check-box/radio-button fields are added dynamically through scripts.

Limitation with Date-Time handling in Creator

Due to the way we handle Date-Time values entered in a form, a limitation exists when dealing with Date-Time values that fall during the changeover period from PST to PDT and vice versa.

    1. It is not possible to capture Date-Time values that fall between 2 am - 3 am on the start date of Daylight saving period in the Pacific Timezone. This behavior exists irrespective of Application and Account timezone. The table below shows the start and end dates of Daylight saving period in the Pacific Timezone for each year. For eg, it will not be possible to enter the Date-Time values "13-Mar-2011 2:30:00", "11-Mar-2012 2:33:00", "10-Mar-2013 2:40:00" etc., irrespective of the timezone the user is in, since these Date-Time values fall in the changeover period.
    2. Any Date-Time value whose equivalent Pacific Time falls between 1 am - 2 am PDT on the end date of the Daylight Saving period will advance by 1 hour. For eg, the Date-Time "04-Nov-2012 08:30:00 Etc/UTC" will advance to "04-Nov-2012 09:30:00 Etc/UTC", since the equivalent PDT value of "04-Nov-2012 08:30:00 Etc/UTC" is "04-Nov-2012 01:30:00 PDT"
    3. This behavior is universal across Zoho Creator, and occurs when a form is submitted, when an Insert Record Task is executed, when data is imported or updated through API. This also occurs for Date-Time values handled in script.
Year DST Start Date DST End Date
2007 March 11 November 4
2008 March 9 November 2
2009 March 8 November 1
2010 March 14 November 7
2011 March 13 November 6
2012 March 11 November 4
2013 March 10 November 3
2014 March 9 November 2
2015 March 8 November 1
2016 March 13 November 6
2017 March 12 November 5
2018 March 11 November 4
2019 March 10 November 3
2020 March 8 November 1
2021 March 14 November 7
2022 March 13 November 6
2023 March 12 November 5
2024 March 10 November 3
2025 March 9 November 2

Limitation in searching for data in a subform

  • In a subform, you can search for data  only in the first field of the subform in the view column. The display order can be changed to search using a different field.
  • If the subform has a look up field with advanced display options or drop-down fields, search using that subform field is not supported.

Top