SharpSync
  • Welcome
  • Fundamentals
    • Getting Started
      • Registration
      • Landing Page
      • Support
      • Subscription
    • Data Sources
    • Property Mappings
      • Adding Property Mapping
      • Property Mapping Settings
    • Rules
      • Import / Export
        • Append text
        • Calculate number
        • Export manipulation
        • Format as decimal number
        • Prepend text
        • Remove property
        • Replace all instances
        • Replace first instance
        • Round to nearest X
        • Select from JSON
        • Set cell value
        • Set empty cells
        • Text manipulation
      • Display
        • Number between
        • Text contains
        • Text ends with
        • Text evaluation
        • Text is a number
        • Text is exactly
        • Text is in list
        • Text is not a number
        • Text is not empty
        • Text is not in list
        • Text length between
        • Text length is exactly
        • Text maximum length
        • Text minimum length
        • Text not contains
        • Text not ends with
        • Text not starts with
        • Text starts with
      • Advanced Scripting
    • BOM Comparison
    • Data Safety
    • Troubleshooting
      • Duplicate component paths
      • OAuth 2.0
  • Data Sources
    • Autodesk Inventor
    • CSV
      • Getting Started
      • Importing a Bill of Materials (BOM)
    • MS Dynamics 365 Business Central
      • Getting Started
      • Item Fields Json & Internal Names
      • Resource Fields Json & Internal Names
      • List Names For nestedObject Mappings
    • NetSuite
      • OAuth Setup
        • Permissions
      • RESTlet Script Setup
        • SharpSync RESTlet Script
      • Thumbnail Folder Setup
      • Authentication + Configuration
      • Common setup
        • Configure quantity mapping
        • Configure accounts mappings
        • Configure itemType mapping
        • Configure isPhantom mapping
        • Configure subsidiary mapping
        • Configure price mapping
        • Configure Where Used Link mapping
        • Configure thumbnail mapping
        • Read-Only NetSuite Fields
        • Common Mapping Rules
        • Common List names
      • Advanced Bill of Materials
      • Configure Routings
      • Integration tips
      • Troubleshooting
    • Odoo
      • Getting Started
        • Authentication + Configuration
        • Debugging tips
      • Common Setup
        • Map BOM Codes
        • Map BOM Types
        • Map Attribute Values
          • Reading Attributes - Overview
          • Display All Attribute Names
          • Display Single Attribute Values
          • Writing attributes
      • Product Management
      • Hosting Options
      • List Names
      • Permissions
      • Troubleshooting
    • Onshape
      • Getting Started
      • Setting up Derivatives
    • Propel PLM
      • Getting Started
    • SolidWorks
    • SolidWorks PDM
      • Downloading and installing the add-in
      • Configure the add-in
      • Setting up the Solidworks PDM Web 2
      • Troubleshooting
      • Submitting a BOM for update
  • Advanced
    • Derivatives
  • User management
    • User Management
    • Application Permissions
Powered by GitBook
On this page
  • Display Rules
  • Rule explanations
  • List of Display Rules
  1. Fundamentals
  2. Rules

Display

PreviousText manipulationNextNumber between

Last updated 4 months ago

Display Rules

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)

Rule explanations

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.

List of Display Rules

Rule name
Type
Description

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

Rule Setup
Number is between
Text contains
Text ends with
Text evaluation
Text is a number
Text is exactly
Text is in list
Text is not a number
Text is not empty
Text is not in list
Text length between
Text length is exactly
Text maximum length
Text minimum length
Text not contains
Text not ends with
Text not starts with
Text starts with