Multiple line text

The multiple line text column type allows users to add multiple lines of text to an iSheet record without any character limits. This column type is typically used for addresses, explanations, cumulative notes, etc. and is similar to a single line text column, but with some minor differences.

The number of lines and width attributes govern how large the textbox will appear in the input form when adding an item. There are no restrictions on the amount of text that can be entered into a multiple-line text field and if the text entered exceeds the dimensions of the field, a scroll bar will appear to accommodate the extra text. If you wish to provide a bigger space for your users to add text, increase these settings to increase the size of the available text field.

Select the

Allow rich HTML text

option allows users to apply some basic formatting to the text entered, as well as links to external web pages or other content in your Collaborate instance. Below is an example of how the formatting options appear in the

Add item

form.

It is possible to truncate long entries in a multiple-line text column. This reduces the size of the iSheet and helps when viewing and navigating an iSheet.

Open the

Admin

module and select

iSheets

under

Module settings

; click on the name of the iSheet to see iSheet settings.

Select the checkbox next to

Set character limit to truncate multi-line text

and enter a limit (by default the character limit is 255 characters).

Select

Save

to save your changes.

When viewing an iSheet with truncated text, select

Show more

to expand the cell and see all text. Select

Show less

to hide the truncated text again.