You need to sign in to do that
Don't have an account?
Luvara
"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
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
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 = "")
Thanks.
Chris