Application Development

Add a Control Type to a Column

Column properties are specified to control the behavior of the Control Types, what is displayed: and how values are stored in a table. Before adding column properties, the control type for the column must be set.

Controls are:

Control

Description

Button

Displays a button that can be clicked to perform an action or navigate to another page.

Refer to Link to a Page using Buttons and Images for more information.

Check Box

Displays a check box that indicates whether a setting is enabled or disabled.

Refer to Add a Check Box for more information.

Combo Box

Displays a field as a List Box or text box with options from a selected Table or View.

Refer to Add List Boxes and Combo Boxes for more information.

DateTime

Displays a date-formatted field that may or may not accept input.

File

Used to stage any type of file including graphics, text, Word or Excel files. Files are stored in a specific location on the web server and are enabled for download.

Refer to Enable File Upload and Download for more information.

HTML Area

Provides a tool to format text within the field using bold, italics, colors or additional fonts.

Refer to Add an HTML Area to a Column for more information.

Image

Displays an image that can be clicked to perform an action or navigate to another page. An image can also be used as a column header.

Refer to Link to a Page using Buttons and Images for more information.

Label

Displays a label to distinguish between Vertical View sections.

Refer to Add a Label for more information.

List Box

Displays a field as a List Box or text box with options from a selected Table or View. Refer to Add List Boxes and Combo Boxes for more information.

Numeric

Displays a numeric field that can be formatted as currency, percent or other options.

Refer to Set a Column's Format for more information.

tab

Displays data on different tabs accessible at the top of a Vertical View.

Refer to Add a tab for more information.

Text Area

Displays a field to enter more data than can be stored in a text box.

Text Box

Displays a field that allows a user to enter free-form text.

NOTE: The character limit for a text box is determined by the character limit on the corresponding column in the SQL table.

Toolbar

Displays a page toolbar with buttons that can be used for page navigation or to perform some action, such as run a rule.

Refer to Add a Toolbar Button for more information.

The steps for adding a control type on the Horizontal View of the Page Columns page are identical, regardless of the control type to be added. After the record is saved on the Horizontal View, the fields that display on the Vertical View depend on the control type added to that column.

The controls available to a column depend on the column’s page’s page type. Refer to View the Controls Available For A Pag e Type for more information.

There are three ways to access the Page Columns page:

  • Select Admin > WebApps in the Navigation pane, and click the Pages icon for a WebApp. Locate the page and click the Column Properties icon.
  • Navigate to the page in the WebApp where the column property is to be applied. Click Change Settings on the Site Toolbar, then select Design >Column Properties.
  • Navigate to the page in the WebApp where the column property is to be applied, right-click the column heading, and click Add or Edit (Control Name) if the column property already exists.

To add a control to a column:

  1. Navigate to the Page Columns page.
  2. Click Add.

    View the field descriptions for the Page Columns page.

  3. Select the column in the COLUMN list box.

    NOTE: This list displays the columns from the page’s underlying view or table.

  4. Select the view that the column property applies to in the VIEW TYPE list box.

    NOTE: Refer to Use View Types with Column Properties for more information.

  5. Select the control from the CONTROL list box.
  6. Click Save.

Continue with assigning column properties on the Vertical View.