Sign Up ›
  • glowitz
  • NEWBIE
  • 0 Points
  • Member since 2005
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 5
    Questions
  • 4
    Replies
7 replies

ispickval function - error received

I am trying the use the following validation rule, but I keep receiving an error message:
 

AND(ISPICKVAL( Subject ,"Call"),LEN( Call_End_Time__c )=0)

 

The error I am receiving states the following:

Error: Incorrect parameter for function ISPICKVAL(). Expected Picklist, received Text

 

 

The field Subject is a picklist and when "Call" is chosen I would like to be sure a value for Call End time is entered. It woud be greatly appreciated if someone could assist me :)

8 replies

HELP! - Forcing Uppercase on Field Entry Using Validations & Formulas

I have professional edition (so can't use Apex triggers) and was looking for a simple way to force all caps (uppercase) on a form field entry using validation rules. For example, if we want all our account names to be uppercase, how can this be formatted automatically?

Ideally this would work without any error messages -- it would just reformat it upon "saving" it. Also, will this work when using the "web to lead" or "web to case" form?
 
We want this to be handled directly in SFDC, not in our client or server-side application.

Thanks in advance for tips / recommended code or formula. I posted a similar request in the Ajax forum without realizing this was a more appropriate forum for my request. Thanks in advance for your help.