Help

Re: Clickable URL

Solved
Jump to Solution
4245 0
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} , ' ' , '+'))

 

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.