Hyperlink() not returning clickable text

[ellac]

Hello, 

I've created an automation rule that will send an email with  a link to the request view. The link is correct but it's returning the URL rather than hyperlinking clickable text. 

I have this written in the email body: 

<<HYPERLINK(("https://www.appsheet.com/start/c35957ac-aea4-4425-b65f-c1b8eb95843e" & LINKTOROW([REQUEST ID],"CONCIERGE_Detail")),"CONCIERGE REQUEST DETAILS")>>

Result: 

Goal: hyperlink CONCIERGE REQUEST DETAILS

---

I also have a formula that I tried to turn into a hyperlink, but again it's providing the URL but not the hyperlink clickable text. 

Formula:

HYPERLINK(
CONCATENATE(
"https://roveconcepts.freshdesk.com/a/tickets/",
ENCODEURL([TICKET NUMBER])
),
ENCODEURL([TICKET NUMBER])
)

Goal: hyperlink inputted [TICKET NUMBER]

[dbaum]

Try just using an HTML anchor element with a hyperlink reference--maybe along the lines of:

<a href="&lt;&lt;CONCATENATE(&quot;https://www.appsheet.com/start/c35957ac-aea4-4425-b65f-c1b8eb95843e&quot;,LINKTOROW([REQUEST ID],&quot;CONCIERGE_Detail&quot;))&gt;&gt;">CONCIERGE REQUEST DETAILS</a>

[ellac]

Hi @dbaum, thanks for your reply! 

Can I copy and paste that code directly into the email body? 

It's now returning the text but the text is not hyperlinked:

[dbaum]

---

@ellac wrote:

directly into the email body

---

I definitely create hyperlinks in the body of emails using HTML <a> elements in that property.

---

@ellac wrote:

Can I copy and paste that code

---

In the "Send an email" task's Email Body property, I don't have a good handle on when to use explicit characters (e.g., ", <, >) versus HTML entities (e.g., &quot;, &lt;, &gt;). Try fiddling with those.

[Suvrutt_Gurjar]

Could you try creating VCs called say [CONCIERGE Detail Link]  and [TICKET NUMBER Link] with expressions that you have used.

So [CONCIERGE Detail Link] contains

<<HYPERLINK(("https://www.appsheet.com/start/c35957ac-aea4-4425-b65f-c1b8eb95843e" & LINKTOROW([REQUEST ID],"CONCIERGE_Detail")),"CONCIERGE REQUEST DETAILS")>>

and 

[TICKET NUMBER Link] contains

HYPERLINK(
CONCATENATE(
"https://roveconcepts.freshdesk.com/a/tickets/",
ENCODEURL([TICKET NUMBER])
),
ENCODEURL([TICKET NUMBER])
)

Then in the email template , you could use expressions

<<[TICKET NUMBER Link]>> and 

<<[CONCIERGE Detail Link]>>

[ellac]

Hi @Suvrutt_Gurjar thanks for your reply.

I tried adding a column and a virtual column with the formulas and applying the expressions in the email body, but it's still just giving the link as opposed to converting to clickable text. 

[Suvrutt_Gurjar]

Please check if the highlighted setting is below is on. It works for me with that setting for the VC.

Email received with the hyperlinked text:

[ellac]

Hi @Suvrutt_Gurjar 

Thanks, that worked for the ticket number URL. The ticket number URL is an actual column and is displaying with the hyperlinked text in my details view. 

The Concierge Details link is still showing the full URL. I used a virtual column and I'm trying to display it in the body of my email. I'm not sure why this one wouldn't work though if your example worked with a virtual column in your email reply.