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.
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
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
.
Additional settings
You can select options for the column such as separators, or if the entry is required when a record is added.
  • 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.
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