Skip to main content

Formula - include URL from long text field (with rich text enabled)

  • December 6, 2022
  • 5 replies
  • 83 views
Paul_Matsushima
Forum|alt.badge.img+8

Hello,

Is it possible to enable the URL from a long text field with rich text enabled (in other words, this field type) to be clicked on in another formula field? In other words, the long text field I have has text within the field linking out to URLs. When that long text field is included in another formula field (for instance, as a concatenation linking the long text field with other fields), the URLs disappear. Is there any way to enable the URLs to be included and clickable in that separate formula field?

Thanks so much!

    5 replies

    Justin_Barrett
    Forum|alt.badge.img+21

    Unfortunately there's no way to extract the URL using a formula field. You could use a script to extract it, but it might be tricky if you have multiple URLs in the same field.

      Paul_Matsushima
      Forum|alt.badge.img+8
      • Paul_Matsushima
      • Author
      • Known Participant
      • December 6, 2022

      Unfortunately there's no way to extract the URL using a formula field. You could use a script to extract it, but it might be tricky if you have multiple URLs in the same field.


      That's a bummer, but makes sense!

      Andrey_Kovalev
      Forum|alt.badge.img+20

      That's a bummer, but makes sense!


      @Paul_Matsushima Hi! I played sometime with regex in a formula field and come so far with the following solution:

      CONCATENATE( REGEX_EXTRACT({Simple text},"(https?:\\/\\/)"), REGEX_EXTRACT({Simple text},"(?:https?:\\/\\/)+([^\\s?]+)") )

      It can extract only the first URL in text. Hope this helps.

      Justin_Barrett
      Forum|alt.badge.img+21

      @Paul_Matsushima Hi! I played sometime with regex in a formula field and come so far with the following solution:

      CONCATENATE( REGEX_EXTRACT({Simple text},"(https?:\\/\\/)"), REGEX_EXTRACT({Simple text},"(?:https?:\\/\\/)+([^\\s?]+)") )

      It can extract only the first URL in text. Hope this helps.


      @Andrey_Kovalev That would work if the URL were exposed from the long text field. However, when using the rich text option to turn text into a clickable link, other formula fields that pull the resulting text only get the text, not the URL.

      Andrey_Kovalev
      Forum|alt.badge.img+20

      @Andrey_Kovalev That would work if the URL were exposed from the long text field. However, when using the rich text option to turn text into a clickable link, other formula fields that pull the resulting text only get the text, not the URL.


      @Justin_Barrett Ahh, got you! I should have read the request more carefully.

      Terms & ConditionsAccessibility statement