You need to sign in to do that
Don't have an account?
AudraNYC
Validation rule on Activity or Event Type field
On Events, we have picklist options in the Type field that allow someone to mark the appointment as a particular type of sales call ("Sales Call: Face-to-Face" ). If they pick this particular type, we need them to fill out more information. To solve this, I'm trying to say, if the type is = "Sales Call: Face-to-Face" , then description and name fields are required.
Problem is, when I go in to create the formula, Type is not an option. I tried using "Call Type", which is not in the list, but also doesn't throw out a syntax error, the validation just doesn't work. It let's me save and does not show me the error.
AND(ISPICKVAL( CallType, "Sales Call: Face-to-Face" ),
ISNULL( Description ))
Problem is, when I go in to create the formula, Type is not an option. I tried using "Call Type", which is not in the list, but also doesn't throw out a syntax error, the validation just doesn't work. It let's me save and does not show me the error.
AND(ISPICKVAL( CallType, "Sales Call: Face-to-Face" ),
ISNULL( Description ))
Message Edited by AudraNYC on 10-19-200706:12 PM
Message Edited by AudraNYC on 10-19-200706:12 PM
Text fields are never null. Try:
LEN (Description) = 0