Showing "friendly name" link for URL from formula in a mail

[0800-grizzly]

Hi,

I use a formula field to build a URL to prepopulate a Fillout form, and I send the link via an automation -> Gmail send. The formula looks like this:

"https://user.fillout.com/t/random?email="{email&"&name="&name&"&id="&RECORD_ID()

When sent out in a mail this becomes a clickable URL. I would however like to have as a "friendly name" clickable link instead. This I know can be done with the [Click here!](https://domain.com) syntax, but I can't figure out how to work that into the formula.

Anyone know how to do this?

Rgds,

Björn

[kuovonne · Accepted solution]

There are multiple ways of combining text to make a Markdown link. Here is one way.

CONCATENATE(
  "[friendly name here]",
  "(" & {url formula field} & ")"
)

FYI, the example formula you gave doesn't look quite right. That might be a formatting problem with this forum, or it might be something else.

Instead of 
"https://user.fillout.com/t/random?email="{email&"&name="&name&"&id="&RECORD_ID()

try

CONCATENATE(
  "https://user.fillout.com/t/random",
  "?email=" & ENCODE_URL_COMPONENT({email}),
  "&name=" & ENCODE_URL_COMPONENT({name}),
  "&id=" & ENCODE_URL_COMPONENT(RECORD_ID())
)

[0800-grizzly]

Thank you @kuovonne!

You're right, there is indeed a formatting error, an extra "{" in front of "email&". That was my mistake when anonymising the formula, sorry for the confusion. Appreciate the structured way of composing the formula, had not realised one can do that here.

The CONCATENATE example works perfectly. However, as I wanted to avoid yet another "extra" column, I worked the original formula into the CONCATENATE like this:

CONCATENATE(
  "[Kerro tarinasi!]",
  "("&"https://user.fillout.com/t/random?email="&{email}&"&name="&name&"&id="&RECORD_ID()&")"
)

And saved re-working it into the ENCODE_URL_COMPONENT format for another day :).

Thanks!

Rgds,

Björn