Column types

Single line text

Single line text is the most basic column type, a user can enter a single line of plain text.
  • Maximum characters
     - The maximum number of characters that may be entered in a single line text column is 255. However, you may decrease this value to limit the number of characters entered. By default, the maximum character limit is set to 255
  • Default value
     - Any text entered into this field will automatically be displayed when a new record is created. This text 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
Additional settings
You can select options for the column such as checking that an entry is a valid email address, or that the entry is required when a record is added.
  • Email validation
     - Validate that the content follows the correct format for an email address when the record is submitted.
  • 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
  • Enable inline editing
     - Activate inline editing for the column
  • Allow the field to be populated from another iSheet
     - This setting, if enabled, allows single and multiple line text fields to be populated with the value found in a selected column in the record of a source iSheet, the
    Lookup glossary
    .
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