One of the most challenging tasks in CRM system is ensuring the validity of data in it. A poorly maintained set of data can cost a company in more ways than one - your activities are slowed down, you will have inaccurate reports and it's plain annoying to have to manually verify details of each record when you have more important activities to deal with.

Basics of Validation Rules 

• Validation rules in the CRM will allow you to define   the  accurateness and validity of the data  that enters CRM. That is, you will define the undesirable values for a field in a validation rule. If a field value entered for a record matches the criteria defined in the rule, CRM will throw an alert and will not allow the record to be saved. 
  
• While defining the validation rule you can choose whether throw an alert when specific condition is met or when the condition is not met.  Example : You want the deal discounts to be 15%. You can define a validation rule in two ways: 
  
  • Throw alert when condition is not met - User will be alerted whenever the condition is not met or the amount entered is less than 15%. 
    
  • Throw alert when condition is met - User will be alerted whenever the discount amount entered meets the specified condition or is more than 15%. 
    
• The error message is customisable.  Example : You don't want deal discounts ever to be greater than 15%. If you were to set this validation rule in CRM, the essence of your validation rule would be the following: 
  
  • "If Discount is greater than 15% throw an alert message". 
    
    
    
    Error to be displayed: "Sorry! We don't allow a discount greater than 15%". 
    
    
    
• You can further drill down the rule by defining different custom error messages based on specific criteria. For instance, the discount for India should not be greater than 15%, but the discount for the UK can be up to 20%. Here you will have branch conditions for the discount fields and specify appropriate error messages. You learn more about these multiple conditions in the following sections.
  

Create a validation rule 

1. Go to  Setup  >  Customisation  >  Modules and Fields. 
   
2. Select the module for which you want to create the validation rules. 
   
3. In the [Module] page, click the  Validation Rules  tab. 
   
4. Click  + Create Validation Rule. 
   
5. In the  Create Validation Rule Popup  window, perform the following actions: 
   
   • Choose the layout  that the field you wish to validate, belongs to. 
     
   • Choose the field  and define the primary condition to initiate the rule. 
     
     For instance, if you want to validate the discount field to keep out discounts more than 15%, your primary condition will be,  "Discount > 15%" . 
     
     
     
6. Click  Next . 
   
7. In the  Validation Rule Editor , specify the criteria for validation.
   
      
   
   
8. Select an  Execute rule  from the drop-down list. 
   
9. In the  Validation Rule Editor, 
   
    enter the alert message  that should be thrown for records that meet the condition. 
   
   Example:  Sorry! We don't allow discount greater than 15%.  
   
   
   
   Note that this error message will be displayed for  all the records  that meet the criteria. Which means, whenever a deal is created with more than 15% discount, this error message will be displayed.
   
   
   
10. Move your mouse over to the  More  icon and click  Edit , when you have to create multiple conditions. 
    
    For instance, sometimes you may have policies that define discounts based on the region. Say for India, the maximum discount that can be offered is 15%, but in the USA, it can go up to 20% and so on. You can define these additional conditions in the validation rule and customise the error messages as required. 
    
    
    
11. To  Which records would you like to apply the rule on?  select  Choose based on specific conditions. 
    
12. Define each condition and specify the appropriate error message. 
    
13. Click  Add another option  to change the value of the primary field and configure different alert messages as required. 
    
14. Click  Save . 
    
    
    
    
    
    Now, depending on the validation rule, different error messages are displayed when the Region is chosen as UK and India. 
    
    
    

Example Scenarios

Following are a few more day-to-day example scenarios in which you can configure validation rules. 

1. If the  Phone Number  field does not contain 10 digits, throw an alert.
   
      
   
   
2. If the  SSN  field does not contain 9 characters, throw an alert. 
   
   
   
3. Holiday Inc  needs to validate the age of their travelers in special cases. Anyone under 18 or over 35 cannot be enrolled in adventure trips. So here, the validation rule could say,  If Age is Not Between 18 and 35 , throw an alert. 
   
   
   
4. Zylker Inc is a software company that offers in-person product training as a separate service. However, for a customer to request personal training, they should have purchased at least 10 user licenses of their software. Otherwise a training request cannot be accepted. 
   
   So a validation rule could be created to address this situation. If  Training  is selected as  Required , but  Number of Users  is less than  10 , throw an alert - Sorry, we need a minimum of 10 users for training request to be accepted. This can be further drilled down, based on the product chosen. 
   
   • If Product is A - 10 users 
     
   • If Product is B - 20 users 
     
   • If Product is C - 30 users and so on. 
     
   
   
   
   
5. If Lead Source is  Chat , but the Skype field is {Empty}, throw an alert.
   
      
   
   

Delete a validation rule

When you delete a validation rule, the rule as well as the alert message associated with it will be deleted. When you attempt to delete a field associated with a validation rule, you will be prompted to first delete the rule, after which you are free to delete the field. 

To delete a validation rule 

1. Go to  Setup  >  Customisation  >  Modules and Fields . 
   
2. Select the module for which you want to delete the validation rules. 
   
3. In the [Module] page, click the  Validation Rules  tab. 
   
4. Point to the rule you wish to delete and click the Trash  icon and confirm the action.