Add a Scope Item Field
Add custom scope item fields to enable users to enter or view information which is important to your organization.
Note: On pages that support auto-save, configured field formulas will be automatically recalculated when a change is made that impacts the value of a configured field formula. However, there may be times where the recalculation is not updated in the user interface. When this occurs, refresh the page to see the recalculated value.
To add a scope item field:
- In the object selector, select Workspace, select View Workspaces List, and then select a workspace name.
- From the Main Menu, select Summary & Settings.
- On the Summary & Settings page, select Defaults & Options, and then select Scope Item.
- On the Scope Item page, select the Configured Fields tab.
- In the table, select Add.
- In the Column Label column, enter a name for the new field.
- In the View Column Name column, enter a name for the field as it will be seen in the database when creating reports.
- In the Data Type column, select the type for the new field. The choices are: Boolean, Cost, Date, Integer, List, Number, or Text.
- In the Type column, select Manual if this field will hold data entered by a user or Formula if the data it holds will be calculated on the basis of a formula.
- (Optional) In the Summary Calculation field, specify how the app calculates summary rollup values for the field.
In most tables where you can view a list of similar objects, you can also view the totals for the various values of these objects. For example, on the Activities table for a project, you can view rollup totals for numerical values like Planned Duration and Planned Labor Units at the top of the table.
The Summary Calculation field enables you to specify how totals are determined for configured fields.
If you selected Cost, Date, Integer, or Number as the Data Type, in the Summary Calculation column, select a simple calculation like Sum or Average, if applicable.
Alternatively, if you set the Type field to Formula, you can set the Summary Calculation field to Use Formula. With this option selected, the app will use the formula defined in the Formula field to determine how the total rollup value is calculated for the field.
- (Optional) If you selected Text as the Data Type, in the Field Length column, enter the maximum number of characters that can be used in the field.
- If you selected Formula, configure the Formula section. Note: When adding a null check to a formula, you must specify the null check at the beginning of the if condition statement.
- Select Save.
Tips
- To delete a configured field, select the field, select Context, and then select Delete. You cannot delete a configured field if it is used in another configured field, a form, a workflow, or a field mapping.
- To choose which currency to view cost in configured fields of data type cost, select the Currency tab in Settings.
- Multi-currency is supported only in data type cost for formula configured fields.
- For a configured field of data type cost, the cost formula calculation is performed and saved in base currency then converted to project currency.
- For configured fields that are data type number and integer, using cost fields as part of formulas will only produce one value. This value is always calculated and displayed in base currency.
This setting is used in the following apps:
Scope |
Last Published Wednesday, October 16, 2024