[SalesForce] Validation rule not firing if there are empty spaces in Long text area field

I have a validation rule that should fire whenever there is a value on field 'A' and the 'description' field Long Text Area(32000)) of case object is left blank.

This rule fires for manual cases but when case is created via email to case and

if the description field is blank
User edits and saves the record
due to some blank space at the start of the description field, the rule does not fire. Seems like some empty space.

please help.

Validation rule…

(
    (TRIM(Description ) == '') 
    ||  LEN(TRIM(Description ))  = 0
)
&& NOT(ISBLANK(Text( A__c )))

Best Answer

You should use ISBLANK() along with TRIM() function to check the empty spaces or blank.

(ISBLANK(Description) 
|| LEN(TRIM(Description)) =0 )  
&& NOT(ISBLANK(Text( A__c )))

Related Solutions

[SalesForce] Validation rule on a text field based on Role

I don't know if this is the answer, but try:

AND( ISBLANK(REP_Customer_Representative__r.Id), 
$UserRole.Name = 'Member_PA' )

I seem to recall the validation rules needing to look up a value on the parent (i.e. REP_Customer_Representative__r.Id), not just where there is a value in that field itself.

Let us know if this works... or not.

[SalesForce] Validation Rule Only Fires If Field NOT Blank

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")))

Best Answer

Related Solutions

[SalesForce] Validation rule on a text field based on Role

[SalesForce] Validation Rule Only Fires If Field NOT Blank

Related Topic