Display
Last updated
Last updated
Display rules are rules that trigger either warnings or errors after the data has been imported. This plays out as:
Data is imported
Import rules are applied to transform data
Data is displayed onscreen
Rules are evaluated
Warnings or errors are displayed based on the rule conditions
A Display Rule can be set to either pass
or block
.
A value of pass
will show an orange border if it fails. The user is still able to submit the BOM
A value of block
will show a red border if it fails. The user is not able to submit the BOM
(Colors are configurable)
Below is a comprehensive list of Display Property Mapping Rules. Click a rule to explore it in depth.
Go to for more information about setting up rules.
Display
The number in the cell value must be between (inclusive) the numbers specified
Display
The cell value must contain the specified text
Display
The cell value must end with the specified text
Display
Evaluates the cell value given the JavaScript expression
Display
The cell value must not be numeric
Display
The cell value must exactly match the specified text
Display
The cell value must be in the list of specified items (Comma separated)
Display
The cell value must not be numeric
Display
The cell value must contain text (1 or more characters)
Display
The cell value must not be in the list of specified items (Comma separated)
Display
The number of characters in the cell value must be between the lower and upper limit
Display
The number of characters in the cell value must be exactly the length specified
Display
Limits the length of the cell value text to a maximum number of characters
Display
The number of characters in the cell value must be greater than the specified number
Display
The cell value must not contain the specified text
Display
The cell value text must not end with the specified text
Display
The cell value must not start with the specified text
Display
The cell value text must start with the specified text