Hyperlink in email body not working

[McKenna_Killion]

I have a compose email action. Within the body I am trying to use HYPERLINK but when the email opens it only show the actually link rather than the words I am wanting used. Is this a bug?

[TyAlevizos]

Hi.

Take a look at Phil’s answer in this previous thread. Does this possibly apply to your situation here?

Hyperlink in workflow template. Need a help ... Questions

@tsuji_koichi @RezaRaoofi Try including this in the template: HYPERLINK(CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=YourApp-54321&tableName=YourTableName&resi...”,TEXT([Image Field Name])), ‘My Photo Link’) I added topic “Hyperlink Expressions” in this article to described how to do this. See https://help.appsheet.com/behavior/workflow-sending-email/template-variables

[McKenna_Killion]

I don’t think so… I’m not trying to use any images or even any columns. I’m just wanting HYPERLINK(“link”, “Click Here”)

[TyAlevizos]

Something like this, then?

<<HYPERLINK("https://www.appsheet.com", "AppSheet home page")>>

[McKenna_Killion]

getting an error message with that

[Aleksi]

Please use with your email body…

[TyAlevizos]

yes, sorry I was overthinking your question, @Aleksi is right, if you use the “body” field then you can insert various and regular html, e.g. the following chunk of html works fine… best, -Ty

 <table border="0" width="100%" cellpadding="0" cellspacing="0" align="center" bgcolor="#42bde7" style="text-align: left;">
<tr valign="top" width="100%">
<td valign="top">     

<img src="https://www.appsheet.com/Content/img/logo/NewLogo/600px/Reverse%20color%20-%20White%20-%20Horizontal.png" alt="alt text" width="130" border="0" />
<br/><br/>

<h3>Welcome to this MOTD!! :)</h3> 

<br/>            
<br/>Here's a random picture which will rotate daily:
     
<br/><img src="<<[Random Image]>>" alt="alt text" height="185" width="307" border="0" />
<br/>
<ul>
<li><a href="https://www.appsheet.com" style="color: #ffffff;font-family: sans-serif;">AppSheet</a></li>
<li><a href="https://www.google.com" style="color: #ffffff;font-family: sans-serif;">Google Inc.</a></li>

<p> more info goes here... </p>
</td>
</tr>
</table>

[McKenna_Killion]

This is a compose email action - not a send email workflow. It seems to me that these have to be done within the expression builder and using HTML does not work.

[teambelair]

@McKenna_Killion Did you figure it out? I am also trying to use the HYPERLINK() in an action of type Send Email.

[McKenna_Killion]

No I was not ever able to get it to work.

[teambelair]

I end up using the Worflow email which offers more options

Unable to use HYPERLINK() in a Worflow email Questions

Hi All, I have the following email body in a Workflow email [2020-10-04_21-45-25] which results in this email [2020-10-04_21-46-44] The second argument of HYPERLINK() is not used and the entire url is diplayed instead. Also, is there a better way to debug the email body instead of having to test it in the app? Thank you!

[micahj]

It appears that most basic utilizations of HYPERLINK() in regards to email notifications/actions/workflow are bugged out/nonfunctional.

Even with a valid expression…

You will always get plain text in your output.

Looks like a major bug for this feature.

[Steve]

Hyperlinks are not valid in Text values.

[micahj]

Granted, now that we’re indicating that “text” means “uses and generates raw text elements only” and not “enter your text here”. Vague/unclear labeling from my perspective.

It’s confusing to the user on several different levels.

1. HYPERLINK() throws no error message to the user while being used in this section. If email body can only ever generate text, and never any hyperlinks, why is it allowed as part of the expression?

2. The existing documentation on email templates, although pertaining to Workflow triggered email messages in this case… implies to the user that the same capabilities to send images, links and utilize expressions pertains also to the action section email template body. Trick is, it doesn’t and that isn’t explained in the documentation.

Just feels like email bodies should work functionally the same within workflow and action triggers. This wouldn’t limit the app developer from being able to develop a workflow where a user clicks, and an email with a link is sent.

Basically, this functionality of “click and send a link” is now limited to only “click and send raw text or unclickable links”

[Arvie_Jongko]

is there anyone who solved this problem?

[Tim_Swackhammer]

I would be curious as well. When using the HYPERLINK expression in an email bot, it will send a functioning link, but it will not replace the full link text with the hyperlink text that I provide in the formula.

[jthurston]

I agree with Micah that this is confusing. If an explanation of this limitation could be added to the help article it would be very helpful.

[Koichi_Tsuji]

Hyperlink from email body or ouput (pdf etc) is really tricky with AppSheet.

[Chetty]

Hi @McKenna_Killion , I don't know if you ever found a solution to this but I had the same issue and got around it using a bit of html instead of the Hyperlink function. Just insert the below into your email template body where you need the link to appear.

Click <a href="https://www.bbc.co.uk">here</a> to take a look at this website

In the email it should appear as 'Click here to take a look at this website' with the word 'here' being your hyperlink. Obviously you just need to change your url and the word you want to appear as the link.

Hope it works for you!

[Aoistar]

You saved me, ty very much