- Administrator's Guide
- Managing Form Templates
- Creating Form Templates
- Working with Sections
- Form Template Sections: Columns Tab
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:
- In New Form Template or Edit Form Template, select the Sections tab.
- Click New, or select a section and click Edit.
- 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.
-
- 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
-
- Enter information on the following tabs:
-
Columns tab: Form Template Sections: Columns Tab
-
Group by tab: Form Template Sections: Group By Tab
-
Mapping tab: Form Template Sections: Mapping Tab
-
History tab: Form Template Sections: History Tab
-
- To save your updates and go back to the Form Template tab, click OK.