Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Autocompleted Address breakdown into multiple fields

davidg1982
Topic Author
Offline
New Member

More

6 years 6 months ago #171234 by davidg1982

Autocompleted Address breakdown into multiple fields was created by davidg1982

Good day all.

I have an address field were it is going to be autocompleted by google maps API, but I'd like to know how I can take the address and have them feed indivdual fields. As in, have the street address go to the street address field in the DB and have the zip code go to the zip code field in the DB for each survey response.

The end goal is to make this easier to slice and dice the data later on without much modification on the backend. Basically trying to get the data organized the way we want as it goes in.

Can I do this? How is it done? I am trying to find an easy answer for my web dev person.

Thanks!

The topic has been locked.

Joffm
Away
LimeSurvey Community Team

More

6 years 6 months ago #171243 by Joffm

Replied by Joffm on topic Autocompleted Address breakdown into multiple fields

Hi,

you can use some equations with functions "strpos" and "substr" to find the delimiters between the parts of the address and then get the part with "substr".

How does this string look like? How do you want to split exactly? Please, give an example.

Best regards
Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless

The topic has been locked.

tpartner
Offline
LimeSurvey Community Team

More

6 years 6 months ago #171253 by tpartner

Replied by tpartner on topic Autocompleted Address breakdown into multiple fields

How are you implementing the address look-up? If using the reverse Geocoding API, the returned "formatted_address" string may not always be structured the same - from the documentation: "The "formatted_address" results are not just postal addresses, but any way to geographically name a location.". Due to this, it may not be safe to parse the string with Expression Manager. You might want to access the elements of the returned "address_components" array directly.

Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

The topic has been locked.

davidg1982
Topic Author
Offline
New Member

More

6 years 6 months ago #171269 by davidg1982

Replied by davidg1982 on topic Autocompleted Address breakdown into multiple fields

Right now I am implementing it through a JS script based on advice from Google , but I am trying to figure out how to have the autocomplete fill in multiple fields, like in the example, then fill contact details, like city, state, etc. The manual, from my perspective, is not clear as how to achieve that.
I would appreciate something in the right direction.

Here is the code of the question. It's basic. I've removed my API key for security reasons.

Code:

<p><script src="https://maps.googleapis.com/maps/api/js?key=[APIKEY]&amp;libraries=places"></script><script src="jquery.geocomplete.js"></script>Please enter your address.</p>
 
<p>powered by Google</p>
 
<p id="displayCounty"> </p>
<script>
  function init() {
    $('#displayCounty').hide();
    var input = document.getElementById('answer161767X10X131');
    var autocomplete = new google.maps.places.Autocomplete(input);
 
    autocomplete.addListener('place_changed', function() {
      var place = autocomplete.getPlace();
      var components = place.address_components;
      if (components) {
        for (var i = 0, l = components.length; i < l; i++) {
          var component = components[i];
          if (component.types &amp;&amp;
              component.types.indexOf('administrative_area_level_2') !== -1) {
            $('#displayCounty').text('County: ' + component.long_name);
            $('#displayCounty').show();
          }
        }
      }
    });
  }
  google.maps.event.addDomListener(window, 'load', init);
</script>

The topic has been locked.

tpartner
Offline
LimeSurvey Community Team

More

6 years 6 months ago #171275 by tpartner

Replied by tpartner on topic Autocompleted Address breakdown into multiple fields

Can you attach a small sample survey.

Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

The topic has been locked.

davidg1982
Topic Author
Offline
New Member

More

6 years 6 months ago #171338 by davidg1982

Replied by davidg1982 on topic Autocompleted Address breakdown into multiple fields

This should be it.

Attachments:

...vey_161767.lss

The topic has been locked.

tpartner
Offline
LimeSurvey Community Team

More

6 years 6 months ago - 5 years 5 months ago #171376 by tpartner

Replied by tpartner on topic Autocompleted Address breakdown into multiple fields

I would add sub-questions for all of the address components and use a script like this (replace YourAPIKey with a valid key):

Code:

