function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
BretzBretz 

Need Help With Validation Rule on Case Object and Product Field

I am trying to write a validation rule that will not allow a case to be closed if the Product Field has a value of unknown. But when I write the rule I keep getting the same error: Field Product does not exist. Check spelling. Product is a lookup field on the Case Object to the Product Object. 

 

Can someone help??

 

The rule is as follows:

 

AND(ISPICKVAL(Status,"Closed as Duplicate"),Product<>"unknown")

 



Thanks

Bex

Best Answer chosen by Admin (Salesforce Developers) 
Steve :-/Steve :-/

How are you building the formula?  Use the Field Insert Wizard to get the correct field and object references.  If Product is a lookup field it would look something like Product.Name or Product__r.Name

All Answers

Steve :-/Steve :-/

How are you building the formula?  Use the Field Insert Wizard to get the correct field and object references.  If Product is a lookup field it would look something like Product.Name or Product__r.Name

This was selected as the best answer
BretzBretz

I used the drop down list of fields and was able to pull the Product ID field.

 

Thank you so much