Hyperlink in email body not working

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?

1 19 3,071
19 REPLIES 19

TyAlevizos
Participant V

Hi.

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

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โ€)

Something like this, then?

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

getting an error message with that

Please use with your email bodyโ€ฆ

TyAlevizos
Participant V

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>

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.

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

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

I end up using the Worflow email which offers more options

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.

Hyperlinks are not valid in Text values.

3X_e_d_ed606152a3ef3ad4fb52c5d9df448632219a0343.png

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โ€

is there anyone who solved this problem?

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.

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.

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

Chetty
Participant III

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!

You saved me, ty very much

Top Labels in this Space