Forum Discussion

EthanD's avatar
EthanD
Qrew Member
2 years ago

Formula function for escaping text in html?

Hi all,

We are taking some input from users as plain text. I'd like to use a formula rich text to style it up a bit.

However, concatenating plain text into HTML requires replacing angle brackets < and > with &lt; and &gt; and ampersands & with &amp;.

I can do this myself with multiple calls to SearchAndReplace. However I was wondering if Quickbase would consider providing a function called "Escape" that would handle all of this in one go.

It would be especially great if links and email addresses could automatically become <a> tags, the way they do when you look at a plain text field normally. When concatenating these into the rich text, they don't automatically parse as links.

Has anybody else dealt with this?

Thanks.
No RepliesBe the first to reply