You need to sign in to do that
Don't have an account?
justajayne
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 :)
Try:
AND(ISPICKVAL( Subject ,"Call"), LEN( Call_End_Time__c )=0)
Also, the field type for Subject must be a picklist (not a multi-select picklist) -- it may be that this is a text field. In addition, the value for Call_End_Time__c must be a text string, not a number. If this field is a number, the LEN command does not work and will return an error. If you verify these rules, you'll get zero errors with the syntax checker. I tried it to confirm no errors.
Message Edited by glowitz on 05-21-2008 09:35 PM
What easy workaround do you have?
You need to set up a new object. In that object, you need to have a field uwhich mirrors the multi select picklist (msp). You then need a 'type' field which will reference a name for the msp. Finally, you need some kind of way to reveal the contents - e.g. a text fielld, or checkboxes.
Say you're doing a msp you name RGB (red, green, blue). You might have 3 checkboxes, or a text field named contents__c.
Hard is:
Knowing you are about to exceed governor limits, recording that fact in a custom object, and having other pages do the work so as not to degrade the user experience;
Creating a 3 dimensional virtual reality representation of data that runs fast and lets users 'fly' around looking for 'interesting' patterns;
Letting a user control that experience with a headband that reads neural activity (look for Neural Impulse Actuator on Amazon.com);
Communicating / illustrating all this so it looks (and is) not so hard.
I'm thinking of doing a U-Tube video & doing an underground presentation at Dreamforce. What do you think?