Skip to main content
Solved

Clickable URL

E

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

Best answer by Databaser

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.

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

7 replies

S
  • Sho
  • Inspiring
  • 560 replies
  • October 16, 2023

Hi @Eren1 ,

How about using +?

'https://airtable.com/appxxxx','?prefill_Your+Name=',John+Doe)
E
  • Eren1
  • Author
  • Inspiring
  • 6 replies
  • October 16, 2023
Sho wrote:

Hi @Eren1 ,

How about using +?

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

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

 
 

S
  • Sho
  • Inspiring
  • 560 replies
  • October 16, 2023

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

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

 

Databaser
Forum|alt.badge.img+4
  • Databaser
  • Inspiring
  • 866 replies
  • October 16, 2023

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

Jan - Databaser
E
  • Eren1
  • Author
  • Inspiring
  • 6 replies
  • October 16, 2023
Databaser wrote:

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


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
Forum|alt.badge.img+4
  • Databaser
  • Inspiring
  • 866 replies
  • Answer
  • October 16, 2023

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.

Jan - Databaser
S
C
2 people like this
  • S
    Sho
  • C
    Cynthia_C
S
  • Sho
  • Inspiring
  • 560 replies
  • October 17, 2023
Databaser wrote:

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.

Databaser
1 person likes this
  • Databaser
    Databaser

Reply


Most helpful members this week

Terms & Conditions