Use this window to define the table column properties.

Columns

This pane lists the table columns that are defined by the assigned table model. The number of columns cannot be changed within this settings window. If needed, change the table model from the Project settings.

Properties

These properties relate to the selected column from the Columns list on the left side. The following properties are shown:

Column name

Read-only property that displays the name of the selected column from the assigned the table model.

Column width

This property is read-only if the Auto fit columns property from the table properties is TRUE. If you select FALSE for Auto fit columns, this property is enabled and you replace the default column width value "0" by an integer value (column width in pixel).

ReadOnly

By default the read-only property is set to FALSE. If you change it to TRUE you cannot edit the column in validation. Make sure that the cell is always valid as else the table cannot be valid.

Display style

You can change the style of a column to be displayed as normal text box, check box, or a selectable list. Select a style from the list. Depending on the selection additional options are available. This option is set to Textbox by default.

Textbox

Select this style to display the cells for this column as a text box on the validation form.

Checkbox

Select this style to display the cells for this column as a check box the user can select or clear.

You can use such a check box column to analyze user input in validation. For example, to export only the checked rows at a later time. If you want to fill the content of a cell that is checked or unchecked from extraction, make sure that the correct values are returned. If the value for the cell is "0" the check box is unchecked and for any else but "0" it is checked.

Combobox

Select this style to display the cells for this column as a selectable list that where users can also type in the box to narrow down the selection list. Then the user in the Validation module can select values from a list when he clicks on a cell in a column of the table. For example, tax codes or units of measure.

The Combobox settings properties are only visible when you select Combobox as the Display style. The following options can be set.

Style

Select the style to apply to your combobox.

• Selecting the Fixed List option enables the Values option and disables the Item Delimiter and Dictionary options.

• Selecting the Fill in Script option enables the Item Delimiter option and disables the Values and Dictionary options.

• Selecting the Dictionary option enables the Dictionary option and disable the Values and Item Delimiter options.

The value for this option is set to Fixed List by default.

Important Thin Client Validation supports lists with up to 10,000 entries. Thin Client Validation separates lists with more than 1000 into pages. This page breakdown ensures that form loading is not delayed due to large dictionaries or lists. When users expand the list, they can page through the entries using the navigation buttons at the bottom of the list.

Behavior

Select Free content if any content is allowed, or Restricted content when a user can only select an item from the list. The value for this option is set to Free content by default.

Item Delimiter

If the Combobox style option is set to "Fill in Script", this option is available. Specify a character that separates the combobox entries. The value for this option is set to a semicolon (;) by default.

Dictionary

If the Combobox style option is set to "Dictionary", this option becomes available. Select a dictionary in the list to display the dictionary in a combobox. To load a dictionary, change dictionary settings, or add dictionary settings, open the Project Settings and select the Dictionary tab.

Use descriptions

If the Combobox behavior option is set to "Restricted content", this option is enabled. Set this option to TRUE to provide a description alongside the values in the list.

For example, by showing the name of the city for an area code that must be selected (Belden|530, Beleverde|415, California City|760) a description helps a user select the correct value.

When set to TRUE, this option displays descriptions and their values in the list. If this option is set to FALSE, only values are displayed. The value for this option is set to FALSE by default.

Note If a dictionary is used and has "The import file contains auto replacement values" and the Field delimiter options specified in the Dictionary Options window, the "Word" entries are the combobox description and the "Replacement Text" column are the values saved in the XDocument.

This is true even if the Use descriptions option is cleared.

Description/Value delimiter

If Use descriptions is set to TRUE, this option is enabled. Specify the delimiter that separates descriptions and values. You cannot use the same character as the character defined for Item Delimiter. You can use only one character. The value for this option is set to Pipe (|) by default.

This option is disabled when the Combobox style is set to "Dictionary", even if the Combobox behavior is "Restricted content" and the Use descriptions option is "TRUE".

Display delimiter

If Use descriptions is set to TRUE, this option is enabled. Specify the delimiter that separates descriptions and values when displayed in the list on the validation form. The value for this option is set to [space]Pipe[space] ( | ) by default.

Show description and value

If Use descriptions is set to TRUE, this option is enabled. If this option is set to TRUE the description and its value are displayed in the list. If this option is set to FALSE, only the description is displayed. The value for this option is set to TRUE by default.

Sort by description

If the Use descriptions is set to TRUE, this option is enabled and the content of the list is sorted alphabetically by the description. If this option is set to FALSE then the list is displayed as defined via script or within the String Collection Editor window. The value for this option is set to TRUE by default. The default value can be changed only if Use description is set to TRUE.

Values

This option is enabled when the Combobox type option is set to "Fixed List". A small window is displayed if you click the button to the right of the field. The window enables you to enter a list of values (and descriptions, separated by the Description/Value delimiter) displayed in the list.

Definitions for the buttons at the bottom of this window can be found in Common Project Builder Buttons.