Field Validators

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:

Field Validators
- Implicit Validators
- Basic Validators
- Format Validators
- Dependency Validators
- Uniqueness Validators
- Unique Strict Validation
  Implicit Validators

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

Check Box (Byte)
Date (Date)
Email (E-Mail)
Float (Decimal Number)
Integer (Integer)
Money (Money)

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 / Example
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
E-Mail	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 / Example
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 / Example
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 Combination of 2 fields in a workspace	Combination value of two specified fields must be unique in workspace	Names of specified fields
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:

Integer.
Single Line Text.
Picklist First Value as Default.
Picklist with filter.
Paragraph with no line breaks.
Picklist.
Picklist Latest Version.
Linking picklist.
Linking picklist with search filter.

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