Ability to remove line breaks in formula fields - Ideas - Salesforce Trailblazer Community
Trailblazer Community

All Ideas

Idea Details

Post an Idea
2,870  Points
Idea has been posted. Give it an upvote or downvote.

Ability to remove line breaks in formula fields

Not Categorized

Right now you cannot use a street address or any other text area in a hyperlink formula field because it will break if there is more than one line in the formula. The result is a formula result that looks like a bad coding error: _HL_ENCODED_<link>_HL_ENCODED This should actually be considered a bug in salesforce, but they consider it "expected behavior". All we need is a simple way to remove line breaks such as SUBSTITUTE(Street,BR(),""). Or you could handle it the same way it is done in the custom links. If it's two lines, just remove the line break automatically!

Merge Idea · Flag

  • Upvotes
  • Downvotes



from AppExchange

Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.