[SalesForce] Validation Rule Only Fires If Field NOT Blank

I am attempting to create a validation rule on a field that ensures a time is formatted correctly. This is only if the user enters a time, whereas if left blank, one is automatically generated and that is fine, thus the validation rule should not fire.

Currently I have this, which isn't working (Rule fires no matter what):

( NOT(REGEX(  Presentation_Start_Time__c  , "[0-1]?[0-9]:[0-5][0-9] [A|P]M")) || NOT(ISBLANK(Presentation_End_Time__c)) ) 
&& 
( NOT(REGEX(  Presentation_End_Time__c  , "[0-1]?[0-9]:[0-5][0-9] [A|P]M")) ||  NOT(ISBLANK(Presentation_End_Time__c)) )

Best Answer

You seem to have misunderstood validation rules. If they evaluate to true then they fire and block saving the record.

So try this:

AND(NOT(ISBLANK(Presentation_End_Time__c)),NOT(REGEX(  Presentation_Start_Time__c  , "[0-1]?[0-9]:[0-5][0-9] [A|P]M")))

Related Solutions

[SalesForce] Validation Rules: If the status is change

Here is I able to solve the above validation. I hope it will help somebody who is looking.

AND(ISPICKVAL(Status__c, "Completed")
,
OR(
 ISBLANK(Completion_Date__c),
 ISBLANK(Last_Completion_Date__c) //you can multiple fields just by adding here....   
))

[SalesForce] Validation Rule on Phone Field to allow only Numbers or Blank

Ten digit numbers are automatically reformatted as '(###) ###-####', which means that ISNUMBER will return false (because it has spaces, parentheses, and a hyphen). Also, when you see the documentation, you'll see it also supports numbers like 2e2 or 123.123, which are both numbers, but not phone numbers.

So, what you're probably looking for, for a start, is two specific patterns that will match US and other numbers:

AND(NOT(REGEX(Phone,'\\d*')), NOT(REGEX(Phone,'\\(\\d{3}\\) \\d{3}-\\d{4}')))

You'll want to experiment with REGEX to determine which rule(s) you'd like to follow.

Best Answer

Related Solutions

[SalesForce] Validation Rules: If the status is change

[SalesForce] Validation Rule on Phone Field to allow only Numbers or Blank

Related Topic