Unable to prepopulate form fields using a URL with merged fields

Hi All.

First thing - I think your software is great.

I want to pre-populate 280 forms with club members' details.

I have created the following URL and you can see where I have inserted the mail merged fields

https://form.jotform.com/212172751831047?name=[first]=!*FIRSTNAME*!&name[last]=!*LASTNAME*!@email=&email=!*FIELD1*!&address[addr_line1]=!*ADDRESS1*!&address[city]=!*CITY*!&address[state]=Queensland&address[postal]=!*ZIP*!&address[country]=Australia&membershipNumber=!*MEMNUMBER*!&phoneNumber=!*TELEPHONE*!&secondaryPhone=!*SECONDFONE*!

The URL is sent out using the mass email program Group Mail - https://group-mail.com/

However, the URL works on the first test but then fails from thereon.

The merged URL then changes to the following when clicked by the form submit:

https://link.buderimgardenclub.com/click/1XCuasWfZYqNUs.Dk3HCfrq7YCQG/Ho1KXMpZ/3s/form.jotform.com/212172751831047?name%5Bfirst%5D=John&name%5Blast%5D=Leach&email=johnsleach@gmail.com&address%5Baddr_line1%5D=5%20St%20Helena%20Street&address%5Bcity%5D=Maroochydore&address%5Bstate%5D=Queensland&address%5Bpostal%5D=4558&address%5Bcountry%5D=Australia&membershipNumber=%20291&phoneNumber=0754789316&secondaryPhone=0429601066

What am I doing wrong?

Unfortunately, using the Widget does not allow the use of pre-populating the address fields. That I can see).

Your advice would be appreciated.

Kind regards,

John Leach

Thank you for reaching support,

Can you please check this guide and let us know if it fits your requirements: https://www.jotform.com/prefill-forms/.

It auto-fills the fields on the form.

Awaiting your response.

Best.

Thanks for your attention.

None of those options would work for us, unfortunately.

If we were able to import an Excel file into the tables, we would be almost there.

Kind regards,

John

Hi there,

Can you please elaborate on this for us?

You are able to import into your submissions tables: https://www.jotform.com/help/1001-how-to-import-data-in-jotform-tables.

You can also use spreadsheets to prepopulate the fields: https://www.jotform.com/help/442-how-to-use-the-spreadsheet-to-form-widget.

Best.

Thank you for your message.

I have created the spreadsheet and imported it into Tables. -Very good - thanks.

I have created the unique URLs but I see it is limited to only 20 at a time. That makes it a very big job to copy 288. Not sure how to get around that.

Then I have to work out how to merge the URLS into mail merged emails.

Any guidance would be appreciated.

Kind regards,

John Leach

Hello,

I do not personally know a workaround this limitation.

I will ask the team and revert back to you soon.

Best regards

Hello,

One of my colleague recommended to build the structure of the URL and to generate them via excel to then copy them:

="https://form.jotform.com/212172751831047?name[first]=" & $A$1 & "&name[last]=" & $B$1

Best regards