Forum Discussion

ShalomEguale's avatar
ShalomEguale
Qrew Member
8 days ago
Solved

Embed hyperlink in Formula Rich Text field

Hi,  I have a rich text formula field with an IF function to display specific text when a criteria is met. I want to add a link to a file in between the text output that opens on a different window....
  • MarkShnier__You's avatar
    8 days ago

    The generic syntax for a Rich Text Hyperlink is this:

    "<a href=" & $URL & ">" & $Words & "</a>"

    so if you had a URL type field to store the link you could do

    var text Words = "PrioritySites";

    var text URL = [My URL field];

    var text Hyperlink = "<a href=" & $URL & ">" & $Words & "</a>";

    If ([Platform] = "A", "Complete all tasks assigned for " & $Hyperlink & " once every 2 months", "No action necessary for this year")