Embed hyperlink into formula

[chri3s]

Hi,

I'm using CR 10.

I'm trying to create a formula the concatenates several items so it looks like:
"Dear Dr." & {DrName} & "You have" & {NumberOfOrders} & "to sign. Please sign them by logging into" &
<A HREF="httsp://mdportal.sdhospice.org/Misys.Homecare.Physician.Portal/login.aspx?ReturnUrl=%2fMisys.Homecare.Physician.Portal%2fdefault.aspx">the Physician Portal</A> (Misspelled "https" in my hyperlink on purpose to get it to not display in this thread as a link)

I can't figure out how to embed the hyperlink into the formula. I read all 116 "hyperlink" threads on this forum but still can't get it. I can get the whole messageto be a hyperlink but don't want that. The best I can get is the message with the hyperlink text as a string; can't get just that section to be a hyperlink displayed as 'the Physician Portal.'


I could create a text object and format it as a hyperlink no problem so the message could be set to say something like "logging into the link below" followed by the text object but I'd like it as part of the message if possible.

I'd be grateful for any suggestions.

TIA

Chris

 

[lbass]

I think you have to use multiple formulas--text up to hyperlink = formula 1, hyperlinked formula = formula 2, subsequent text = formula 3. You can connect them to guidelines, format them with "tight horizontal" and also potentially use the "relative positions" feature in the section expert.

-LB