Discussions

 View Only

Formula function for escaping text in html?

  • 1.  Formula function for escaping text in html?

    Posted 07-28-2022 16:17
    Edited by Ethan D 07-28-2022 16:18
    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.