You need to sign in to do that
Don't have an account?
Daniel Madhure
Want to combine validation rules in opportunity
Hello Guys,
there are multiple validation on my opportuity object. i wan to combine some of them,
can you please guide how to do that.
My first validation rule:
You can update Actions associated to the Build Stage only :
AND(
NOT( $Setup.UPSD_Bypass_Validation_Rules_Triggers__c.Bypass_Opportunity_Obj_Validation_Rules__c),
ISPICKVAL(StageName ,'Build'),
OR(
ISCHANGED(Develop_Call_Plan__c),
ISCHANGED(Identify_Key_Decision_Makers_Influencers__c),
ISCHANGED(Uncover_Challenges_and_Develop_Needs__c),
ISCHANGED(Assess_Size_Opportunity__c),
ISCHANGED(Present_Value_Proposition_Pricing__c),
ISCHANGED(Address_Concerns_Objections__c),
ISCHANGED(Finalize_Implementation_Plan__c),
ISCHANGED(Engage_UPS_Resources__c),
ISCHANGED(Customer_Training__c),
ISCHANGED(Anticipate_Competitive_Response__c),
ISCHANGED(Confirm_New_Revenue_Pursue_Full_Adop__c)
)
)
2nd validation : You can update Actions associated to the Closed Stage only
AND(
NOT( $Setup.UPSD_Bypass_Validation_Rules_Triggers__c.Bypass_Opportunity_Obj_Validation_Rules__c),
ISPICKVAL(StageName ,'Closed'),
OR(
ISCHANGED(Develop_Call_Plan__c),
ISCHANGED(Identify_Key_Decision_Makers_Influencers__c),
ISCHANGED(Uncover_Challenges_and_Develop_Needs__c),
ISCHANGED(Assess_Size_Opportunity__c),
ISCHANGED(Align_UPS_Solutions_Resources__c),
ISCHANGED(Quantify_Value__c),
ISCHANGED(Establish_Pricing__c),
ISCHANGED(Create_Value_Proposal_Impl_Plan__c),
ISCHANGED(Present_Value_Proposition_Pricing__c),
ISCHANGED(Address_Concerns_Objections__c),
ISCHANGED(Finalize_Implementation_Plan__c),
ISCHANGED(Engage_UPS_Resources__c),
ISCHANGED(Customer_Training__c),
ISCHANGED(Anticipate_Competitive_Response__c),
ISCHANGED(Confirm_New_Revenue_Pursue_Full_Adop__c)
)
)
can u please tell me how i can merge this validation rules
there are multiple validation on my opportuity object. i wan to combine some of them,
can you please guide how to do that.
My first validation rule:
You can update Actions associated to the Build Stage only :
AND(
NOT( $Setup.UPSD_Bypass_Validation_Rules_Triggers__c.Bypass_Opportunity_Obj_Validation_Rules__c),
ISPICKVAL(StageName ,'Build'),
OR(
ISCHANGED(Develop_Call_Plan__c),
ISCHANGED(Identify_Key_Decision_Makers_Influencers__c),
ISCHANGED(Uncover_Challenges_and_Develop_Needs__c),
ISCHANGED(Assess_Size_Opportunity__c),
ISCHANGED(Present_Value_Proposition_Pricing__c),
ISCHANGED(Address_Concerns_Objections__c),
ISCHANGED(Finalize_Implementation_Plan__c),
ISCHANGED(Engage_UPS_Resources__c),
ISCHANGED(Customer_Training__c),
ISCHANGED(Anticipate_Competitive_Response__c),
ISCHANGED(Confirm_New_Revenue_Pursue_Full_Adop__c)
)
)
2nd validation : You can update Actions associated to the Closed Stage only
AND(
NOT( $Setup.UPSD_Bypass_Validation_Rules_Triggers__c.Bypass_Opportunity_Obj_Validation_Rules__c),
ISPICKVAL(StageName ,'Closed'),
OR(
ISCHANGED(Develop_Call_Plan__c),
ISCHANGED(Identify_Key_Decision_Makers_Influencers__c),
ISCHANGED(Uncover_Challenges_and_Develop_Needs__c),
ISCHANGED(Assess_Size_Opportunity__c),
ISCHANGED(Align_UPS_Solutions_Resources__c),
ISCHANGED(Quantify_Value__c),
ISCHANGED(Establish_Pricing__c),
ISCHANGED(Create_Value_Proposal_Impl_Plan__c),
ISCHANGED(Present_Value_Proposition_Pricing__c),
ISCHANGED(Address_Concerns_Objections__c),
ISCHANGED(Finalize_Implementation_Plan__c),
ISCHANGED(Engage_UPS_Resources__c),
ISCHANGED(Customer_Training__c),
ISCHANGED(Anticipate_Competitive_Response__c),
ISCHANGED(Confirm_New_Revenue_Pursue_Full_Adop__c)
)
)
can u please tell me how i can merge this validation rules
Please use this forumla.
AND(
NOT( $Setup.UPSD_Bypass_Validation_Rules_Triggers__c.Bypass_Opportunity_Obj_Validation_Rules__c),
OR(ISPICKVAL(StageName ,'Build'),ISPICKVAL(StageName ,'Closed'))
OR(
ISCHANGED(Develop_Call_Plan__c),
ISCHANGED(Identify_Key_Decision_Makers_Influencers__c),
ISCHANGED(Uncover_Challenges_and_Develop_Needs__c),
ISCHANGED(Assess_Size_Opportunity__c),
ISCHANGED(Present_Value_Proposition_Pricing__c),
ISCHANGED(Address_Concerns_Objections__c),
ISCHANGED(Finalize_Implementation_Plan__c),
ISCHANGED(Engage_UPS_Resources__c),
ISCHANGED(Customer_Training__c),
ISCHANGED(Anticipate_Competitive_Response__c),
ISCHANGED(Confirm_New_Revenue_Pursue_Full_Adop__c)
)
)
Please let me know if it helps.
Please don't forget to mark this as solved if it's resolved.
Thanks,
Saravana