Hi @Sebastien_Dolidon - replace:

{Company}

with

SUBSTITUTE({Company}, " ", “%20”)

JB

Thanks a lot for you answer JB, but where should i put it in the other formula :

CONCATENATE(‘https://mytypeform.typeform.com/to/gMQE2K?company=’, {Company}, ‘&person=’,{Person} ,’&id=’,{ID})

Just after it ? inside it ?

Sorry, should have been clearer. Try this:

CONCATENATE('https://mytypeform.typeform.com/to/gMQE2K?company=', SUBSTITUTE({Company}, ' ', '%20'), '&person=',{Person} ,'&id=',{ID})

JB

It’s a formula within a formula, which is pretty common, of course. You could also create the “new” company name as its own field, use this new field in the formula, then hide the modified company name field. I sometimes do this to reduce the formula complexity.

Thanks a lot JB, it’s working perfectly ! love u ! have a great week end :grinning_face_with_smiling_eyes:

I am trying to do a similar thing but I have an extra field. Please help me correct the formula…

CONCATENATE(‘https://form.jotform.com/’, &{formID}, &’?companyName=’, SUBSTITUTE({Company Name}, ’ ‘, ‘%20’), &’&imageLink=’, &{Logo URL})

Figured it out:

CONCATENATE(‘https://form.jotform.com/’ &{formID} &’?companyName=’,

SUBSTITUTE({Company}, ’ ', ‘%20’), ‘&imageLink=’,{Logo URL})

Trying to do something similar except that for the pre-filled form, it is not copying all of the substituted text. Why might this be?

Maybe this may help 
Prefilled Forms extension for Airtable by @kuovonne