Solved: How to use a variable to build a hyperlink in an E... - Page 2

gcor71 · 03-04-2024 04:42 PM

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.

gcor71

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!

View solution in original post

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