Skip to main content
Solved

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

  • September 4, 2024
  • 2 replies
  • 0 views
0
Forum|alt.badge.img+15

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

Best answer by kuovonne

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()) )

 

View original
Did this topic help you find an answer to your question?

2 replies

kuovonne
Forum|alt.badge.img+27
  • kuovonne
  • Brainy
  • 6001 replies
  • Answer
  • September 4, 2024

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()) )

 

0
1 person likes this
  • 0
    0800-grizzly
0
Forum|alt.badge.img+15
  • 0800-grizzly
  • Author
  • Known Participant
  • 58 replies
  • September 5, 2024
kuovonne wrote:

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()) )

 


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

 

 

 

 

Reply


Most helpful members this week

Terms & Conditions