Unable to prepopulate form fields using a URL with merged fields

  • Profile Image
    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









  • Profile Image
    Kenneth
    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.

  • Profile Image
    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

  • Profile Image
    Kenneth
    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.

  • Profile Image
    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




  • Profile Image
    Gaetan
    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

  • Profile Image
    Gaetan
    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


    1628450545_61102ef1dd872_


    Best regards