› Project Builder user interface › Validation Form Layout user interface › Properties pane › Column Properties window

Column Properties window

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 available:

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 settings are available. This setting 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 settings can be set.

Style

Select the style to apply to your combobox.

  • Selecting the Fixed List value enables the Values setting and disables the Item delimiter and Dictionary settings.

  • Selecting the Fill in Script value enables the Item delimiter setting and disables the Values and Dictionary settings.

  • Selecting the Dictionary value enables the Dictionary setting and disable the Values and Item delimiter settings.

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

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 setting is set to Free content by default.

Item delimiter

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

Dictionary

If the Style setting is set to "Dictionary", this setting 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.

Values

This setting is enabled when the Style setting 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.