Forum Discussion

DanielleW's avatar
DanielleW
Qrew Member
3 years ago

Converting Multi-Line Text to Formula - Rich Text, Issue with Line Breaks

I have read every single post on this board regarding this subject, and have tried every suggestion and nothing is working. Please help! I'm trying to take a user input Multi-Line Text field and co...
Formulas and functions
BrittanyScheid's avatar
BrittanyScheid
Qrew Cadet
3 months ago

Hi all,

Thanks for this post as it helped me find a solution! With the new function URLDecode, I was able to use some of what was mentioned here to get the line breaks to appear in a formula-rich text field that was pulling in the value from a multi-line text field. Here's what I did: use URL Encode, then replace the "%0A" with "<br>", and then use the URL Decode function.
URLDecode(SearchAndReplace(URLEncode([Status - Required Action and Documentation]),"%0A","<br>"))