Autocompleted Address breakdown into multiple fields

More
1 week 1 day ago #171234 by davidg1982
davidg1982 created the topic: Autocompleted Address breakdown into multiple fields
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!

Please Log in or Create an account to join the conversation.

More
1 week 16 hours ago #171243 by Joffm
Joffm replied the 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

Please Log in or Create an account to join the conversation.

More
1 week 12 hours ago #171253 by tpartner
tpartner replied the 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.

Please Log in or Create an account to join the conversation.

More
6 days 22 hours ago #171269 by davidg1982
davidg1982 replied the 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.
<p><script src="https://maps.googleapis.com/maps/api/js?key=[APIKEY]&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 &&
              component.types.indexOf('administrative_area_level_2') !== -1) {
            $('#displayCounty').text('County: ' + component.long_name);
            $('#displayCounty').show();
          }
        }
      }
    });
  }
  google.maps.event.addDomListener(window, 'load', init);
</script>

Please Log in or Create an account to join the conversation.

More
6 days 11 hours ago #171275 by tpartner
tpartner replied the 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.

Please Log in or Create an account to join the conversation.

More
4 days 6 hours ago #171338 by davidg1982
davidg1982 replied the topic: Autocompleted Address breakdown into multiple fields
This should be it.
Attachments:

Please Log in or Create an account to join the conversation.

More
3 days 9 hours ago #171376 by tpartner
tpartner replied the 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):

<script src="https://maps.googleapis.com/maps/api/js?key=YourAPIKey&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 && component.types.indexOf('street_number') !== -1) {
						$('#answer{SID}X{GID}X{QID}SQ002').val(component.long_name);
					}
					if (component.types && component.types.indexOf('route') !== -1) {
						$('#answer{SID}X{GID}X{QID}SQ003').val(component.long_name);
					}
					if (component.types && component.types.indexOf('locality') !== -1) {
						$('#answer{SID}X{GID}X{QID}SQ004').val(component.long_name);
					}
					if (component.types && 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 && component.types.indexOf('administrative_area_level_1') !== -1) {
						$('#answer{SID}X{GID}X{QID}SQ006').val(component.long_name);
					}
					if (component.types && component.types.indexOf('country') !== -1) {
						$('#answer{SID}X{GID}X{QID}SQ007').val(component.long_name);
					}
					if (component.types && 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...7671.lss
File Size:30 KB

Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Attachments:
The following user(s) said Thank You: davidg1982

Please Log in or Create an account to join the conversation.

More
1 day 2 hours ago #171502 by davidg1982
davidg1982 replied the topic: Autocompleted Address breakdown into multiple fields
This worked! Great! Thank you for your help.

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!