iSheet column types have many configurable settings that allow you to tailor the data fields to your use cases.
note
Certain configuration settings that only apply to specific column types are noted below.
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
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.
note
For many columns, descriptions are not necessary and this configuration may be left blank.
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.
note
If a column is created and saved in an iSheet with data, and at a later time a Site admin adds a default value to that column configuration, the default value will not populate the default value into existing items.
Default values only automatically populate a column if they are included in the initial column configuration and saved. This ensures that any existing data entered into a column before a default value assignment in a column configuration is not over-written.
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.
note
The following column types cannot be made mandatory: Lookup, File link, Folder link, iSheet link. Likewise, column types that require no user input cannot be made mandatory, though they need not be as they are automatically populated: Join, Calculation and Auto increment.
Allow search
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.
note
Only the text that appears in columns is searchable. For example, only the iSheet link text is searchable, not the underlying data in the link. Likewise, only the text of folders or documents linked via file link and folder link columns are searchable.
The following columns may not be included in the search form: Image, Attachment, Lookup, Join.
note
Lookup column values may be searched via the quick search box and the text search fields in the advanced search form (All of these words, Any of these words, Exclude these words).
Choice column additional settings
For choice columns, you may also configure how the search will function, by selecting one of the following radio options:
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.
note
If multiple columns are displayed in the lookup glossary view, whichever column of data is clicked will be copied back to the item:
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.
note
Except for the specific multiple-line text scenario described above, all fields copied via the lookup glossary are copied as text. For example, file and folder names as text are copied without links back to the files module. Likewise, usernames or email addresses, depending upon the user lookup column configuration, are copied as plain text without modal links to user profiles.
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
.
note
This is set at the view level as if you have particular conditions set up for a view, you may not want users to edit this while viewing the iSheet. The view may not automatically get refreshed and the condition would be broken. To find out more about inline editing click here.
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.