Welcome to the LimeSurvey Community Forum

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

Autocompleted Address breakdown into multiple fields

  • davidg1982
  • davidg1982's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 8 months ago #171234 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
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 8 months ago #171243 by Joffm
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
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 8 months ago #171253 by tpartner
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
  • davidg1982's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 8 months ago #171269 by davidg1982
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
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 8 months ago #171275 by tpartner
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
  • davidg1982's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 8 months ago #171338 by davidg1982
This should be it.
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 8 months ago - 4 years 6 months ago #171376 by tpartner
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.
Last edit: 4 years 6 months ago by tpartner.
The following user(s) said Thank You: davidg1982
The topic has been locked.
  • davidg1982
  • davidg1982's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 8 months ago #171502 by davidg1982
This worked! Great! Thank you for your help.
The topic has been locked.
  • davidg1982
  • davidg1982's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 7 months ago #172640 by davidg1982
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
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 7 months ago #172647 by tpartner
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.
More
5 years 6 months ago #173248 by dirk01
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
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 6 months ago #173260 by tpartner
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.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose