Calculating Distance from 2 Address Fields
I have seen a lot of posts that partially answer elements I want to do, and I am relatively new to QuickBase (not necessarily databases or analytics, though). I am trying to calculate the distance bet...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendJeff, 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
------------------------------
Thanks, Mark and Jeff. I think that the URL formula might be something good to try out because that will just allow my logistics coordinator to click a link to get the mileage for reimbursements instead of having to have two screens open and trying to copy/type addresses.
I did see Mark's original formula that you included, Jeff. I think that will be the way to go if they want to do the straight-line (as the crow flies) distance. It will be helpful to see if they qualify for reimbursement, but I can see that not being beneficial if it is over Colorado mountains were it is far from a straight-line :)
------------------------------
Jeffrey Weide
------------------------------
I did see Mark's original formula that you included, Jeff. I think that will be the way to go if they want to do the straight-line (as the crow flies) distance. It will be helpful to see if they qualify for reimbursement, but I can see that not being beneficial if it is over Colorado mountains were it is far from a straight-line :)
------------------------------
Jeffrey Weide
------------------------------
- MarkShnier__YouOne thing I have discovered in life is that when it comes to people's pay or expense reimbursement, there is no such thing as "close is good enough". You will get an earful if you short them even $1.00.
Low tech, like you suggested is to pop up that screen to get the google directions and have them enter the miles to claim. Or else, basically record their odometer start end each trip with pencil and paper or some little notes app on their phone manually.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------