Column Types Supported

Column Types Supported

Data Type/Column Type of a column in a Table defines the nature of values a column could contain and the operations that could be done over the same. Eg., an Age column could be "Positive Number" type. This column can contain only positive numbers and you could apply arithmetic operations over the same.

Data type of a column also determines the formatting options that are possible for displaying the values in the column in various reports created in Zoho Reports.

Zoho Reports supports the following data types (column types) currently.

Data TypeCategoryDescription
Plain TextTextHolds a line of simple text that contains less than 100 characters
Multi-Line TextTextHolds multiple lines of text. This data type can hold text of more than 100 characters
E-mailTextHolds an Email Address
URLTextHolds a clickable Hyperlink / Web URL address. eg., http://reports.zoho.com
NumberNumericHolds an integer value (both positive and negative values)
Positive NumberNumericHolds only positive integer values
Decimal NumberNumericHolds decimal values (both positive and negative)
CurrencyNumericHolds a currency value in different country denominations
PercentageNumericHolds a percentage value
Auto NumberNumericHolds auto-generated incremental numeric values, which are unique. This would be helpful when you need to have a unique identifier associated to each row/record in the table.
Auto Number column value starts with 1 and each new value will be incremented by 1. Auto Number values will always be unique
DateOthersHolds Date and Time value
Decision BoxOthersHolds a binary value eg., Yes/No, True/False, On/Off
Looked Up ColumnOthersRefers to a column value in another table. Helps to relate two tables. Click to know How to create a Lookup Column.

Formatting

Zoho Reports offers options to change the format of a column like an alignment, decimal places, date formats, currency symbol etc., depending on its data type. Using these options you can choose how you would like to have your column data displayed in your table.

Refer to the following video to format a column :

Note:

  • Option to format columns will be disabled for shared users.

Formatting options provided in the dialog box changes based on the data type of the selected column. The following table gives a brief description of these options.

Numeric Data Type:
OPTIONDESCRIPTION
Alignment

This option can be used to horizontally align the value in the cell. Possible values are left , right and center.

Separator

This option allows you to pick a decimal and thousand separator to be used.

Apply User Locale Settings - You can select this option to use separators based on the locale settings of the user. For example, in US locale a comma will be used for a thousand separator and in case of German locale a dot will be used.

Thousand - This option can be used to select the type of thousand separator. This option will be enabled for number and decimal type columns. This option will be disabled when you have chosen. Apply User Locale Settings mentioned above. Available options include: Comma, Dot, Space and Single Quote

Decimal - This option can be used to select the type of decimal separator. This option will be available only for decimal, currency and percentage columns. Also, this option will be disabled when you have chosen. Apply User Locale Settings mentioned above. Available options include Dot and Comma.

Currency Symbol

This option enables you to choose the type of currency symbol displayed. You can select the currency symbol you want from the wide variety of symbols available in the drop down list. This option will be enabled for currency type columns.

Negative Number Display

This options allows you to specify how negative numbers are to be displayed

Options available are:

  • Enclosed in parenthesis - Displays a negative numbers enclosed in parenthesis, For example, displays '-25' as (25)
  • With Negative Sign - Displays a negative number with a negative sign. For example as '-25'
Decimal Places

You can use this option to set the number of decimal places to display for decimal, currency and percentage columns.

Date Data Type:
OPTIONDESCRIPTION
AlignmentThis option can be used to horizontally align date in the cell. Possible values are left, right and center.
Choose Date Format

This option allows you to pick the date format you want, for displaying dates values, from the given list.
Enter Your Date Format:
Zoho Reports provides this option to allow you to specify a custom date format, if the required format is not available as part of the default list provided. Refer here to know how to construct custom date format string.

String/Category Data Type:
OPTIONDESCRIPTION
AlignmentThis option can be used to horizontally align the text in the cell. Possible values are left, right and center.
URL Data Type
AlignmentThis option can be used to horizontally align the text in the cell. Possible values are left, right and center.
Alternate TextThis option allows you to provide a substitute reader-friendly text that will be shown instead of the actual URL.

Couple of points to note on the behavior of the Alternate text (for URL data type columns) feature in various scenarios

  • Sorting - When you sort URL data type column in a table, sorting will be done based on the actual URLs in the column.
  • Copy and Paste - When you copy and paste the Alternate text in a column, actual URL corresponding to it will be pasted.
  • Exporting - When a view with alternate text is exported, the view will be exported with the actual URLs.