Forum Discussion

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

DanielleW

Qrew Member

Thank you to all who messaged me privately as well as Prashant for responding here.

We were able to find a solution, but it's hugely complicated. We took the Multi-Line Text field and in a rich text field, we were able to URL Encode, and then SearchAndReplace for each special character the user might use in their inputs.

Moving forward, we are going to streamline the input process to make this much easier.

------------------------------
Danielle W
------------------------------

MarkShnier__You

Qrew Legend

3 years ago

Danielle, are you able to post your final resolution? I see tat you would have had to do successive SeachAndReplace operations for every special character to "Un-URLEncode" them.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------