- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 04, 2024 09:34 AM
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()
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 04, 2024 04:22 PM - edited ‎Sep 04, 2024 04:27 PM
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())
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 04, 2024 04:22 PM - edited ‎Sep 04, 2024 04:27 PM
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())
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 04, 2024 10:24 PM
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
