1

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

  1. if the description field is blank

  2. User edits and saves the record

  3. 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 )))
1

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 )))
  • That did not work for blank spaces at the beginning of the text.(eventhough description field is blank) – gopal1007 Aug 6 '18 at 12:41
  • updated my answer which worked for me – Santanu Boral Aug 6 '18 at 12:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.