Autocomplete Field With URL Not Populating Correctly

Hi JF

We use a google sheet to generate an autocomplete for a form.

One of the two fields we want populated: College name

Content we want to populate it with: Texas A & M University-College Station


URL we are using: https://form.jotform.com/241347714626155?&yourName=Mulan%20Zhang&collegeName=Texas%20A%20&%20M%20University-College%20Station


The field is actually getting populated with just: "Texas A"


My guess it that the "&" is causing the problem. Is that the case?
If so, any suggestions on how to deal with it?
This will be a regular occurence.

Thanks!
Robert

Hi Robert,

Thanks for reaching out to Jotfomr Support. It seems you are right that the issue is caused by the & symbol in the college name, as it is being interpreted as a parameter separator in the URL. To resolve this, you can encode the & symbol as %26 in your prefill URL. Here’s the corrected version of your URL:

https://form.jotform.com/241347714626155?&yourName=Mulan%20Zhang&collegeName=Texas%20A%20%26%20M%20University-College%20Station

Here's the result:

Give it a try and let us know how it goes.

thanks