You need to sign in to do that
Don't have an account?
Akash Garg 2
validation rule on comparing 2 different object picklist value
How can i write the validation rule in which on changing value in Opportunity Picklist value it compares the value with 2 picklist fields of custom object .
If value in Opportunity picklist is matches with the any of the 1 field of custom object then it saves record otherwise it throws the error.
I have write the following validation rule but it didn't work.
Kindly help in correcting the validation rule.
If value in Opportunity picklist is matches with the any of the 1 field of custom object then it saves record otherwise it throws the error.
I have write the following validation rule but it didn't work.
Kindly help in correcting the validation rule.
TEXT(INCO_Term__c) <> "" && OR( TEXT(INCO_Term__c) <> TEXT(Account_Sales_Area_TI__r.Inco__c) , TEXT(INCO_Term__c) <> TEXT(Account_Sales_Area_TI__r.Incoterms__c) )
TEXT(INCO_Term__c) <> "" &&
( AND( TEXT(INCO_Term__c) <> TEXT(Account_Sales_Area_TI__r.Inco__c) ,
TEXT(INCO_Term__c) <> TEXT(Account_Sales_Area_TI__r.Incoterms__c) )
)
***Since you want either of the values should be matched. So we need to use AND here.
Thanks
Its not working.
After saving anyother value, it still take the value which is coming by a Trigger at first time.
I think ISCHANGED function to be used in this.
As this functionality is used by one of another field on opportunity whose Validation rule is as below and it also take the value from same trigger.
Payment term functionality is working perfectly.
My problem is not solved. I just want to know what these lines code do exactly because of this it always get the value maintained in Account sales area against Account and Sales area on opportunity.