1

I've a workflow field update that's updating a rich text field type. I've tried using BR() to insert line breaks but I don't see that line break when viewing the standard detail page for the record.

My field update formula currently is:

'Dear, ' + Assigned_To__r.Full_Name__c + 
BR() + 
'Lorem Ipsum dolar sit amet' + 
'\r\n' + 
'Thanks, ' + Owner:User.Full_Name__c

The BR() does nothing and the \r\n is left as literal.

What might I be missing? What can I try?

2

You can use standard html tags like <br> tags.

e.g.

'Dear, ' + Assigned_To__r.Full_Name__c + 
'<br/>' + 
'Lorem Ipsum dolar sit amet' + 
'\r\n' + 
'Thanks, ' + Owner:User.Full_Name__c
| improve this answer | |
  • 1
    Thanks Christian. Makes me wonder what the BR() is for then? – mrBlaQ Sep 18 '14 at 20:35
  • 1
    The br() function is used in standard formula fields.. (I think that they disallowed pure html in formula half a year ago.) – Christian Deckert Sep 18 '14 at 20:38
0
"Dear, " & Assigned_To__r.Full_Name__c & 
BR() & 
"Lorem Ipsum dolar sit amet" &
BR() & 
"Thanks, " & Owner:User.Full_Name__c
| improve this answer | |
-1

For Text Formulas the "&" is the concatenate operator - not the + sign

| improve this answer | |
  • Well, you're right. But, this should've been a comment on my Question as it's not an answer to my main issue. Thanks though. – mrBlaQ Sep 18 '14 at 20:35

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.