SharpSync
  • Welcome
  • Fundamentals
    • Getting Started
      • Registration
      • Landing Page
      • Support
      • Subscription
    • Data Sources
    • Property Mappings
    • Rule Templates
    • BOM Comparison
    • Data Safety
    • Troubleshooting
      • Duplicate component paths
      • OAuth 2.0
  • Data Sources
    • Autodesk Inventor
    • CSV
      • Setup
      • Importing a Bill of Materials (BOM)
    • MS Dynamics 365 Business Central
    • NetSuite
      • OAuth Setup
        • Permissions
      • Suite API Setup
      • Create an uploads folder
      • Setting up a thumbnail folder
      • 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
        • Common Mapping Rules
        • Common List names
      • Advanced Bill of Materials
      • Configure Server Side Script
        • Example Server Side Script
      • Configure SharpSync to use Server Side Script
      • Configure Routings
      • Integration tips
      • Supported features
      • Troubleshooting
    • Odoo
      • Getting Started
        • Authentication + Configuration
        • Debugging tips
      • Product Management
      • Hosting Options
      • List Names
      • Map attribute values
        • Reading Attributes - Overview
        • Display All Attribute Names
        • Display Single Attribute Names
        • Writing attributes
      • Permissions
    • Onshape
      • Getting Started
    • 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
  • Property Mappings
    • Property Mapping Settings
      • Rendering Types
    • Rule Templates
      • 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
    • Derivatives
    • Advanced Scripting
  • User management
    • User Management
    • Application Permissions
Powered by GitBook
On this page
  1. Property Mappings
  2. Rule Templates
  3. Display

Text length between

PreviousText is not in listNextText length is exactly

Last updated 2 months ago

Type: Display

Description: The number of characters in the cell value must be between the lower and upper limit (both inclusive).

Example: Success

  • Cell value: Description

  • Rule values:

    • Min length: 1

    • Max length: 11

  • Result: Rule passes because the length of 'Description' is 11

Observations:

  • 'Description' is 11 characters long and falls within the ranges.

  • No orange border, indicating valid data.

Example: Success

  • Cell value: D

  • Rule values:

    • Min length: 1

    • Max length: 11

  • Result: Rule passes because the length of 'D' is 1

Observations:

  • 'D' is 1 character long and falls within the ranges.

  • No orange border, indicating valid data.

Example: Fail

  • Cell value: Descriptions

  • Rule values:

    • Min length: 1

    • Max length: 11

  • Result:

Observations:

  • 'Descriptions' is 12 characters long and falls outside the ranges.

  • Orange border, indicating invalid data.