Column types

Number column

The Number column allows you to enter numerical values into an iSheet. By using a number column, the system recognises the value entered as a number and will treat it as such when sorting and/or filtering rules are applied.
The number format is flexible and can display symbols for currency or percentages, and a choice of dots or commas as separators.
note
Please ensure you update to
API v18
 to use number and currency formats.
Add the Column name and Column type to the Number Column.
You can also add a description in the
Additional Column Settings
.
Several options can be configured to control how values are entered and displayed.
#Number format
As of October 2023, you can define the number format displayed in the column. You can choose to either display:
  • a comma as the thousands separator, with a dot as the decimal separator
  • a dot as the thousands separator, with a comma as the decimal separator
note
The number and symbol format is applied when an iSheet is exported to CSV, XML or PDF documents (but not XLSX).
note
The thousand separator is only displayed if
Show thousand separators
 is selected, below.
Minimum/Maximum range
This setting allows you to enter the minimum and maximum values that can be entered into the column. Populate both fields to create a permitted range.
Select decimal places
You can set the number of decimal places displayed, if any, up to a maximum of 5.
Default value and Column width
  • Default value
     - Any value entered into this field is automatically displayed when a new record is created. This value can be edited or removed if a user has sufficient editing privileges for the column.
  • Column width
     - The width of the column displayed when the iSheet is viewed in the iSheets section. entries that are too long continue on a new line. The minimum column width is 20 and the maximum is 650.
#Select symbol
As of October 2023, the
Select symbol
 menu includes currency and percentage symbols.
Select the drop-down menu to select a symbol from the options available.
Then select if the symbol appears
Before the number
 or
After the number
.
note
If you select the percentage sign (%), no additional calculation is made, the symbol is simply added to the value in the column. If you need to calculate a percentage from numeric values in other columns, please use a calculation column.
The number and symbol format is applied when an iSheet is exported to CSV, XML or PDF documents (but not XLSX or Export templates).
note
Note for Data visualization: currency symbols in data visualization charts appear in the tooltip pop-ups, rather than directly on the chart or graph itself.
Additional settings
You can select options for the column such as separators, or if the entry is required when a record is added.
note
Even if this is enabled, thousand separators do not appear when users are editing iSheet columns; they appear when a user views the column in iSheet item and table views.
  • Mandatory
     - A mandatory (or '
    Required'
    ) column must be filled when a record is submitted.
  • Allow search
     - Deselect this setting to hide the content of this column from search results.
  • Add to the default view
     - When the column is created add the column to the default View.
note
This setting is only available when you first add the column to the iSheet.
Column conditions
Conditional columns allow you to create forms that show fields based on your use case or project. Columns may be displayed or hidden based on other columns in the record. See Configure column conditions in iSheets for more information.

This article applies to:

  • PRODUCT: HighQ
  • Subject: iSheets,Setup

Related Content