Working with Validation Rules

Working with Validation Rules

Working with Validation Rules


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.

Validation rules help you overcome this problem by arresting the wrong kind of data even before it can enter CRM
 

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.
Availability
Permission Required 
Users need Module Customisation profile permission to create validation rules. 

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. 


Note 
  1. If a primary field or a secondary field used in a validation rule gets updated via workflows, Blueprint, APIs, Import or Webforms, this field update takes precedence. Which means, the validation rule gets overwritten by the field update. As a consequence, CRM will accept the value entered a result of the field update over the validation rule. 
  2. Following is the split up of number of conditions within a validation rule. 
    1. 10 Parent Conditions per rule 
    2. 5 Child Condition per parent condition 
    3. 5 criteria per child condition 
  3. Validation rules are layout-specific. This means, under a single module, say Leads, you can configure different validation rules on the same field for different layouts. 
  4. Validation rules are executed in the order in which they have been created. 
  5. Validation rules cannot be supported for Lookup, Multi-select lookup, Multi-picklist, Formula, Auto-number and Multi-line field types. 
  6. When you create a validation rule as well as Blueprint validation for the same field, and if the two conditions are different, Blueprint overrides the validation rule. 
    That is, as long as the field is within a process, the Blueprint validation is applicable. When a record has exited a process, the validation rule is effective.
  7. Validation rules are supported in the following areas: 
    1. Create (Web version) 
    2. Quick create (Web version) 
    3. Edit (Web version) 
    4. Quick edit (Ajax - Web version) 
    5. APIs 
    6. Copy customisation 
    7. Sandbox 
  8. If records generated via webforms meet the validation rule criteria, they will be submitted for manual approval of records 
  9. For existing rules, if you want to specify whether the alert be thrown when the condition is met or not met, you can simply edit the rule and choose  When criteria is not met or  When criteria is met  under  Execute Rule. 

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. 


    • Related Articles

    • Configuring Workflow Rules

      Configuring Workflow Rules Create Workflow Rules in Zoho CRM Part 1 - Enter the basic details of the rule Part 2 - Specify the rule trigger Part 3 - Create a workflow condition Part 4 - Associate instant and scheduled actions Associate Actions to ...
    • Creating Actions in Workflow Rules

      Creating Actions in Workflow Rules The CRM allows you to create specific set of actions that aide in automating your sales and marketing activities. There are totally 5 actions that you can create and these actions can be associated with Workflow ...
    • Working with Page Layouts

      Working with Page Layouts Layout Assignment Choose layouts on record creation Understand the layout field Setting up workflow rules Create reports based on multiple layouts Understand page layouts with a scenario  Here is a simple scenario in which ...
    • Working with Portal

      Working with Portal Sending Invite to Users Changing Portal User Type Converting a Lead to Contact Deleting a Portal User Type Deactivating a Portal User Sending Invite to Users Once you have created the portal, you can start inviting the ...
    • Working with the Social Tab

      Working with the Social Tab Dashboard Monitor Post Activity Log Add a Lead/Contact/Account from Facebook/Twitter Automate Lead Generation via Social Media View Social Interactions Integrating your CRM account with Social media, fosters communication ...