Field Validators

Note:

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

This topic lists and describes the validators you can apply to fields to make sure your Fusion Manage data is clean, accurate, and useful. The validators available when you create a field are only those that are valid for the field type.

Important: Some fields may be part of an Item Details section that is restricted to a specific user group. Because these fields are hidden from some users, applying requirements validation to them can have adverse effects. If there is the possibility of an adverse effect, the system warns you when you apply the validation.

Field validators support the following types:

Implicit validators

These field types are preassigned a required validator that cannot be removed or changed (preassigned validators shown in brackets):

Basic validators

Validator Description Variable
Regular Expression Input Mask Field value must conform to a given regular expression. Regular expression
Required Field value must be entered.
Selection Required Drop-down selection must be made.
Unique Field value must be unique among all nondeleted records of the workspace. Field name

Format validators

Validator Description Variable
Byte Field value must be convertible to a byte.
CSV Value Count Number of entries in the CSV must equal a given number. Integer, or field containing an integer, that equals the number of entries in the CSV.
Date Field value must conform to a valid date format. Date format pattern string
Date Greater Than Date entered in field must be greater than date entered in other specified field. Name of Date field
Date Greater Than or Equal To Date entered in field must be greater than or equal to date entered in other specified field. Name of Date field
Date Less Than Date entered in field must be less than date entered in other specified field. Name of Date field
Date Less Than or Equal To Date entered in field must be less than or equal to date entered in other specified field. Name of Date field
Decimal Number Field value must be a valid positive or negative decimal number. 1.1, 2.5, -1.2
Each CSV Entry Must Have Identical Alpha Characters Each substring in a CSV must have the same leading characters (used for fields such as Reference Designators). R1, R12, R13
Email Field value must conform to a valid email format.
Float Range Float field value must be within specified range. Values of the lower and upper limits, e.g., 0.1 and 1.1
Integer Field value must be a positive or negative whole number.
Integer Range Integer field value must be within specified range. Values of the lower and upper limits, e.g., 3 and 10
Mask for CSV Field Each substring in a CSV must conform to a given regular expression. Regular expression
Maximum Length Field value must not exceed specified maximum length. Value of the maximum number
Minimum Length Field value must not be less than specified minimum length. Value of the minimum number
Money Field value must be a valid currency amount.

Dependency validators

Validator Description Variable
All or None Value must be entered for all OR none of specified fields. Names of specified fields
At Least One Field Required Value must be entered for at least one of specified fields. Names of specified fields
Both or None Value must be entered for either this AND other specified field OR for none of the fields. Name of other specified field
Conditionally Required Field value must be entered if other specified field contains specified value. Name of specified field; specified field value
Identical Field value must be identical to value of other specified field. Name of other specified field
If One Than Other Field value must be entered if value is entered for other specified field. Name of other specified field
One of Three Not More Value can be entered only for this field OR for one of two other specified fields. Names of other specified second and third fields
One or the Other, Not Both Value can be entered only for this field OR for other specified field. Name of other specified field
Percentage Within Other and Support Field value must be within specified percentage range of value of other specified numeric field. Other specified numeric field; specified percentage range
Range Within Other Field Percent Field value must be within specified percentage range. Specified percentage range

Uniqueness validators

Validator Description Variable
Unique Combination Except Keyword Combination value of two specified fields must be unique in the workspace except if value of one field is a specified keyword. Names of specified fields; specified keyword string
Unique Across All Grids in This Workspace Checks the uniquess of a column in the Grid tab across all records in this workspace. Names of specified fields, separated by commas
Unique Combination of 2 fields in a workspace Combination value of two specified fields must be unique in workspace. Names of specified fields
Unique In Grid For Each Record Checks the uniqueness of a column in the Grid tab Names of specified fields, separated by commas
Unique CSV Entries in BOM Each CSV entry in BOM must be unique.
Unique With Wildcard Field value must be unique within the workspace, with option to specify number of leading and trailing wildcard characters to ignore in uniqueness check. Specified number of leading characters; specified number of trailing characters
Unique Strict Validation Field value must be unique within the workspace even for the deleted records. This validation is also honored by scripts and import tool.

Unique strict validation

This new validation is available to the following fields in the Item Details tab:

This validation checks if the value in the field is unique among all records for the given workspace. Also to consider:

Parent page: Create Fields