Deeplink in email body template

Hello,

I have created and mentioned below deep link to show “Click HERE to view the record”.

Click <a href=’<<CONCATENATE(‘https://www.appsheet.com/start/bb20fe67-3933-475b-b4d6-2f1b5e8ea245#NFARequest-1586302&table=Requests for Approver 3rd&page=detail&row=’,[NFA Request No.])>>’>HERE to view the record.

But, in the email body it shows as below.

Please help solve the above.
Thanks,
Rjan

Unfortunately you cannot use your own HTML code in a Google Doc template.

The following 3 articles should get you what you need:

Also, you might need to use “%20” in place of any spaces in your view or table names within your deep link URL.

3 Likes

Hello Marc_Dillon,

Thanks for the help, but I could not solve it.

Below is what I mentioned in the email body template.

Click HYPERLINK(“<<ENCODEURL(CONCATENATE(‘https://www.appsheet.com/start/bb20fe67-3933-475b-b4d6-2f1b5e8ea245#NFARequest-1586302&table=Requests for Approver&page=detail&row=’,[NFA Request No.]))>>”, “HERE”):
to view the record.

And the below is how it appears in the mail.

Can you please help solve this issue?

Thanks,
Rajan

Try the following change?

image

1 Like

Try:

Click <<HYPERLINK(CONCATENATE("https://www.appsheet.com/start/bb20fe67-3933-475b-b4d6-2f1b5e8ea245", "#NFARequest-1586302", "&table=", ENCODEURL("Requests for Approver"), "&page=detail", "&row=", ENCODEURL([NFA Request No.])), “HERE”)>> to view the record.
3 Likes

Thanks Steve. It worked.

1 Like

Hello,

How can below highlighted be made dynamic? Why I want because, I want to set up a production and dev/qa application. At present the entire content in the hyperlink is hard coded. I have copied the app for dev/qa with different name and when the mail fires, it should contain details for dev/qa app.

Thanks.
Rajan

You can hold the different values for the highlighted section in some column of some table in your app. Then you can reference it in the expression based on an IF() or SWITCH() or similar.

1 Like