Apex Code Development You need to sign in to do that
Don't have an account?
footprint_nina If 1 field is populated, a related field cannot be empty
Hi,
I am trying to create a validation rule that says if the Payment Type is a Check, then the fields Check Date and Check Number cannot be empty. this is what i have so far, but i keep getting an error message.
AND(
NOT( NFG__Payment_Type__c, "Check"),
ISBLANK( Check_Number__c ))
Hi Nina,
What are the datatypes of the fields in your formula? (Text, Number, Currency, Picklist, Multi-Picklist, Date, Date/Time, etc.)
If your Payment Type field is a Picklist, then something like this should work
AND( ISPICKVAL(PaymentType Picklist_Field, "Check"), OR( LEN(CheckNumber Text_Field) < 1, ISNULL(CheckDate Date_Field)))