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
LuvaraLuvara 

"Null" text fields for Validation Rules

Here's my scenario - I have a picklist field, with a couple of values - "Approved", "Not Approved". I also have a text field that I would like the users to be forced to fill out when the value is "Not Approved".

Basically, I'd like it to see that the field is "Not Approved" and then if the "Reason Not Approved" field is blank, force them to fill it out. I know that a text field is never "Null" or empty, and that means I can't use the "ISNULL" function to force a user to fill out a field when it's blank. Does anyone have a suggestion on how to accomplish this?

Thanks,

Chris

NPMNPM

I believe for Text fields you can check for null by checking for ""

I think your rule would be something like this (not tested):

AND(ISPICKVAL( Pickfield_name , "Not Approved"),Text_field name = "")

LuvaraLuvara
Duh.. that worked.

Thanks.

Chris