You need to sign in to do that
Don't have an account?
Have Excel list of zips&lat/lngs; want to search for Accounts within "x" miles radius of zipcode
I want to be able to perform a search to find all Accounts within a, say, 50 mile radius of a specified zipcode.
I have an excel sheet that has all zipcodes, and the respective lat/lng degrees of the "center" of the zipcode. Also, the excel list includes the city, state, and state abbreviation.
We also have Find Nearby installed, but I am unfamiliar with this, and if it can search by a radius, and produce a LIST, not a map, of the results.
It would be great if we could run a report or something (custom object?) to produce this list. Any ideas?
I'm not sure if this would be an Apex code or not.
JessBess-
I have a solution specific to your problem... I will send out the complete listing of what needs to be done(with code and all steps) sometime tomorrow.
It involves Google API, custom object, Apex code(Class and a trigger) data export/import.
Thanks, Sam
Google API reference...
https://developers.google.com/maps/documentation/distancematrix/#DistanceMatrixRequests
req.setEndpoint('https://maps.googleapis.com/maps/api/distancematrix/xml?origins='+start1+
'&destinations='+destination1+'&sensor=false');
its not clear in the above code..