Salesforce Features

Advanced Validation Rule Functions

Enhance Data Quality With the Power and Ease of FormulasAdvvalfunctions_thumb

All Editions

  • Validate important data formats like social security numbers and postal codes
  • Use reference data in other objects as a basis for validation

In the quest to ensure the highest data quality, business rules can get quite complex. The Spring ’08 release includes advanced formula functions that administrators can use to create powerful validation rules without writing code.

  • VLOOKUP Function: Similar to its Excel counterpart, the VLOOKUP function lets you use data in another object as a basis for validation. For example, to validate the zip code in a contact address, you could use the VLOOKUP function in a contact validation rule to search for a match in a custom object containing a list of valid zip codes.
  • ISNUMBER Function: The ISNUMBER function provides a simple way to tell if data entered in a text field only contains numbers, which is required for many types of identification numbers like credit cards and account numbers.
  • REGEX Function: Regular expressions are a powerful tool used by programmers to find patterns within bodies of text. The REGEX function exposes the power of regular expressions in validation rules, empowering formula authors to tackle the most demanding format validation challenges. Need to validate an IP address, country-specific phone number or VAT number format? If so, the REGEX function is for you.

Note: This feature is enabled by default.

Advvalfunctions_detail

0 Comments