Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Clickable URL

Topic Labels: Base design Formulas
Solved
Jump to Solution
4874 7
cancel
Showing results for 
Search instead for 
Did you mean: 
Eren1
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi everyone, 

I searched through the community posts but could not find anything.

Using a formula I created custom URL for every person in our company that will allow prefills in a form.

CONCATENATE('https://airtable.com/appxxxx','?prefill_Your Name=',Name)

for example 
'https://airtable.com/appxxxx','?prefill_Your Name=',John Doe)

Problem is that there are now blanks and therefore only the first part of link is recognised as such. 
I know that I can use %20 is used in the final URL. But this does not make the URL in my dataset clickable



Anyone an idea what I would need to do?
 
Thanks for your help
1 Solution

Accepted Solutions
Databaser
12 - Earth
12 - Earth

Place every field you're using, so eg {your name} inside the ENCODE_URL_COMPONENT(). Eg: ENCODE_URL_COMPONENT({your name})

That way, it will automatically handle spaces, etc.

See Solution in Thread

7 Replies 7
Sho
11 - Venus
11 - Venus

Hi @Eren1 ,

How about using +?

'https://airtable.com/appxxxx','?prefill_Your+Name=',John+Doe)
Eren1
5 - Automation Enthusiast
5 - Automation Enthusiast

I can't use the + in the formula. Would not help. The blanks are in the data set

 

 

 

CONCATENATE('https://airtable.com/appxxxx','?prefill_Your Name=',Name)

 

 

The result of the formula is a URL with a blank

https://airtable.com/appxxxxxxx?prefill_Dein+Name=John  Doe

 
 

Sho
11 - Venus
11 - Venus

Okay, I see. How about replacing space with +.

CONCATENATE('https://airtable.com/appxxxx','?prefill_Dein+Name=',SUBSTITUTE({Name} , ' ' , '+'))

 

Databaser
12 - Earth
12 - Earth

You can use "ENCODE_URL_COMPONENT()"

The ENCODE_URL_COMPONENT formula function translates strings of text and characters into language that can be read in your browser's address field. Because URLs can only read special characters (e.g. %20 instead of a space), you have to encode any normal components in order for them to be used in a web address.

A common Airtable scenario where this is helpful is pre-filling form URLs. This is a tutorial on how to setup a base to automatically generate unique pre-filled form URLs using ENCODE_URL_COMPONENT.

Source

Eren1
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Databaser,

I think that is what I need. Went through the guide but could make not make encode url component work.

CONCATENATE('https://airtable.com/appXXXX/YYYYY,'?prefill_Vehicle=',Vehicle)

-> How would I need to embed it here? 




Databaser
12 - Earth
12 - Earth

Place every field you're using, so eg {your name} inside the ENCODE_URL_COMPONENT(). Eg: ENCODE_URL_COMPONENT({your name})

That way, it will automatically handle spaces, etc.

I forgot that ENCODE_URL_COMPONENT() exists. Thanks for the follow up.