In your second example, after adding the URL-encoded data from {Nom complet}, you forgot to add another quote before the next prefill section. I believe it should look like this:
"https://airtable.com/Codeofmyform?prefill_Votre%20nom%20complet=" & ENCODE_URL_COMPONENT({Nom complet}) & "&prefill_Prénom=" & {YourNextField} ...
I believe the confusion may be coming from the various & symbols required. In Airtable formula syntax, the & operator concatenates surrounding pieces into a string. However, & is also used in the URL before each prefill section (except the first one).
Does that clear things up?
In your second example, after adding the URL-encoded data from {Nom complet}, you forgot to add another quote before the next prefill section. I believe it should look like this:
"https://airtable.com/Codeofmyform?prefill_Votre%20nom%20complet=" & ENCODE_URL_COMPONENT({Nom complet}) & "&prefill_Prénom=" & {YourNextField} ...
I believe the confusion may be coming from the various & symbols required. In Airtable formula syntax, the & operator concatenates surrounding pieces into a string. However, & is also used in the URL before each prefill section (except the first one).
Does that clear things up?
It works 
Thank you very much for your help !
Le mer. 12 févr. 2020 à 05:51, Justin_Barrett via Airtable Community Forum airtable@discoursemail.com a écrit :
In your second example, after adding the URL-encoded data from {Nom complet}, you forgot to add another quote before the next prefill section. I believe it should look like this:
"https://airtable.com/Codeofmyform?prefill_Votre%20nom%20complet=" & ENCODE_URL_COMPONENT({Nom complet}) & "&prefill_Prénom=" & {YourNextField} ...
I believe the confusion may be coming from the various & symbols required. In Airtable formula syntax, the & operator concatenates surrounding pieces into a string. However, & is also used in the URL before each prefill section (except the first one).
Does that clear things up?
Hello,
It works when the field is text, but do you know which “code” to write when the field is “single select” or “multiple select”.
I tried to write the same thing but it doesn’t work.
Thank you,
Le mer. 12 févr. 2020 à 17:57, Alexis Blanvillain alexis.blanvillain@mon-consultant-independant.com a écrit :
Hello,
It works when the field is text, but do you know which “code” to write when the field is “single select” or “multiple select”.
I tried to write the same thing but it doesn’t work.
Thank you,
Le mer. 12 févr. 2020 à 17:57, Alexis Blanvillain alexis.blanvillain@mon-consultant-independant.com a écrit :
The example page you linked above shows exactly how to use it with a single select field. You need to exactly spell the option for that field (probably using the ENCODE_URL_COMPONENT() function). I haven’t tested a multiple select, and don’t have the time to do so right now. Could you share the code you’re trying for the single select option?
The example page you linked above shows exactly how to use it with a single select field. You need to exactly spell the option for that field (probably using the ENCODE_URL_COMPONENT() function). I haven’t tested a multiple select, and don’t have the time to do so right now. Could you share the code you’re trying for the single select option?
Hello Justin,
Thank you for your help, it works by doing the formula :
“URLofmyform?prefill_NOM=”&{NOM}&"&prefill_Prénom="&{Prénom}&"&prefill_Mail="&{Mail}&"&prefill_Téléphone="&{Téléphone}&"&prefill_TJM%20minimum="&ENCODE_URL_COMPONENT({TJM minimum})&"&prefill_Années%20d’expériences="&ENCODE_URL_COMPONENT({Années d’expériences})… etc.
Le lun. 17 févr. 2020 à 17:33, Justin_Barrett via Airtable Community Forum airtable@discoursemail.com a écrit :
Hello Justin,
Thank you for your help, it works by doing the formula :
“URLofmyform?prefill_NOM=”&{NOM}&"&prefill_Prénom="&{Prénom}&"&prefill_Mail="&{Mail}&"&prefill_Téléphone="&{Téléphone}&"&prefill_TJM%20minimum="&ENCODE_URL_COMPONENT({TJM minimum})&"&prefill_Années%20d’expériences="&ENCODE_URL_COMPONENT({Années d’expériences})… etc.
Le lun. 17 févr. 2020 à 17:33, Justin_Barrett via Airtable Community Forum airtable@discoursemail.com a écrit :
Glad to hear that you got it working! :thumbs_up:
