Cortex | Administration | Item Fields

Manage item fields (Administration)

Only users who are set up as administrators in Cortex have access to this feature.

You use item fields to configure the columns that display in the bottom pane of the single project page when viewing elements. The item field list contains all the item fields in Cortex Project History. For each field, you can specify which group the field belongs to, along with the field name, type, expression (Text, Quantity, Currency, Check box, Ratio, Simple ratio, etc.), expression (a formula that uses basic math operators and built-in functions to calculate the field value) (for certain field types only), unit, and number of decimal places.

How many item fields do I have?

The field count displays above the grid. The field count works with the filter feature. If you want to know how many fields of a particular type you have, you can filter the list by the Type column and look at the field count.

How do I?

Open the Administration module

Click and select Administration from the menu. The Administration module opens in a new browser tab.

Add item fields

  1. In the Administration module options list, select Fields > Item fields > Fields.
  2. Click Add to open the Add Item Field window.
  3. Enter a name for the field in the Name box.
  4. From the Group list, select the group you want to assign the field to.
  5. From the Type list, select the applicable field type.

When should I use the Number type versus the Quantity type?

    • Use the Number type when the field just contains a number, such as a revision number, part number or in-service year, and the unit is implied (miles to site, number of desks, and so on).
    • Use the Quantity type when you want to assign a default unit to the field, but the unit could vary (e.g., Concrete volume is usually CY, but for jobs in Mexico it’s M3) or you want the value factored (e.g., productivity factors applied to labor hours, or waste factors applied to material quantities).

When should I use the Cost type versus the Currency type?

    • Use the Cost type for fields that you want included in the grand total amount.
    • Use the Currency type for fields that you want to be independent of (not included in) the grand total amount.
  1. Select the desired field options (options vary based on the selected field type):
    • Calculated: If you select one of the following field types, you can use an expression (a formula that uses basic math operators and built-in functions) to calculate the field: Currency, Number, Quantity, Percentage, Ratio, Text. To add or edit an expression for the field, select the Calculated check circle and see Add or edit expressions for fields for details.

A lock symbol next to the Value expression box indicates the expression is locked and cannot be edited because it is a system expression or a custom expression developed for your company.

    • Required: To make this field required, select the Required check circle. Otherwise, clear this check circle. (This check circle is not available if you select the Calculated check circle.) Cortex ensures that any fields you make required are automatically added to all your project import templates. Required fields are identified with a red asterisk (*) in the project import templates and cannot be removed from the Selected column in the templates.
    • Available in charts: This option is available for the following field types: Cost, Currency, Number, Percentage, Quantity, Ratio, Simple ratio. To make this field available in charts when at least one of the selected elements has a value, select this check circle. Otherwise, clear it.
    • Suppress if zero: This option is available for the following field types: Cost, Currency, Number, Percentage, Quantity, Ratio, Simple ratio. To hide this field if its value is zero, select this check circle. Otherwise, clear it.
    • Factor target: This option is available for the following field types: Cost, Currency, Ratio, Simple ratio. To select this field as a factor target (Factor targets specify which fields you can adjust using rate tables.) in Administration > Factors > Factor targets, select this option. Otherwise, clear it.
  1. Add list values for list and multi-select list fields.

How do I add list values?

To add list values one at a time

    1. Click Add next to List values
    2. In the New list value box, enter the value and press ENTER (or click Add again). You're ready to enter the next list value.
    3. After you enter the last list value, click Add to display the list of values you entered.
    4. To change the order of the list values, select the value you want to move and drag it to the desired position in the list.
    5. To edit a value, select it and click Edit.
    6. To delete a value from the list, select it and click Delete.

To add list values en masse

Important. This procedure replaces all the existing list values for the field.

    1. Click Export in the Add Item Field window to download an Excel list values workbook.
    2. Enter the list values in the Excel workbook.
    3. Save the Excel workbook.
    4. Click Import in the Add Item Field window and select the Excel workbook to populate the List values box.
  1. Select a format for the field, if prompted. (Some field types, such as Currency, Date, and others, provide a format option.)
  2. For Ratio and Simple ratio field types: To show the currency symbol before the currency value in the numerator of ratio fields, select the Show symbol with currency numerator check circle.
  3. Set defaults for the field, if desired.
    • Default column width: Change the default column width for the field, if desired. This setting controls the width of the column in a grid.
    • Initial value: Set an initial value to use for the field, if desired. For Quantity fields, you can also specify the Initial unit.

How do initial values work?

Administrators can specify initial values (and units for Quantity fields) to provide users with the suggested value and/or unit to use for this field on new projects and budgets.

When you download a new project import template, initial values and units populate the applicable fields on the Project and Item sheets in the template.

Initial values appear for any fields that are visible when users create a new budget and the first time users add new fields to a budget. Users can change or clear initial field values for the budget.

Can I add units on-the-fly?

If the unit you want is not available in the unit list, enter it and Cortex will automatically add it to the Unit list in Administration. In the Unit list, Cortex adds Initial unit for field name to the unit name so you know that the unit was created on-the-fly when adding fields.

    • Value if blank: Set a value to use for the field if it is blank, if desired.

