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!
Given this:
Try this instead of HYPERLINK():
<a href="<<CONCATENATE(...)>>"><<[Type]>></a>
Or:
<a href="<<CONCATENATE(...)>>"><<[Type]>></a>
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=eyJzIjoiVHVaUTFQM0J0M1doWVFBVjdJM2gydXJpTWRnIiwidiI6MSwicCI6IntcInVcIjozMDU3ODE0MyxcInZcIjoxLFwidXJsXCI6XCJodHRwczpcXFwvXFxcL3d3dy5hcHBzaGVldC5jb21cXFwvc3RhcnRcXFwvMDQ2MTQwZGEtZGRiMC00ZTlmLTliOGItMGUxOTNmMDhlOGI1P3V0bV9tZWRpdW09ZW1haWwmdXRtX3NvdXJjZT10cmFuc2FjdGlvbmFsJnV0bV9jYW1wYWlnbj1Xb3JrZmxvdytFbWFpbCNhcHBOYW…
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!
teambelair:
Any way to keep that exact url for the first one?
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=eyJzIjoiUkEyN2w4REM0aVZVVU1vbnJlSUNFRGxNVUVNIiwidiI6MSwicCI6IntcInVcIjozMDU3ODE0MyxcInZcIjoxLFwidXJsXCI6XCJodHRwczpcXFwvXFxcL3d3dy5hcHBzaGVldC5jb21cXFwvc3RhcnRcXFwvMDQ2MTQwZGEtZGRiMC00ZTlmLTliOGItMGUxOTNmMDhlOGI1P3JlZnJlc2g9MSZ3aXBlPTEmdXRtX21lZGl1bT1lbWFpbCZ1dG1fc291cmNlPXRyYW5zYWN0aW9uYWwmdXRtX2NhbXBhaWduPVdvcmtmbG93K0VtYWlsI2NvbnRyb2w9Q2xhc3MlMjBCb2FyZCUyMERldGFpbCZyb3c9XCIsXCJpZFwiOlwiNWFhNjYwMzUyMWM3NGZhN…
<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
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
teambelair:
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.
