Related FAQs

1. I created some new fields and renamed others. I see the changes in the form but not in the data (view). What should I do?

If you rename the field it will reflect only in the form and not in the view.

To reflect the changes in the view, please follow the steps given below:

1. Select the View from the Views Tab in Edit mode.
2. Select the particular view from the View tab.
3. Click on Column Properties.
4. Rename the Display name for the field.
5. Click Done to save the changes.

2. Can I sort a picklist field?

To sort a picklist alphabetically,

1. Place the picklist field on the form.
2. In the "Adding " dialogue box click on Options.
3. Select the check-box Show choices in alphabetical order.
4. Click Done to update the changes.

3. How many lines/characters can I use in a multi-line text field?

Zoho Creator allows only 65,535 bytes (~64kb) of data in the multi-line text field.

4. How can I change the date format for my date field?

You can change the date format from the Application Settings dialog.

5. How can I insert line breaks in field values?

Use the HTML tag to insert line breaks in field values. For Multiline text fields, \n can be used in addition to html tags. The Allow HTML Tags (option available in More Actions -> Application Settings dialog) must be set to Yes, to execute the HTML tags.

6. How can I import data from a field in one form to another form?

Use the LookUp field type, to import data from a field in one form to another form. Refer FAQ -> Forms -> Create relationship between Forms, for more information.

7. Can I restrict the entries that will be displayed in the lookup field, based on a given criteria?

You can use the Set Criteria option in lookup fields to restrict the entries that will be displayed in the lookup field, based on a given criteria

8. I have added a Formula field type in my form. But when I access my form in live mode, the formula field is not displayed. Why?

The formula field will not be displayed in your form. As the value of the formula field is automatically calculated, it will be displayed only in the view.

9. Can I use a formula field in another formula field?

No, you cannot use a formula field in another formula field. Refer the topic, Deluge Reference - formula, for more information.

10. I am using decimal fields in my formula. Is it possible to have the result of the formula, limited to 2 decimal places?

You can use the Deluge round() function to round the result of your formula expression to two decimal places. The syntax is given below:

().round(Integer) Example: (Decimal_field + Number_field).round(2)

11. Is there a way to find out how much File upload space I am taking and how big the files can I upload?

The Storage Space is concerned only with the total size of all the Uploaded files. The maximum size of an Uploaded file cannot exceed 5 MB. Currently, Zoho Creator does not provide an option to show how much of file upload space you have used up or how much is left. We will be providing this option soon in our future updates. For now, you will be notified as soon as you get close to your maximum storage space limit, based on your subscription plan. To view your Subscription plan, select the Account Settings option displayed on the top-right corner of your Home page.