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
nickfs92840nickfs92840 

Validation Rule Help


Need help on creating a validation rule for a user to enter a % digit into the "Prior HEOS Rate" field when HEOS selection is "Improvement" and Exact Rates selection is "No", . When these two selections are made and user leaves "Prior HEOS Rate" blank and tries to save the record, it should error out and force the user to enter a % into the "Prior HEOS Rate" field.

 

Here are the API Names and field types:

 
- Exact_Rates__c            (picklist)

- HEOS__c                        (picklist)

- Prior_HEOS_Rate__c  (% field)

 

 

Thanks!!!!

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

I dunno why I continue to help you after all the beer you owe me... (sigh)

 

 

AND(
ISPICKVAL(Exact_Rates__c, "No"),
ISPICKVAL(HEOS__c, "Improvement"),
ISBLANK(Prior_HEOS_Rate__C))

 

So we finish the eighteenth and he's gonna stiff me. And I say, "Hey, Lama, hey, how about a little something, you know, for the effort, you know." And he says, "Oh, uh, there won't be any money, but when you die, on your deathbed, you will receive total consciousness." So I got that goin' for me, which is nice. 

 

All Answers

Steve :-/Steve :-/

I dunno why I continue to help you after all the beer you owe me... (sigh)

 

 

AND(
ISPICKVAL(Exact_Rates__c, "No"),
ISPICKVAL(HEOS__c, "Improvement"),
ISBLANK(Prior_HEOS_Rate__C))

 

So we finish the eighteenth and he's gonna stiff me. And I say, "Hey, Lama, hey, how about a little something, you know, for the effort, you know." And he says, "Oh, uh, there won't be any money, but when you die, on your deathbed, you will receive total consciousness." So I got that goin' for me, which is nice. 

 

This was selected as the best answer
nickfs92840nickfs92840

haha, yes! your awesome!

 

Where do I send the beer too??? lol
Steve :-/Steve :-/

If you're going to Dreamforce you can buy me a Pliny the Elder (or two)