You need to sign in to do that
Don't have an account?
Validation rule that references product and opportunity fields
I'm trying to create a validation rule that requires a custom opportunity field to be populated (look up field) before being able to add a specific discount product to the opportunity. Is this possible?
AND(
ISBLANK(Ambassador_Referral__c),
TEXT(Product2.ProductCode, 'REFDISCOUNT')
)
Error: Field Product2 does not exist. Check spelling.
AND(
ISBLANK(Ambassador_Referral__c),
TEXT(Product2.ProductCode, 'REFDISCOUNT')
)
Error: Field Product2 does not exist. Check spelling.
To get the references of both product and opportunity fields. Please move this validation rule to opportunity product and follow formula mentioned below: Please let me know if you have any quesiton.
Thanks & Regards
Gulshan Raj
LinkedIn (https://www.linkedin.com/in/gulshan-raj-a26b0640/)
Twitter (https://twitter.com/gulshan_bittoo)
All Answers
On which object you are creating this validation rule? Is this opportunity or Opportunity product?
Please provide me detail, I will help you.
Thanks & Regards
Gulshan Raj
LinkedIn: https://www.linkedin.com/in/gulshan-raj-a26b0640/
Twitter: https://twitter.com/gulshan_bittoo
This error was on the opportunity. I also tried on the product, but received a similar error msg:
AND(
ISBLANK(Opportunity.Ambassador_Referral__c),
TEXT(ProductCode, 'REFDISCOUNT')
)
Error: Field Opportunity does not exist. Check spelling.
Thank you!
You can use above code, just an example. Can you please elaborate your requirements.
To get the references of both product and opportunity fields. Please move this validation rule to opportunity product and follow formula mentioned below: Please let me know if you have any quesiton.
Thanks & Regards
Gulshan Raj
LinkedIn (https://www.linkedin.com/in/gulshan-raj-a26b0640/)
Twitter (https://twitter.com/gulshan_bittoo)