0

I have a Text Area field, which I am updating using a formula from Process Builder. I want to add a new line and tried to do so using '\n' and '\r\n' but none of these work.

Here is the formula used:

[CampaignMember].Secondary_Status_2__c + '\r\n' + TEXT([CampaignMember].Status)

1
  • 1
    Is the text area a rich text area? Nov 19, 2015 at 16:01

2 Answers 2

2

have you tried using BR() in your formula?

Documentation

2
  • Thanks, but it didn't work even. If I use BR(), then it adds the string BR_ENCODED
    – MKT
    Nov 20, 2015 at 11:20
  • Mentioning again that I am trying to update the field from Process Builder.
    – MKT
    Nov 20, 2015 at 11:22
0

Check this super hack out, it should fix your problem. https://automationchampion.com/2015/08/06/getting-started-with-process-builder-part-40-adding-a-line-break-in-process-builder-formula/#comment-3963

3
  • what a hack! a custom label value of a line break wrapped by text and then the wrapped text removed by the SUBSITUTE(..). I love it
    – cropredy
    Jun 2, 2016 at 0:27
  • 2
    Please don't limit your anwers to an URL only. Include the actual in your answer so that if the external source may go offline we do not lose the information. Mind still adding it to your answer ? Jun 6, 2016 at 8:06
  • Yes please provide at least the broad strokes... my company is behind a firewall and I don't have access to blogs and personal sites like this one =/
    – smohyee
    Aug 1, 2018 at 18:22

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .