How to embed link in Automation email as you would in Actions Send an email

AppSheet AppSheet Q&A
1

Hi community

In my app I created a send email action, which had a link in the body that looks like this.

EncodeURL(concatenate("Please see below link for the details regarding the invoice that needs to be generated the Marketing department.

Please help me out with this marketing request? " , “https://www.appsheet.com/start/3c0f6f8a-1b7d-4f44-af69-0e9203f68a27#appName=WIP20092021-2892034&group=%5B%7B%22Column%22%3A%22WIP_Store%22%2C%22Order%22%3A%22Ascending%22%7D%5D&page=detail&row=”,
[WIP_ID],
“&sort=%5B%7B%22Column%22%3A%22WIP_Date_in%22%2C%22Order%22%3A%22Descending%22%7D%5D&table=WIP&view=WIP_Detail”
))

I tried to do the same thing with an automation email but it didn’t give me the same result.

So I tried this…

<<EncodeURL(concatenate("Please see below link for the details regarding the invoice that needs to be generated the Marketing department.

Please help me out with this marketing request? " , “https://www.appsheet.com/start/3c0f6f8a-1b7d-4f44-af69-0e9203f68a27#appName=WIP20092021-2892034&group=%5B%7B%22Column%22%3A%22WIP_Store%22%2C%22Order%22%3A%22Ascending%22%7D%5D&page=detail&row=”,
[WIP_ID],
“&sort=%5B%7B%22Column%22%3A%22WIP_Date_in%22%2C%22Order%22%3A%22Descending%22%7D%5D&table=WIP&view=WIP_Detail”
))>>

Neither is working. Is there something else I can try?

2

The email returns this, rather than the link.

“https%3A%2F%2Fwww.appsheet.com%2Fstart%2F3c0f6f8a-1b7d-4f44-af69-0e9203f68a27%23appName%3DWIP20092021-2892034%26group%3D%255B%257B%2522Column%2522%253A%2522WIP_Store%2522%252C%2522Order%2522%253A%2522Ascending%2522%257D%255D%26page%3Ddetail%26row%3Dc542e96a%26sort%3D%255B%257B%2522Column%2522%253A%2522WIP_Date_in%2522%252C%2522Order%2522%253A%2522Descending%2522%257D%255D%26table%3DWIP%26view%3DWIP_Detail”

3

If you create a link in the body of an email like this in the Behaviour section under External: Start an email it is necessary to use ENCODEURL at the beginning of the link.

If you try and do the same thing in Automation in the body of an email it will return what I was getting above.

So to get it right in Automations I had to remove the ENCODEURL.

1 Like