Column settings

iSheet column types have many configurable settings that allow you to tailor the data fields to your use cases.

Description

Applicable column types
- Configurable for all iSheet column types except Auto-increment
Site Admins may add a description that, depending upon the iSheet configuration, will either display in a smaller font beneath the column name or appear in a right slide-in view upon clicking the question mark icon. See
Field descriptions
in the Creating an iSheet article.
The description can guide the user on how to fill in the field. For example, it might describe the preferred format of the information, such as a US social security number in the format ###-##-####. Or, the description field may be used to ask a lengthy question that needs to be answered. It is best practice to keep column names short, so the description is an ideal place for a sentence-length question.
The description field provides basic formatting features such as bold, italic, and underlined text; plus bullets, numbering and hyperlinks. A site admin could use the description to add a link to a page, within or outside of the Collaborate instance, that may provide information related to the field.

Default value

Applicable column types
- Single line text, Multiple line text, Choice, Number, Date and time
A Site admin may enter a default value for a column, which will appear in the column by default when a new iSheet item is created. The user can change this default value, assuming they have permissions to edit the column.
When a new column is added to an iSheet that already has rows of data, it can be useful and is good practice to include a default value in that new column to ensure that the existing rows have data in that column. If this value is no longer relevant, a site admin can remove the default value, so that it is no longer populated in that column for newly added rows.
Each column type has certain restrictions on what may be entered as a default value:
  • Single line text
    - The default value must be 80 characters or less.
  • Multiple line text
    - The default value must be plain text, even if Allow rich HTML text is enabled. However, there is no character limit for default values in multiple line text columns.
  • Choice
    - The default value must be one of the existing choices defined, even if the Include 'Other' option is enabled. Also, only one choice option may be populated by default, even if checkboxes (to allow multiple selections) are enabled.
  • Number
    - A maximum of 15 digits is allowed for whole numbers, and a maximum of 17 characters are allowed for decimals (including the decimal point). Default number values must also conform to minimum and maximum values defined in the number column configuration.
  • Date and time
    - The default date may be set to Today's date or a date defined by the date picker.

Column width

Applicable column types
- Configurable for all iSheet column types.
This setting controls the width of a column in
pixels
, as it appears when viewed in the iSheet module; however, it does not affect the width of the input field. Some columns will need to have this number increased or decreased, so that the iSheet table displays all data clearly and visibly.
Column width must be between 20 and 650 pixels.

Mandatory

Applicable column types
- Single line text, Multiple line text, Choice, Number, Date and time, User lookup, Hyperlink, Image
This option can enforce rules when a user enters a record into the iSheet. With this option, a user must populate this field before the iSheet record can be saved.
Applicable column types
- Single line text, Multiple line text, Choice, Number, Date and time, User lookup, Hyperlink, File link, Folder link, iSheet link, Calculation, Auto increment.
This setting is checked by default, making columns searchable and available as separate searchable fields in the advanced search form. You may uncheck this setting if you do not want the column contents to be searchable or available via the advanced search.
The following columns may not be included in the search form: Image, Attachment, Lookup, Join.
Choice column additional settings
For choice columns, you may also configure how the search will function, by selecting one of the following radio options:
  • Single selection in search
  • Multiple selections in search
See the Choice article for more information.

Add to the default view

Applicable column types
- Configurable for all iSheet column types
By default, each column you create will automatically be added to the iSheet
Default
view. Uncheck this option during column creation if you don't want to include it in the default view.
If the default view is later changed to another view, columns set to be added to the default view are not added to the new default view - only
new
columns created after the default view was changed.
For best practice, first determine which view will be the default in the iSheet, and check this configuration only for columns that should be included in the default view.

Allow the field to be populated from another iSheet

Applicable column types
- Single-line text, Multiple line text
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
.
When this checkbox is ticked, a Site Admin must select a source iSheet and a view as the source of the lookup glossary.
When adding or editing an iSheet item that includes a text field with this feature enabled, a Lookup glossary button appears.
Click the
Lookup glossary
button to open a new window with the source iSheet and view configured by the Site admin. The user can then navigate to the appropriate record of that iSheet, and click on a column value.
The value of the column clicked is copied back into the text field.
The text field can be further edited if needed. The imported text is not connected to the source iSheet, so changes made to the text in the item will not feed back to the lookup glossary source iSheet.
There are limits on the types of columns from the source iSheet that can populate a text field. Only the following column types may be used to populate a field via the lookup glossary:
  • Single line text
  • Multiple line text*
  • Choice
  • Number
  • Date and time
  • User lookup
  • Hyperlink
  • File link and folder link
  • Calculation
  • Auto increment
* Multiple-line text is only available from the lookup glossary source iSheet if the column is configured as multiple-line text. If both the source and configured columns are multiple-line text and have rich text enabled, then links and formatting from the source are copied.

Enable inline editing

Applicable column types:
  • number fields
  • Single-line text fields
  • choice columns (drop-down, radio and multi-select, but NOT user lookup) and
  • multi-line text
Any new columns (that are compatible) automatically have inline editing enabled by default. However, you must also enable inline editing on the View. In the list of iSheets, click on
More Actions
and then choose
Manage Views
. In the Columns section, set
Enable inline editing
to
Yes
.

Column condition settings

Applicable column types
- Configurable for all iSheet column types.
By default, every column is displayed when a new iSheet item is added. BUT a column can be made visible or hidden when adding or editing an item if certain conditions are met. See the article on configuring column conditionality for more information.

Related content