<script src="https://maps.googleapis.com/maps/api/js?key=YourAPIKey&amp;libraries=places"></script><script src="jquery.geocomplete.js"></script>
<script>
  function init() {
    $('#displayCounty').hide();
 
    // Disable the partial-address inputs
    $('#question{QID} input:text:gt(0)').prop('readonly', true);
 
    // Un-comment below to hide the partial-address inputs
    //$('#question{QID} input:text:gt(0)').hide();
 
    var input = document.getElementById('answer{SID}X{GID}X{QID}SQ001');
    var autocomplete = new google.maps.places.Autocomplete(input);
 
    autocomplete.addListener('place_changed', function() {
      var place = autocomplete.getPlace();
      var components = place.address_components;
      if (components) {
        for (var i = 0, l = components.length; i < l; i++) {
          var component = components[i];
          if (component.types &amp;&amp; component.types.indexOf('street_number') !== -1) {
            $('#answer{SID}X{GID}X{QID}SQ002').val(component.long_name);
          }
          if (component.types &amp;&amp; component.types.indexOf('route') !== -1) {
            $('#answer{SID}X{GID}X{QID}SQ003').val(component.long_name);
          }
          if (component.types &amp;&amp; component.types.indexOf('locality') !== -1) {
            $('#answer{SID}X{GID}X{QID}SQ004').val(component.long_name);
          }
          if (component.types &amp;&amp; component.types.indexOf('administrative_area_level_2') !== -1) {
            $('#displayCounty').text('County: ' + component.long_name);
            $('#displayCounty').show();
            $('#answer{SID}X{GID}X{QID}SQ005').val(component.long_name);
          }
          if (component.types &amp;&amp; component.types.indexOf('administrative_area_level_1') !== -1) {
            $('#answer{SID}X{GID}X{QID}SQ006').val(component.long_name);
          }
          if (component.types &amp;&amp; component.types.indexOf('country') !== -1) {
            $('#answer{SID}X{GID}X{QID}SQ007').val(component.long_name);
          }
          if (component.types &amp;&amp; component.types.indexOf('postal_code') !== -1) {
            $('#answer{SID}X{GID}X{QID}SQ008').val(component.long_name);
          }
        }
      }
    });
  }
  google.maps.event.addDomListener(window, 'load', init);
</script>

Sample survey (you will need to insert a valid API key in the src of the first script):

File Attachment:

File Name: limesurvey...9-10.lss
File Size:23 KB

Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Attachments:

...2018-07-17.png

Last edit: 5 years 5 months ago by tpartner.

The following user(s) said Thank You: davidg1982

The topic has been locked.

davidg1982
Topic Author
Offline
New Member

More

6 years 6 months ago #171502 by davidg1982

Replied by davidg1982 on topic Autocompleted Address breakdown into multiple fields

This worked! Great! Thank you for your help.

The topic has been locked.

davidg1982
Topic Author
Offline
New Member

More

6 years 5 months ago #172640 by davidg1982

Replied by davidg1982 on topic Autocompleted Address breakdown into multiple fields

Question, is there a way we can hide all the fields the grayed out fields and still get all the information?

The topic has been locked.

tpartner
Offline
LimeSurvey Community Team

More

6 years 5 months ago #172647 by tpartner

Replied by tpartner on topic Autocompleted Address breakdown into multiple fields

Yes, that is already pointed out in the code comments.

Remove the preceding slashes in this line:

Code:

//$('#question{QID} input:text:gt(0)').hide();

Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

The topic has been locked.

dirk01
Offline
New Member

More

6 years 5 months ago #173248 by dirk01

Replied by dirk01 on topic Autocompleted Address breakdown into multiple fields

Hi,

I used this solution a lot!! in a questionnaire about mobility I am programming.

It worked great until I ran the full questionnaire.

It seems the script only works in 'all at once'-mode and the questionnaire is programmed to run in group by group mode.

Is it possible to get it working in group by group or question by question mode?

Best regards

Dirk

The topic has been locked.

tpartner
Offline
LimeSurvey Community Team

More

6 years 5 months ago #173260 by tpartner

Replied by tpartner on topic Autocompleted Address breakdown into multiple fields

The attached sample survey works for me in group-by-group if I disable AJAX mode in the theme options.

Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Attachments:

...2018-08-30.png

The topic has been locked.

Moderators: tpartner, holch

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans

Get started

Welcome to the LimeSurvey Community Forum

Autocompleted Address breakdown into multiple fields

File Attachment:

Lime-years ahead

Legal

About Us

Open Source