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

0 9 1,690
9 REPLIES 9

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.

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=Request... 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?

3X_3_c_3c17ba4e4582f34baa2444fc02ca1a1f1d775210.png

Steve
Participant V

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.

This is very helpful, Thank you!  I don't like how long my Deep Link things end up in my Bot-sent emails. This will allow me make the entire "Click HERE" text bigger & easier to understand what to do. I would love to be able to apply this link to a nice, standard looking button that says "Click here to view record". Is this possible? Thank you!

I suspect it's possible using HTML, but there's no built-in way to do it.

Thanks Steve. It worked.

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.

Top Labels in this Space