Forum Discussion
Jeff, thx for the mention.
There is not a native QuickBase function to geocode an address. So I know of two methods. One is lookup in the Internet and enter manually. The other would be to install a 3rd party app from Juiced for their Maps add on, since when you draw the map, it will write any missing geocodes to a pair of Lat Long fields in the Record. So that's an option where there is a steady flow if new addresses to geocode.
If you can find some free service which would respond to an Web Service call, a Pipeline can send it and listen for the answer.
Now, having said all that, I recall an app I recently did where employees need to enter mileage for expense reimbursements
I use this URL formula in Add mode on a record to open a new window to show the exact driving distance the user enters the addresses and then clicks the button to visually see the distance and then keys it into the record while still in add mode.
List("/",
"https://www.google.com/maps/dir",
URLEncode([From Address]),
URLEncode([To Address])
)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- Simple point-to-point distance calculations
- Lots of different types of mapping processes
- Actual routing and scheduling of teams for efficient driving
...and lots more
Here is a quick video of a recent implementation of distance and time calculation: https://www.screencast.com/t/hVkEIPf0
Here is a video of a more complex routing and scheduling demo. While you are looking at a custom interface, all the functionality is developed right into the Quickbase app with API calls to Google Maps: https://www.screencast.com/t/xTWOgyb5t
If you are interested in discussing further I can be reached at sburday@trinityis.com
Thanks.
------------------------------
Scott Burday, Trinity
------------------------------