Reports Help

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 arthimetic 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 SkyDesk Reports.

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

Data Type Category Description
Plain Text Text Holds a line of simple text that contains less than 100 characters
Multi Line Text Text Holds multiple lines of text. This data type can hold text of more than 100 characters
E-mail Text Holds an Email Address
URL Text Holds a clickable Hyperlink / Web URL address. eg., http://reports.skydesk.jp
Number Numeric Holds an integer value (both positive and negative values)
Positive Number Numeric Holds only positive integer values
Decimal Number Numeric Holds decimal values (both positive and negative)
Currency Numeric Holds a currency value in different country denominations
Percentage Numeric Holds a percentage value
Auto Number Numeric Holds 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
Date Others Holds Date and Time value
Decision Box Others Holds a binary value eg., Yes/No, True/False, On/Off
Looked Up Column Others Refers to a column value in another table. Helps to relate two tables. Click to know How to create a Lookup Column.

Related Topics

Create New Table

Top