Field Types

Note:

If you're a Fusion user, this feature is not available in the Components or Drawings workspaces. Learn more about system workspaces.

Field types determine how data is input, stored, and displayed in your Fusion Manage workspaces. Each field type controls the format and behavior of data in the Item Details, Grid, Bill of Materials, Sourcing, and Workflow Items tabs.

When you create a field, you select a field type that matches the kind of data you want to store. Any tabs that do not support a field type are noted in the field description.

Field Type Description
Auto Number Displays an automatically generated alphanumeric value based on a formula. The value increases each time a new item is added to the workspace (read-only).
Integer Displays whole numbers (e.g., 1, 25, 300).
Float Displays numbers with decimals (e.g., 1.25, 3.0, 42.75).
Money Displays a monetary value in currency format (e.g., $10.50 or €99.00).
Date Displays a date using a standard, valid format (e.g., 2025-11-19).
Single Line Text Displays a single line of text, such as a name.
Paragraph Displays multiple lines of text that preserve line breaks and carriage returns.
Paragraph w/o Line Breaks Displays multiple lines of text but does not preserve line breaks or carriage returns.
Checkbox Displays one or more selectable options from a set of choices.
Image Displays an image.
URL Displays an active link to a web address.
Email Displays an email address in a valid format (e.g., user@example.com).
CSV Allows entry of data in Comma-Separated Value format.
Flash Allows embedding a Flash object within the workspace.
BOM Unit of Measure Picklist Allows selection of a unit of measure (UOM) from the list defined in the BOM Manager (see Units of Measure).
Derived Displays data pulled from a selected item in another workspace (supported only in the Item Details tab). For guidance on creating a Derived field, see Derived Fields.
Picklist: Allows selection from a predefined list of values. The list can be user-defined or pulled from another workspace (see Picklist Manager). For guidance on creating a picklist field, see Picklist Fields. Picklist fields also have additional field types:
  • Radio Button: Displays picklist values as radio buttons, allowing only a single selection.
  • Single Selection: Allows selecting one value from the picklist.
  • Show First Value as Default: Automatically displays the first value in the picklist as the default.
  • Retain Last Saved Label: Keeps the last saved picklist value in the field, even if it's later removed from the picklist. Values are retained in Reports and the Grid, Linked Items, Bill of Materials, and Sourcing tabs.
  • Multiple Selection: Allows selecting multiple values from the picklist.
  • Latest Version: Displays the latest version of the item selected in the picklist. Available only for picklists that use records from a revision-controlled workspace.
  • Filtered: Filters the values available in one or more picklist fields based on the value selected in another picklist field. Supported only in the Item Details, Grid, Bill of Materials, and Sourcing tabs. Note: Filtered picklists work only with workspace picklists and only if all fields point to the same picklist.

Roll-up fields

Roll-up fields display a calculated value of an input field across the BOM. The following field types can be rolled up:

Any of these fields can be used as a roll up source. When a roll-up is applied, a function is run on that field and the result appears in each row of the BOM. A final rolled-up total is shown at the bottom of the BOM. For more information, see Roll-up Fields.

Parent page: Create Fields