Set Display Format for Formula Field | Zoho Creator Help

Set display format and field type

Set display format for formula field

Note: The Display format in reports property is available only when the Formula field displays string data. Learn More
  1. Navigate to the Edit mode of your app.
  2. Open the form builder of the required form.
  3. Add or select the required formula field. Its Field Properties will appear on the right.
  4. Select the required value in the dropdown below Display format in reports:
    • Plain text: HTML tags will not be rendered and will instead be displayed as plain text characters in reports
    • HTML: HTML tags in your formula's expression will be rendered in reports


Set field type for formula field

Note: The Field type property is available only when the Formula field displays string data. Learn More
  1. Navigate to the Edit mode of your app.
  2. Open the form builder of the required form.
  3. Add or select the required formula field. Its Field Properties will appear on the right.
  4. Select the required option under Field type. You can choose a single line type or multi-line type field.
    1. Single line formula field type supports only upto 255 characters
    2. Multi-line formula field type supports (upto 65355 characters) multiple lines of formula but with some particular limitations