Validation Rule - Exceptions | Online Help - Zoho CRM

Points to note while updating a field used in a validation rule.

Validation Rules are effective on creating a record manually. However, when fields used in a validation rule (whether primary or secondary) are updated through other ways such as workflow update, and APIs, the field update takes precendence over the validation rules.

These instances are explained with further examples below:

Updating a primary field using a validation rule

Example:

Say you have a validation rule for the Deals module that says,

<<If Discount is > 20%, throw an alert, "Sorry! This is an unacceptable discount.">>

This validation rule will be effective when you manually create a deal in CRM with a discount greater than 20%. However if the primary field, Discount, is updated via any of the following means, the field update overrides the validation rule.

That is, if the discount field is updated as 25% via a workflow field update, this workflow takes precendence, and as a consequence, the value will be accepted by the system despite the validation rule that is supposed to throw an alert for values more than 25%.

Following are the means for field update that will take precedence over the validation rule.

Means of field update in CRMField update details
ImportUpdated on importing new leads or overwriting existing records
Workflow rulesUpdated as a result of workflow action
Approval ProcessUpdated on approval or rejection of a record
Blueprint

Updated as a result of the After Transition settings.

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.

APIsUpdated via API updateRecords method
Mass updatePrimary field used in a layout rule will not be available for mass update.

    Updating a secondary field using a validation rule

    This is an important note. When you try to update any of the secondary fields used in a validation rule through workflows, mass update, APIs or Import, CRM will accept the secondary field's values regardless of the conditions in the rule. As a result your data may gather unacceptable values despite the validation rule.

    For example, you have a validation rule to define discounts based on region.

    • Discount cannot be greater than 20% for USA
    • Discount cannot be greater than 25% for UK
    • Discount cannot be greater than 15% for India

    In this case, Discount is your primary field and the Regions become the secondary fields.

    While Discount may not even show up on a mass update, Region will. If you decide to update all Regions to India, all your deals may end up with different discounts for "India", while your validation rule prescribes things differently - thus leading to unacceptable values in your module. 

    CRM will currently not restrict the field update of secondary fields used in a validation rule. Make sure you check whether fields are used in a validation rule before you update them.

      Zoho CRM Training Programs

      Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

      Zoho CRM Training
        Redefine the way you work
        with Zoho Workplace

          Zoho DataPrep Personalized Demo

          If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

          Zoho CRM Training

            Create, share, and deliver

            beautiful slides from anywhere.

            Get Started Now


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION








                                  You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                      Manage your brands on social media

                                        Zoho Desk Resources

                                        • Desk Community Learning Series


                                        • Digest


                                        • Functions


                                        • Meetups


                                        • Kbase


                                        • Resources


                                        • Glossary


                                        • Desk Marketplace


                                        • MVP Corner


                                        • Word of the Day


                                          Zoho Marketing Automation

                                            Zoho Sheet Resources

                                             

                                                Zoho Forms Resources


                                                  Secure your business
                                                  communication with Zoho Mail


                                                  Mail on the move with
                                                  Zoho Mail mobile application

                                                    Stay on top of your schedule
                                                    at all times


                                                    Carry your calendar with you
                                                    Anytime, anywhere




                                                          Zoho Sign Resources

                                                            Sign, Paperless!

                                                            Sign and send business documents on the go!

                                                            Get Started Now




                                                                    Zoho TeamInbox Resources



                                                                            Zoho DataPrep Resources



                                                                              Zoho DataPrep Demo

                                                                              Get a personalized demo or POC

                                                                              REGISTER NOW


                                                                                Design. Discuss. Deliver.

                                                                                Create visually engaging stories with Zoho Show.

                                                                                Get Started Now







                                                                                              You are currently viewing the help articles of Sprints 1.0. If you are a user of 2.0, please refer here.

                                                                                              You are currently viewing the help articles of Sprints 2.0. If you are a user of 1.0, please refer here.



                                                                                                    • Related Articles

                                                                                                    • Layout Rule Exceptions

                                                                                                      Layout rules are effective on creating a record manually. However, when a field used in a layout rule is updated through other ways such as workflow update, and APIs, the field update takes precendence over both these rules. These instances are ...
                                                                                                    • 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 ...
                                                                                                    • FAQs: Validation Rules

                                                                                                      What is a validation rule in Zoho CRM and why do I need it? In this data-driven world, it is crucial to ensure the validity and accuracy of your data. Data can enter your CRM system through various channels, such as advertisements, web forms, ...
                                                                                                    • Creating Validation Rules Using Functions

                                                                                                      By using function you can create a validation rule where the value entered by the user needs to be verified outside the CRM database. You can even validate the fields like phone numbers, zip code and so on for a particular pattern by mentioning the ...
                                                                                                    • Use Cases for Validation Rules Using Functions

                                                                                                      Make detailed description mandatory if specific terms are entered in the field Zylker Tech manufactures electronic assemblies and similar other products. Their manufactured items are outsourced for quality check to a third-party service provider. The ...
                                                                                                      Wherever you are is as good as
                                                                                                      your workplace

                                                                                                        Resources

                                                                                                        Videos

                                                                                                        Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                        eBooks

                                                                                                        Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                        Webinars

                                                                                                        Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                        CRM Tips

                                                                                                        Make the most of Zoho CRM with these useful tips.



                                                                                                          Zoho Show Resources