Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 12, 2017 08:45 PM
I want to generate HTML code for a link so I can merge a URL into an email. So I need something like:
“<a href=” &""" & {Article URL}& “”" & “>article”
But this doesn’t work. Is there a way to ensure that the formula can produce a "?
Solved! Go to Solution.
Jul 06, 2020 03:06 PM
You can also use \"
to include quotation mark to the formula. For example, if you’d like to add quotes around Name
field when concatenating, you can use Concatenate(SomeField, "\"", Name, "\"").
Mar 14, 2017 07:40 AM
well I found a solution but it ain’t pretty.
I created a field named “quote”, then filled all the records with ", then used concatenate. worked like a charm.
Mar 14, 2017 08:58 AM
Can you try “”" ? Same for ‘’’. You can also do “’” (double quotes around a single quote) and ‘"’(single around double), but those are less general.
Mar 14, 2017 09:13 AM
wow, nice! much easier than my solution ^^
Mar 14, 2017 03:21 PM
Thanks for those ingenious solutions. I like your workaround Klaus, but Alexander’s code looks the simpler. It’s good to have a back stop.
Apr 16, 2018 12:37 AM
Those don’t seem to work for me. I had to back to creating a “quote” field and concatenating it.
Apr 16, 2018 09:26 AM
I had a similar issue, I found a support about a bug around this. I ended up putting quotes around my link text and using:
"<a href="&{URL}&">link here</a>"
Apr 18, 2018 11:48 PM
That’s odd.
In tests, both of these worked:
'<a href="'&URL&'">Click here</a>'
"<a href=\""&URL&"\">Click here</a>"
Because of @Chester_McLaughlin’s bug report from a while back, I tested using a lookup field and a single-select value for {URL}
, and both worked, as well. (I also embedded a double quote in the middle of {URL}
— an impossibility, I know — to test Chester’s scenario, and the formula functioned properly.)
Anyone still having problems with this, could you post a copy of the formula that failed? (Enclose the code in backticks like this mark here ` or precede it on a new line with 4 spaces to make sure the forum doesn’t reformat your quotation marks.)
Thanks.
Apr 19, 2018 12:36 AM
Thanks. That works well now.
Jun 09, 2020 02:04 PM
Ugh, can’t seem to get this to work. :grimacing: I have tried all of the above.
The most recent attempt is:
'<a href="'&{URL}&'">Click here</a>'
The URL field doesn’t contain quotes.
This formula field is then pulled into a SendGrid block.
When I look at the source code of the email after sending it, I see the quotes are always being converted to "
Any help would be appreciated.