Prefill Contact Field using URL query

Kevin Hietpas

Hello,

I've tried every trick and formatting option possible to prefill the contact field on a form using the contact field from another sheet. The contact list looks like the screenshot below. The true field name in the sheet of Product Line Manager is PLM I've tried

?PLM=Kevin%20Hietpas%20%28khietpas%40email.com%29
?PLM=Kevin%20Hietpas
?PLM=Kevin%20Hietpas%20(khietpas%40email.com)
?PLM=%28khietpas%40email.com%29
?PLM=(khietpas%40email.com%29)
?PLM=khietpas%40email.com
and all the above replacing %40 with @

Paul Newcome

Try replacing the "." with "%2E".

email.com

becomes

email%2Ecom

Paul Newcome

Make sure your formula that generates the URL is using the name of the field being used in the form itself.

I see you have "?PLM" in your attempts, but then the screenshot has "Product Line manager".

Kevin Hietpas

Hi Paul,

I tried making that switch and it is still blank.

Paul Newcome

Try replacing the "." with "%2E".

email.com

becomes

email%2Ecom

Kevin Hietpas

I tried

?Product%20Line%20Manager=Kevin%20Hietpas%20%28khietpas%40email%2Ecom%29

that did not work. However, when I just use the email address, that seems to do the trick… Solution is

?Product%20Line%20Manager=khietpas%40email%2Ecom

Thanks for your help and identifying the Hex code for the period