Category

Overview

The Category control type allows selection of one or more values from a predefined set of options. See Categories for a complete discussion of creating and using categories.

A Category control that allows a single selection creates a dropdown menu showing the available options:

Menu Closed	Menu Open

A Category control that allows multiple selections creates a multiselect control:

Required Fields

• Name: The name of the field saved to the database.

• Type: Must be set to Form.<CategoryName> or [Form.<CategoryName>] where <CategoryName> is the name of a category field defined elsewhere in the Excel file. Enclosing Form.<CategoryName> in [] brackets allows multiple selection, while using just Form.<CategoryName> will create a single selection control.

• ControlType: Must be set to Category.

Optional Fields

• ClearWhenHidden

• CustomIndex: Settings for one or more indexes to create on the database that include this column.

• DefaultValue

• Description: Optional further details about the field.

• DisplayName: The name that will be shown for the field above the input box. This can be any string. If no DisplayName is provided, Name will be shown.

• Group: The layout group position for this control.

• MaskedCondition

• OptionController

• ReadOnlyCondition

• Required

• Style

• TabIndex

• UniqueConstraint (deprecated)

• UniqueConstraintScopeToParent (deprecated)

• ValidationCondition

• VisibilityCondition