The following explains how to add columns or rows to a sheet, where applicable.
Configurable Modules: <name> Manager [Code-based configurable manager]
Note: You must have the "Create" permission in order to proceed with adding columns or rows.
To add columns to a code-based configurable manager sheet:
- Go to your shell or project in User mode.
- From the left Navigator, click Configurable Modules node to expand.
- Click your code-based configurable manager (<name> Manager [Code-based configurable manager]). The log displays a list of sheets and the corresponding properties (on the right-hand side).
- Double click on the sheet to open the sheet log window that displays the columns.
- From the toolbar options, click Add Column (the icon with three vertical lines) to open the Add Column window.
- Enter values in the fields that are displayed.
- After you are finished, select one of the following options:
- Cancel: To cancel the changes and close the window.
- Save: To save your work for creating a new column.
- Save & Add New: To save your work and begin creating a new column.
To add rows to a code-based configurable manager sheet:
- Go to your shell or project in User mode.
- From the left Navigator, click Configurable Modules node to expand.
- Click your code-based configurable manager (<name> Manager [Code-based configurable manager]). The log displays a list of sheets and the corresponding properties (on the right-hand side).
- Double click on the sheet to open the sheet log window that displays the columns.
- From the toolbar options, click Add Row (the icon with three horizontal lines) to open the Add Row window.
- Enter values in the fields that are displayed.
- After you are finished, select one of the following options:
- Cancel: To cancel the changes and close the window.
- Save: To save your work for creating a new row.
- Save & Add New: To save your work and begin creating a new row.
Configurable Modules: Generic Cost Manager
For details see Working with a Generic Cost Manager.
Configurable Modules: <name> Manager [Code- and record-based configurable manager]-Sheets
Note: You must have the "Create" permission in order to proceed with adding columns. You cannot add rows. The columns can capture data from business processes or manually entered data.
To add columns to a Code- and record-based configurable manager sheet:
- Go to your shell or project in User mode.
- From the left Navigator, click Configurable Modules node to expand.
- Click your code- and record-based configurable manager (<name> Manager [Code- and record-based configurable manager]) to expand.
- Click the Sheets sub-node ( <name> Manager [Code- and record-based configurable manager]-Sheets) to open the log. The log displays a list of sheets.
- Double click on the sheet to open the sheet log window that displays the columns.
- From the toolbar options, click Add Column (the icon with three vertical lines) to open the Add Column window.
- Enter values in the fields that are displayed.
- After you are finished, select one of the following options:
- Cancel: To cancel the changes and close the window.
- Save: To save your work for creating a new column.
- Save & Add New: To save your work and begin creating a new column.
Configurable Modules: <name> Manager [Code- and record-based configurable manager]-Class
You can create new <name> Manager [Code- and record-based configurable manager]-Class, only.
Fields
The following details some of the fields:
In this field: | Do this: |
---|---|
Name | The Name field is populated with the data source value selected. |
Datasource | Select a data source. The data sources available are data elements that are defined in the detail form for a class in uDesigner. Also listed are data elements based on SYS Numeric Logical Datasource, SYS Date Logical Datasource, SYS Project Cost Datasource, SYS BP Currency Amount, SYS BP Decimal Amount, and SYS BP Integer Amount data definitions. Note: You can add data picker fields as columns, but you cannot invoke the data picker from the sheet. |
Type |
|
Data Format | Specify how the column data appears for numeric columns. The options are:
|
Display Mode | Select Hide to make the column invisible to users. Select Show to display it. You can show/hide any column on the sheet, including the code name column. |
Summary Rows | Specify what the summary rows display.
|
Total | Specifies what displays in the bottom summary row for each column: Blank: Summary row remains blank. Sum of All Rows: Summary row displays the sum total of all row values for this column. Use Formula Definition: Formula entered in the Formula field applies to the summary row. |
Column Position After | Determines the position of the column on the sheet. |
You cannot copy a column.