+ Start a Discussion
lsvslsvs 

Validation Rule Formula Needed! Please help!

I am new to Salesforce and need to create the following validation rule formula.  The formula requires a value in the case comments that matches the account name related to the case.  (i.e. if the case is assigned to an account named ABC, the user must enter the phrase "ABC" in the case comments for the entry to be valid.)

 

Please help!

arunkarunk

Hi,

 

Don't think this can be done using validation rule on Case.

There is functionality to add a trigger on case comments.

Setup>App Setup>Customize>Cases>Case Comments> Triggers.

You will have to  create a before insert trigger and validate stuff in that.

 

 

Regards,

Arun 

lsvslsvs

Thanks for your feedback but unfortunately I have the Enterprise Edition which does not allow me to add Apex triggers. 

 

Any other ideas?

MachhiMachhi

Hi,

 

I am using description field to validate whether it contains account name or not.

 

Write a validation rule with Error condition formula as below: 

 

CONTAINS(IF(ISBLANK(Description),' ',Description), ' ' & Account.Name & ' ') == false

Hope this will help.

 

Regards,

Chandrakant M

fdsgkgreamfabofdsgkgreamfabo

Validation are not avaiable for Case comment.

Only Apex trigger can be used here.

I'm surprised that Apex code is not an option for Entreprise Edition as it's available for Developer, Unlimited and Entreprise Edition.