Creator Help

Known Issues or Limitations

Limit on number of Dropdowns/RadioButtons/Checkboxes in View

You can have only 30 Dropdowns/RadioButtons/Checkbox fields put together, in a single view. Exceeding this limit, will not display the data in the view. Also, the count of complex fields (such as Look Up/Dropdowns/RadioButtons/Check box) should not exceed 30. The number of such fields will be counted as following

Each Look Up/Dropdowns/RadioButtons/Check box in Base Form as ONE field.
Each normal Related Fields in Another Form as ONE Field.
Each complex Related Field (Look Up/Dropdowns/RadioButtons/Check box) in Another Form as TWO Fields.

Removing fields/columns from View Definition

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

Grid View

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

Limit on maximum number of Fields in a Form

Maximum number of fields in a form depends upon the type of fields used and the maximum length of the field. Below are the field types wise limitations.
Single Line / Email Field:
Form can have maximum of 80 text fields with max length of 255(SingleLine and Email). This can be increased by reducing the max length value.
List Fields (Dropdown/Checkbox/Radio/Multiselect):
If a form contains more than 60 list fields (Dropdown/Checkbox/Radio/Multiselect), we will not be able to fetch the form. This will affect the form access mode and lead to backup failure. Hence we would 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 splitting the form into smaller ones.

PDF Generation

Currently ZOHO Creator supports PDF rendering for List views and HTML views only. In List views, it is limited to to generate PDF without any UI change (Grouping, Summation of numeric columns).

HTML view to PDF

<div> based embedding of Forms/Views and authenticated content like images/css that requires current credential will not be supported. In case of Iframes, the Iframe needs to be public.

Displaying custom action in a summary

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

Reports Limitation

Multi-Select/Checkbox and SubForm fields are not supported in reports. Even if it enabled in underlying view it will not be available in Reports Builder to use them.

Downloading application backup

The backup will not contain the files that were uploaded using the File upload field.

Creating Combined Views with Multi Select Lookup field

When you use a Multi select Lookup field for your Form, the corresponding view will not support displaying relational data for the selected field values.

Criteria Limitation

Criteria containing Multi Select field does not works fine.

Shared information not available 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

Accessing DropDown/MultiSelect/CheckBoxes/RadioButtons/Lookup like (input/[COL]).lookup.(DropDown/MultiSelect/CheckBoxes/RadioButtons/Lookup) does not work properly.

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 if and only if the dependent field values are changed by user action. 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 view.

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 are handling 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 below table 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 on 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 data in a subform

  • In a subform, searching for a data can be done only in the first field of the subform data in the view column. The display order can be changed to search in a different field.
  • Searching a subform field, which has a lookup field with advanced display options is not supported.

Top