-
mschmittAsked on January 8, 2016 at 4: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!
-
Welvin Support Team LeadReplied on January 9, 2016 at 9:31 AM
Please use this app instead: http://prepopulate.jotform.io/ to do the prepopulation.
-
mschmittReplied on January 11, 2016 at 3: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.
-
Kevin Support Team LeadReplied on January 11, 2016 at 8: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.
-
mschmittReplied on January 13, 2016 at 3: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?
-
Kevin Support Team LeadReplied on January 13, 2016 at 5: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 :
Use this link instead it should work.
Thanks.
-
mschmittReplied on January 14, 2016 at 9: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?
-
Welvin Support Team LeadReplied on January 14, 2016 at 10:53 AM
You can add it in the URL:
&ecrmId=id
ex:
-
mschmittReplied 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?
-
Welvin Support Team LeadReplied 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.
-
mschmittReplied on January 15, 2016 at 2: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?
-
Welvin Support Team LeadReplied on January 15, 2016 at 7: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?