Form Template Sections: Columns Tab

On the Columns tab, select the columns for the form. The system displays all columns of the Data Set that are not workflow columns.

To update the Columns tab:

  1. In New Form Template or Edit Form Template, select the Sections tab.
  2. Click New, or select a section and click Edit.
  3. In the Edit Form Template Section dialog, click the Columns tab, and select or view the following columns:
    • Included

      Select other attributes to be included in the form.

    • Name

      The name of the Data Set attribute

    • Dimension

      The column from an attribute of a specific dimension. This is read-only.

    • Data Type

      The corresponding data type for the column (read-only).

    • Total

      Total method for the attribute as specified in the Data Set. It is always read-only.

    • Display Width

      The column width specified in pixels. The default value is Size to Fit.

      • Small: Fixed pixel width of 50

      • Medium: Fixed pixel width of 100

      • Large: Fixed pixel width of 300

      • Size to Fit: Fit the width of the column based on the longest text in the rows

      • Custom: Specify a width. Minimum value: 20. Maximum value: 999.

    • Total Validation POV

      Validation of Supplemental Data against account balances in Financial Management.

      Note:

      View Only column for each dimension attribute must be deselected in order to validate against Financial Management totals.
    • View Only

      The column is for view only. If multiple forms are created for the same Data Set, then only one form can contain the column for input, including key columns.

  4. Total Row:, located at the lower area of the dialog.

    How the total row should be displayed:

    • Top: Total row is displayed at the top of the table

    • Bottom: Total row is displayed at the bottom of the table

    • None: Total row is not displayed

  5. Enter information on the following tabs:
  6. To save your updates and go back to the Form Template tab, click OK.