Cortex | Administration | Element Fields

Manage element fields (Administration)

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

Use the element fields to configure the columns that display in the top pane of the single project page when viewing elements. The element field list contains all the element fields in Cortex Project History. For each field, you can specify which group the field belongs to, along with the field name, type (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 element 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 element fields

  1. In the Administration module options list, select Fields > Element fields > Fields.
  2. Click Add to open the Add Element 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).
  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, Percent, 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.

    • Available in charts: This option is available for the following field types: Currency, Number, Percent, 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, Percent, Quantity, Ratio, Simple ratio. To hide this field if its value is zero, select this check circle. Otherwise, clear it.
  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 an Initial value for the field, if desired. For Quantity fields, you can also specify the Initial unit if the Quantity field is not calculated.

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 forfield 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 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 forfield 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 element field for the Numerator from the list and a project or element field for the Denominator from the list.
  1. Click Save.

Edit element fields

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

Delete element fields

  1. In the Administration module, select Fields > Element 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. 

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 element fields. For example, suppose you want to focus on building out the fields for a specific group. You can filter the grid by the Group column to show only the fields in that group.

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

To clear the filters for the 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 Apply 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.

 

The Fields > Element fields > Fields option is not available in Cortex 365. Administrators cannot manage(add, edit, or delete) element fields in Cortex 365.