Help with Field Validation Logic
I have a custom check box field (sync to marketo) on my contact form. When it gets 'checked' I need to make sure that the values of 3 other fields are set as per below:
- Account Name is not null
- email address is not null
- inactive check box is not = 'Y'
I want to prompt the user if any of these 3 conditions are not met before allowing them to save the record. I created this formula but it only seems to work when my custom field check box is blank or null and I check it. If I do the opposite and 'uncheck' it, the validation alert still gets triggered. am I missing something?