Unable to prepopulate form fields using a URL with merged fields

Create your own downloadable app without any coding. Learn more

buderimphotos
Asked on August 07, 2021 at 08:15 PM

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
Kenneth

Jotform Support

Answered on August 08, 2021 at 05:31 AM

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.
buderimphotos
Answered on August 08, 2021 at 05:37 AM

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
Kenneth

Jotform Support

Answered on August 08, 2021 at 06:58 AM

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.
buderimphotos
Answered on August 08, 2021 at 08:51 AM

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
Gaetan

Jotform Support

Answered on August 08, 2021 at 02:55 PM

Hello,
I do not personally know a workaround this limitation.

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

Best regards
Gaetan

Jotform Support

Answered on August 08, 2021 at 03:28 PM

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