function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

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 ))

Message Edited by AudraNYC on 10-19-200706:12 PM

Message Edited by AudraNYC on 10-19-200706:12 PM

Harry JamesHarry James

Text fields are never null.  Try:

LEN (Description) = 0