Hello,
I have created and mentioned below deep link to show “Click HERE to view the record”.
Click <a href=’<<CONCATENATE(‘Login - AppSheet 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.
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:
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.
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.
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.
I found this on the internet, using @Steve 's Formula and then applying these (marked red).
Check it out <a href=<>>HERE.
Creates this (in image below)
I hope this helps anyone.
Better late than never
