How to use a variable to build a hyperlink in an Email Body Template?

[gcor71]

I have a Bot action to send an email.  It uses an email body template to format the email.  Within the body I have a hyperlink which I want to dynamically construct using a <<[variable]>> to personalise the hyperlink per row.

In the Google Doc email body template, a normal hyperlink is defined with the following URL content: https://docs.google.com/forms/.../viewform?usp=pp_url&entry.15946277=OSM<<[booking_id]>>
The expected result if for the hyperlink to resolve to .../viewform?usp=pp_url&entry.15946277=OSM123456  (were the <<[booking_id]>> = 123456)..

Unlike elsewhere in the template, the <<[variable]>> is does not resolve.  When clicked in the received email, the URL is still .../viewform?usp=pp_url&entry.15946277=OSM<<[booking_id]>>  .

How can I approach this and continue to use the Google Doc with the link URL being fully resolved?  I know I could use an HTML body, but I prefer the control and simplicity of the Google Doc template approach.

Thanks in advance.

[lynchk21]

Are you using:

<<HYPERLINK(“https://docs.google.com/forms/.../viewform?usp=pp_url&entry.15946277=OSM "&[booking_id],"Driver Registration Form")>>

If not, replace the url in the function above with your actual URL and see it it works

[gcor71 · Accepted solution]

Great tip!  After a bit of tweaking, notably the inclusion of a second '&' to concatenate the end of the function correctly, it worked very nicely.  Never occurred to me to bring the << >> outside the complete function like that.

<<HYPERLINK(“https://docs.google.com/forms/.../viewform?usp=pp_url&entry.15946277=”&[id]&,”Driver Registration Form”)>>

Thank you!