Salesforce Data Validation

Data Validation – gives Administrators an easy way to ensure the integrity of data BEFORE it is saved in Salesforce. It includes:

  • Build Data Validation Rules
  • Setting the required and/or unique property on custom fields

Data Validation rules includes – Boolean formula on entire records and prove user defined error message. It executes when:

  • A users saves a record
  • Before a record are imported using Force.com Data Loader or Force.com API
No data validation on: Forecasts and Territories.
Data Validation with lead conversion – data validation during lead conversion.
Data Validation Solves following problems – makes fields conditionally required, prevent close date prior to end date, discount cannot exceed x%, total number of hours does not exceed 60.
Design Methadology
  1. Define business requirements
  2. Define requirements into logical equation with error condition and error message.
Required and Unique Properties – universally required field is a custom field that must have a value whenever a record is saved within Salesforce. Properties is available for custom fields but not standard fields. Applied at data model level rather than at individual page layout level.
Unique Property Details – is a field which doesn’t allow duplicate values. Available for custom fields not standard fields. An error message will display if data violates the unique constraint.  For Text and Text Area you can specify case sensitive options with the Unique Property.

 

 

Advertisements

2 Comments on “Salesforce Data Validation

  1. Informatics Outsourcing is an Offshore Market Research Company providing best service Worldwide with affordable price.In Quantitative Market Research providing Data Validation service.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: