29 Jul 2019

iSheets - Single line text

Product Filter HighQ Collaborate
Product Area Filter iSheets

Single line text is the most basic column type, allowing a user to 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 (new for v5.6.4) - Validate that the content follows the correct format for an email address when the record is submitted.

Email addresses are validated when a record is added, copiededited or imported. It does not check records that were added before this setting was selected.

  • 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.

This setting is only available when you first add the column to the iSheet. 

  • 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.

 

Was this article helpful?