Jump to content
Sign in to follow this  
Mylene

generate coordinates on update

Recommended Posts

Hi, I'd like to generate coordinates (latitude and longitude) for address, entered on update form

I know that there is a solution for submission form, however it doesn't work on update

Thanks!

 

Share this post


Link to post
Share on other sites

Hi,

I modified script from this article. 

Code for the header:

<div id="cbwrapper">

Code for the footer:

</div><script type='text/javascript'>
var lat_id = 'EditRecordlat';
var lng_id = 'EditRecordlng';
var address_id = 'EditRecordAddress';
var city_id = 'EditRecordCity';
var state_id = 'EditRecordState';
var zip_id = 'EditRecordZip';
var wrapper_id = 'cbwrapper';
var msg1 = 'Please input a valid address';
if(typeof jQuery != 'undefined'){
var cb_geocoder = cb_geocoder = new google.maps.Geocoder();
$('#'+wrapper_id+' input[id=Mod0EditRecord]').click(function(e){
e.preventDefault();
var add = $('#'+address_id).val();
var city = $('#'+city_id).val();
var state = $('#'+state_id).val();
var zip = $('#'+zip_id).val();
if(!add || !city || !state || !zip){
alert(msg1);
}else{
var full = add +','+city+','+state+' '+zip;
cb_geocoder.geocode({address: full}, cbCallBack);
}
});
}else{
document.write('This Datapage require Standard Caspio Deployment for full functionality.');
}
function cbCallBack(locResult){
if(locResult != "" && locResult.length>0){
var lat1 = locResult[0].geometry.location.lat();
var lng1 = locResult[0].geometry.location.lng();
lat1 = Number(lat1);
lng1 = Number(lng1);
$('#'+lat_id).val(lat1);
$('#'+lng_id).val(lng1);
$('#'+wrapper_id+' form').submit();
}else{
alert(msg1);
}
}
</script>

Code for the html file where the datapage is deployed:

<script type="text/javascript" src="https://lib.caspio.com/pub/jquery/jquery.js"></script>
<script src="//maps.googleapis.com/maps/api/js?v=3.exp&sensor=false&key=YOUR_KEY" async="" defer="defer" type="text/javascript"></script>

You should place those two lines above the deploy code of the datapage.

Paste your google apikey instead of: YOUR_KEY

Cheers!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...