Unable to use HYPERLINK() in a Worflow email

teambelair
Participant V

Hi All,

I have the following email body in a Workflow email

which results in this email

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!

Solved Solved
0 13 591
1 ACCEPTED SOLUTION

View solution in original post

13 REPLIES 13

Steve
Participant V

Given this:

3X_e_e_ee05c8e84a3dd6d7b4ebe6b7fdedc8f22cefe854.png

Try this instead of HYPERLINK():

&lt;a href="<<CONCATENATE(...)>>"&gt;<<[Type]>>&lt;/a&gt;

Or:

<a href="<<CONCATENATE(...)>>"><<[Type]>></a>

teambelair
Participant V

Thanks @Steve

I use <a href="<<CONCATENATE(...)>>"><<[Type]>></a> as you suggested and it works nicely. The user doesnโ€™t see the actual url anymore.

However, the generated url for the first link is:
https://mandrillapp.com/track/click/30578143/www.appsheet.com?p=eyJzIjoiVHVaUTFQM0J0M1doWVFBVjdJM2gy...โ€ฆ
Instead of the expected url (see second hyperlink)

I wouldnโ€™t mind as long as it brings the user to the right location but the problem is that the first link doesnโ€™t open the mobile app. It works on the second one.

Any way to keep that exact url for the first one?

Thanks!

I donโ€™t believe so; I think this is a deficiency with AppSheet. support@appsheet.com might have a better answer.

Please use a format as this but of course use your own names etc. but you get the idea.

<a href="<<CONCATENATE(โ€œhttps://www.appsheet.com/start/123456-4cb2-4b95-8af6-984e7301c526?refresh=1&wipe=1",IF([TYPE]=โ€œClassโ€,LINKTOVIEW(โ€œClass Boardโ€),LINKTOVIEW(โ€œCardsโ€)))>>"><<[TYPE]>>

Thanks @Aleksi

The email formatting works but doing so still generates this url below which opens the app in the browser instead of the mobile app.
https://mandrillapp.com/track/click/30578143/www.appsheet.com?p=eyJzIjoiUkEyN2w4REM0aVZVVU1vbnJlSUNF...โ€ฆ

<a href="<<CONCATENATE(โ€œhttps://www.appsheet.com/start/046140da-ddb0-4e9f-9b8b-0e193f08e8b5?refresh=1&wipe=1",IF([Type]="Class", LINKTOROW([Class_Board], "Class Board Detail"), LINKTOROW([Card], "Cards")))>>"><<[Type]>></a>

It sounds that you have set with your device that it will always open it with the browser. I made a quick test and after I have selected โ€œAppsheetโ€ always, it will do open the link from the app. You probably need to clear the setting and then select โ€œAllwaysโ€ for the Appsheet app.

Ok, thatโ€™s strange.

I just want to confirm that using this

Will correctly prompt this on my device

But clicking on your constructed link always opens the browser without any prompt to pick the app

teambelair
Participant V

Looking at the configuration of the mobile apps (Appsheet and white label), I am surprised that your native app can interpret mandrillapp.com as appsheet.com

What do you mean here?

Aleksi was able to get the link that starts with mandrillapp.com prompts his device to open Appsheet. I am surprised since the settings to open the app by default is configured with the โ€œsupported links: www.appsheet.comโ€

Right. So my suspicion is youโ€™re getting the browser because the mandrillapp.com URL in the email is opened by the browser. mandrillapp.com then issues a redirect to go to the app, but because the request is already being handled in the browser, it stays in the browser and you get the in-browser app. The โ€œsupported linksโ€ listed for your app only apply to links opened directly, not to redirects within the browser. Iโ€™m not sure how @Aleksi is able to open an app from mandrillapp.com links in an email.

Thank you @Steve! It works perfectly.

Top Labels in this Space