Set Display Format for Formula Field | Zoho Creator Help

Set display format and field type

Set display format for formula field

You can define how the result of the formula field must be displayed in the report using the Display format in reports property.

NotesNote: The Display format in reports property is available only when the field type of the formula is single line, multi line, number, currency, decimal. Learn More

Steps to set display format

  1. Navigate to the Edit mode of your app. Open the form builder of the required form.

  2. Add or select the required formula field. Its Field Properties will appear on the right.

  3. Select the required value in the Display format in reports dropdown. The options will be displayed based on the field type chosen in the right pane.
    For Single line/Multi line:

    • Plain text: HTML tags will not be rendered and will instead be displayed as plain text characters in reports

    • HTML: HTML tags in the formula's evaluated value will be rendered in reports


            For Number/Decimal:

    • Choose one of the available numbering formats

For Currency:

    • Currency code: Choose in which country currency, the value must be displayed.

    • Display format: Choose one of the available numbering formats.

      The selected format will be used to display in the reports. 

Set field type for formula field

Notes
Note: The Field type property is available only when the Formula field displays string data. Learn More

The field type of the formula field's expression can be mapped to one of the compatible field types. Learn more. By default, the field type is automatically chosen based on the expected data type of formula expression.

Steps to set field type

  1. Navigate to the Edit mode of your app. Open the form builder of the required form.

  2. Add or select the required formula field. Its Field Properties will appear on the right.

  3. Select the required option in Field type under Appearance section.

    • For string based results, you can choose single line or multi line.

      • Single line formula field type supports only up to 255 characters

      • Multi-line formula field type supports (up to 65355 characters) multiple lines of formula but with some particular limitations.

    • For decimal-based results, you can choose between decimal/percent/currency.

    • For other types, the field type gets auto-selected.

 

The formula field will behave throughout the application according to the selected field type. For example, if the field type is set to Percent, the value will be displayed as a percentage - 75%, whereas selecting Currency will display the value in a monetary format - $123.00.