Search the Community

Hello All I want to restrict what geographic location users can submit my forms from. Basically, I want the form to look up the latitude and longitude and match it against ones on my table. Then (within a couple of hundred feet or so) I want it to either- Accept the location the user is at as being the one I've agreed and submit the data Don't accept the user's location (they are more than a couple of hundred feet away from the latitude and longitude on my table) and put up an error message 'Sorry - you are not in the right location to complete this form'. I know this can be done, but it is way above my technical ability I'm afraid. Any help from you wonderful useful people out there? Your hopefully Duncan

Hi Everyone, I would like to share a solution on how to generate geolocation coordinates on Update/Details datapages. My solution based on following HowTo article: http://howto.caspio.com/tech-tips-and-articles/advanced-customizations/tech-tip-generating-geolocation-coordinates-from-web-form-submissions/ Please use this JS instead of the one from step #3 of above article: </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>

Hello Javascript Gurus out there I have been trying (for quite a while) to generate a user's latitude and longitude on a report automatically - to use them with a distance search. There are various topics on this forum (such as http://forums.caspio.com/index.php/topic/4205-html-block-to-detect-geo-location/?hl=geolocation), but none do quite what I want. If I try and adapt any of them, passing them from a submission form as parameters for example, I get an error code 'number too long' when I try and use the latitude and longitude to search with. Caspio's excellent Store Locator app does it with the mobile search, but it requires a button to be pressed ('Use my current location'). When I've tried to alter this to suit my needs, I've just ended up breaking it! Ideally, I would like to put the javascript in the beginning of a report and automatically populate the latitude and longitude search fields. In other words, a user would just open the report and it would automatically show venues closest to their current location (mobile or laptop), without them having to click anything. Any help [very] greatly appreciated. Duncan