Clickable URL

[Eren1]

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

[Sho]

Hi @Eren1 ,

How about using +?

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

[Eren1]

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]

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

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

[Databaser]

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]

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 · Accepted solution]

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.

[Sho]

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