How does this setting work?

The Value if blank setting is available for all field types except Ratio and Date fields that are not calculated. This is useful for fields that typically have the same value; for example, fields used in element hierarchies. The values you enter for this setting populate the non-project specific import template when you download it. After downloading an import template, content managers can change these values, if desired.

If you specify a Value if blank value for a field, users cannot save the project or budget unless this field contains a value. (If the user doesn't enter a value in a field that has a Value if blank value specified in Administration, the system inserts this value when the user saves the project or budget so the field will not be empty.)

    • Unit if blank: (Quantity and Ratio fields only.) Enter a unit for the field, if desired. The units you enter for this setting populate the non-project specific import template when you download it. After downloading an import template, content managers can change these units, if desired. For Ratio and Quantity fields that are calculated, this unit is controlled by the Unit expression.

Can I add units on-the-fly?

If the unit you want is not available in the unit list, enter it and Cortex will automatically add it to the Unit list in Administration. In the Unit list, Cortex adds Unit if blank for field name to the unit name so you know that the unit was created on-the-fly when adding fields.

    • For Simple ratio fields only: To set up the ratio, select a project or item field for the Numerator from the list and a project or item field for the Denominator from the list.
  1. Click Save.

Edit item fields

  1. In the Administration module, select Fields > Item fields > Fields in the options list.
  2. Click the name of the field you want to edit.
  3. In the Edit Item Field window, change the field information as desired.

Delete item fields

  1. In the Administration module, select Fields > Item fields > Fields in the options list.
  2. Select the check circle of the field you want to delete, click Delete, and confirm the deletion of the field.

Set up a library of code values using an item field

Library-type item fields are used to group and sort elements on the single project page and the Compare projects page. They are available as element views on these pages, as well as when you browse for elements. For example, you might have code libraries for Uniformat Level 1 and Uniformat Level 2.

  1. In the Administration module, select Fields > Item fields > Fields in the options list.
  2. Click Add to open the Add Item Field window.
  3. Enter a name for the field in the Name box. (This name is used for the element view.)
  4. From the Group list, select the group you want to assign the field to.
  5. From the Type list, select Library. A read-only grid appears at the bottom of the window.
  6. Specify the code values.
    1. Click Export to create a structured Microsoft Excel workbook where you enter the code values. Each row defines one code value.
    2. (Required) In the ID cell, enter a unique identifier for the first code value.
    3. (Required) In the Description cell, enter a description of the first code value.
    4. (Optional) If you want to use the quantity for a project attribute to drive element quantities, you can specify up to three lookup quantities (Lookup quantity, Lookup quantity 2, Lookup quantity 3) for the code value. Select the project attribute you want to use for the element quantity. Only project attributes that are quantities are available in the list. Cortex Project History will look up the attribute quantity and use it for the element quantity. For example, you could use the Project size attribute to drive the element quantity for Foundation.
    5. From the Aggregate unit list, select the unit of measure for aggregating child item quantities. Cortex Project History aggregates only the quantities of children whose unit matches the one specified for this code value.
    6. (Optional) In the Comment cell, enter notes or comments for the code value. You can use the comment to describe what's included in this cost group. Note that you can copy and paste information from an online specification book into this cell. When you see next to a code ID in elements view, it indicates a comment is available for the ID. Click to view the comment.
    7. Repeat this process to define additional code values.
  7. When you finish defining code values, save the Microsoft Excel workbook. The file name defaults to: <Item field name> code import where <Item field name> is the name you entered for the library field.
  8. In the Add Item Field window, click Import, select the Microsoft Excel workbook, and click Open.
  9. The grid in the bottom of the Add Item Field window populates with the values from the workbook, listed in order by ID. Cortex Project History performs limited validation of code values before importing them into the grid. For example, if you enter duplicate IDs for code values in the Microsoft Excel workbook, Cortex Project History imports only the first code value having that ID. If the ID or Description cell is empty for a code value, Cortex Project History ignores the row during the import.
  10. Click Save to save the library item field. 

Filter the field grid by a specific column

You can filter the field grid by a specific column to work with a subset of the item fields. For example, suppose you want to focus on building out the fields for a specific field group. You can filter the field grid by the Group column to show only the fields in that group.

  1. In the Administration module, select Fields > Item fields > Fields in the options list.
  2. To filter the field grid by a specific column, click in the column heading.
  3. Select the column value(s) to filter the field grid by and click Apply at the bottom of the value list.

To clear the filters for the field grid, click in the column heading and click Reset at the bottom of the value list.

Sort the field grid by a column

Click the heading of the column you want to sort by. To switch between sorting in ascending and descending order, click the heading again.

Search the field list

You can search for fields by entering some or all of the field name.

  1. Click in the Name column heading.
  2. In the search box, enter some or all of the field name and click Filter to see the list of fields that match your search criteria.

Export field list to Excel

To export your field list to Excel, click the (Download) icon located at the top of the page. The download begins immediately and saves to a predetermined folder location.

 

You can edit the item fields provided with Cortex 365, but you cannot delete them or add new ones.