Apex Code Development You need to sign in to do that
Don't have an account?
kim_lebicz How do I identify a null value in a picklist
I am trying to create a Validation rule that says if a text field is null and a picklist field is null. I am using the LEN function for the text field which is working well but I am not sure how to determine if a picklist value is null. AND(LEN(S_N_1__c ) = 0, ISPICKVAL( Reason_for_missing_S_N__c), " ") I tried this but it is not working. Thanks in advance. Kim
So I created the following and did not receive any syntax errors but it still doesn't seem to be working.
AND(ISPICKVAL( Reason_for_missing_S_N__c , " ") , LEN(S_N_1__c ) = 0)
Note, there's no space in the string, it should just be "" all by itself.
~ sfdcfox ~
Thanks so much for the reply.
I have made a couple of changes including your suggested fix but it is still not working.
AND(ISPICKVAL( Reason_for_missing_S_N__c , ""), ( $RecordType.Name = "RMA2"), LEN(S_N_1__c ) = 0)
It definately seems to be the picklist part of the formula.