What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Pre Populate Quicktools Address Field

    Asked by mschmitt on January 08, 2016 at 04:25 PM

    How can I create a URL to pre-populate the address template from the Quicktools menu? The field name is just siteAddress87, so how would I put together a an string that would fill all fields (Address lines 1 & 2, City, State, Zip)? When I use separate fields for each element, this is the URL template I used:

     

    https://form.jotform.com/53444859022962?description={&siteName=&siteAddress=&address2=&city=&state69=&zip75=

     

    Thanks!

    Page URL:
    http://www.jotform.com//?formID=53444859022962

    address field prepopulate address
  • Profile Image
    JotForm Support

    Answered by Welvin on January 09, 2016 at 09:31 AM

    Please use this app instead: http://prepopulate.jotform.io/ to do the prepopulation. 

  • Profile Image

    Answered by mschmitt on January 11, 2016 at 03:52 PM

    Unfortunately, I need to make thousands of forms each prepopulated with different information, so I am using formulas in Excel to build the links. I have successfully done this before, I just can't get the quick address field to work.

  • Profile Image
    JotForm Support

    Answered by Kevin_G on January 11, 2016 at 08:31 PM

    Yes, if you use the app provided by my colleague above, you will get a link like this : http://form.jotformpro.com/form/60108249846964?address[addr_line1]=test&address[addr_line2]=test&address[city]=test&address[state]=test&address[postal]=123&address[country]=United%20States

    You can replace the data and generate new links, but if you are trying to insert multiple records, that is not possible, you can only do it with each address you have.

     

  • Profile Image

    Answered by mschmitt on January 13, 2016 at 03:56 PM

    Thanks, I think that's what I was looking for. I put together something to generate the following link format, but the address still isn't populating. Am I missing something simple?

     

    https://form.jotform.com/53444859022962?description={ecrmGen=a03a000000Ey2mJ&siteName=Silver Spring - MD&address[addr_line1]=TEST&address[addr_line2]=TEST&address[city]=TEST&address[state]=Maryland&address[postal]=20910&account84=TEST
  • Profile Image
    JotForm Support

    Answered by Kevin_G on January 13, 2016 at 05:05 PM

    Hi,

    I generated the link to your form, now is populating the address, I removed the code you have for the address and added this one : 

    siteAddress87[addr_line1]=test&siteAddress87[addr_line2]=test&siteAddress87[city]=test&siteAddress87[state]=Alabama&siteAddress87[postal]=123&siteAddress87[country]=United%20States

     

    Now this is URL working : 

    https://form.jotform.com/53444859022962?description=%7BecrmGen=a03a000000Ey2mJ&siteName=Silver%20Spring%20-%20MD&account84=TEST&siteAddress87[addr_line1]=test&siteAddress87[addr_line2]=test&siteAddress87[city]=test&siteAddress87[state]=Alabama&siteAddress87[postal]=123&siteAddress87[country]=United%20States 

    Use this link instead it should work.

    Thanks.

     

  • Profile Image

    Answered by mschmitt on January 14, 2016 at 09:07 AM

    The address now works perfectly, thanks! I'm seeing a new problem though: whichever field comes right after the description doesn't get filled in on the form. In your above example, it's the field name ecrmGen (though the field name is actually ecrmId in my form). Does the brace character cause that to happen?

  • Profile Image
    JotForm Support
  • Profile Image

    Answered by mschmitt on January 14, 2016 at 11:17 AM

    That's what I did to get the field to be filled in, but that is sort of a work-around as there are now  2 sections that have the same information. For the future, why did having only the first highlighted section not work for filling out the ecrmId field?

     

    https://form.jotform.com/53444859022962?description=%7BecrmId=a03a000000Ey2mJ&siteName=Silver%20Spring%20-%20MD&account84=TEST&siteAddress87%5Baddr_line1%5D=test&siteAddress87%5Baddr_line2%5D=test&siteAddress87%5Bcity%5D=test&siteAddress87%5Bstate%5D=Alabama&siteAddress87%5Bpostal%5D=123&siteAddress87%5Bcountry%5D=United%20States&ecrmId=test%20id

  • Profile Image
    JotForm Support

    Answered by Welvin on January 14, 2016 at 12:59 PM

    You do not have a description field in the form so I'm not sure what is the usage of that field name in the URL. Also, the ecrmId after this is not a field, it's a data. That won't affect the field or anything and it's not the same.

    I would suggest going back to the given app and populate the form again to correct the fields. 

  • Profile Image

    Answered by mschmitt on January 15, 2016 at 02:33 PM

    I had been told that putting 'description{' would make special characters work correctly, particularly if the symbol '&' was included in one of the prepopulated values. Right now, if the value contains an ampersand then everything after that within the field doesn't appear. I now have all the correct field names to be auto-filled, thank you for helping with that. The last piece is making sure that special characters won't impact the pre-filled text, how do I do that?

  • Profile Image
    JotForm Support

    Answered by Welvin on January 15, 2016 at 07:53 PM

    I have reviewed your previous threads and found this one that explains the description thing:

    http://www.jotform.com/answers/672080-Prepopulated-Form-one-field-doesn-t-populate#5

     

    But I think the best way would be to use ASCII element for the & symbol in the URL as explained by my colleague Charlie on this thread:

    http://www.jotform.com/answers/672096-Prepopulated-form-do-ampersands-work#3

    Did you try this?