How to fill the Autocompleted Address Widget with the Zip Code?

  • LPBservicedesk
    Gevraagd op 22 juni 2023 om 08:23

    Dag is er ook widget beschikbaar die aan de hand van een ingevulde postcode en huisnummer

    straatnaam en plaats kan aanvullen? Ik heb wel gebruik gemaakt van de Autofill-adress widget (met Google API) maar deze doet voert niet uit wat wij voor ogen hebben.

    Ik hoor graag.

    Groeten Gerald

  • Abdul Jotform Support
    Geantwoord op 22 juni 2023 om 10:41

    Hi LPBservicedesk,

    Thanks for reaching out to Jotform Support. Unfortunately, our Dutch Support agents are busy helping other Jotform users at the moment. I'll try to assist you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd prefer to receive support in Dutch, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

    I understand that you need users to fill the Autocompleted Address Widget with the Zip Code so it fills out the address fields automatically. I have tested your Form, and it is now working now with me. I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

  • LPBservicedesk
    Geantwoord op 22 juni 2023 om 10:48

    HI Abdul,

    in english is also fine ;)

    if the Google autofill widget can also be used that way, that would be nice indeed. So that you enter a zip code and house number. And that the street name and city are completed / automatically filled in. I would indeed like to hear from you if this is possible with the current widgets


  • Abdul Jotform Support
    Geantwoord op 22 juni 2023 om 11:12

    Hi LPBservicedesk,

    Thanks for patiently waiting. The Autocompleted Address Widget works only when filling in the address name as you can see here:

    How to fill the Autocompleted Address Widget with the Zip Code? Image 1 Screenshot 50

    If you have a Spreadsheet file with some saved data, you can use it with your form so that users can only add the zip codes, then it will import your saved data from the Spreadsheet. Here you are a demo form for the Spreadsheet to form widget that you can use to import your data. Let me show you how to use it:

    • Create a spreadsheet that includes your data in the structure you see below. It's important that the column names in the spreadsheet and field names on the form are the same.

    1643012753 61ee6291bccef  Screenshot 61

    • In Form Builder, click on the Add Form Element menu on the left side of the page.
    • Under the Widgets tab, search for the Spreadsheet to Form widget and add it to your form.

    How to fill the Autocompleted Address Widget with the Zip Code? Image 2 Screenshot 72

    • In the Widget Settings window that opens up, upload your data file and customize the other options. 
    • Then, click on Update Widget.

    How to fill the Autocompleted Address Widget with the Zip Code? Image 3 Screenshot 83

    • In the final stage, add the fields to view values and name them the same as on the spreadsheet.

    How to fill the Autocompleted Address Widget with the Zip Code? Image 4 Screenshot 94

    Give it a try and let us know if you need any help.

  • LPBservicedesk
    Geantwoord op 23 juni 2023 om 03:16

    Unfortunately this will not work in our situation because the data is not known in advance and therefore cannot be retrieved from a spreadsheet

  • Bella Jotform Support
    Geantwoord op 23 juni 2023 om 06:33

    Hi LPBservicedesk,

    Thanks for getting back to us. As my colleague suggested, the Autocompleted Address Widget can be used without a spreadsheet. Check out the example in the screencast below:

    How to fill the Autocompleted Address Widget with the Zip Code? Image 1 Screenshot 50 How to fill the Autocompleted Address Widget with the Zip Code? Image 2 Screenshot 61

    Also, you can check out Geocomplete Widget. This widget allows you to find locations by zip code, street numbers, street names, and business names among other address identifiers.

    How to fill the Autocompleted Address Widget with the Zip Code? Image 3 Screenshot 72

    You can check all the Widgets related to Mapping as shown as below:

    How to fill the Autocompleted Address Widget with the Zip Code? Image 4 Screenshot 83

    If that’s not exactly what you’re looking for, can you explain a bit more about how you want to achieve it so we can help you better? 

    Once we hear back from you, we'll be able to help you with this.