Google Distance Matrix API
I would like to see if there is a way for me to create an API that will call into Google Distance Matrix API and return the distance a worker's home is from the job site. I was able test the API in Po...
Forum Discussion
Thank you!
Any way I could get you to point me in the right direction for the automated way?
Can I use a webhook to get the information and then post it somehow on to a field?
Again, thanks for taking the time to help me!!
Any way I could get you to point me in the right direction for the automated way?
Can I use a webhook to get the information and then post it somehow on to a field?
Again, thanks for taking the time to help me!!
- I agree with this is there anyway to enter two addresses on the QuickBase record and have the Google API calculate the distance and then have it shown on the QuickBase record?
- Yes, I do it with a code page.
- We are all hoping for a day soon where QuickBase exposes the "geocoding" (lat & long) of an Address field to use as an automatically populated field associated with an Address field. When that day comes, this will be a lot easier to calculate the distance - not the driving distance, but at least the "as the crow flies" distance - a straight line.
- This is easy to do with script. I have to travel now but I will either post an example I did earlier or create a new demo.
Trivia: Most of you probably don't know that my business is named after the esoteric trigonometric function haversine which is used in calculating the great circle distance between two points on a sphere:
https://en.wikipedia.org/wiki/Haversine_formula
Numb3rs Scene: Everything is numbers, Math is everywhere
https://www.youtube.com/watch?v=vFRTgr7MfWw - I know... It would be great if they would at least add some Trig functions in there (Sin, Cos...) that way we could use them to calculate as crow flies.
- An example would be great!
Thank you! - Here is the non trigonometry solution. No Sin and Cos requires because in fact the earth is flat. https://community.quickbase.com/quickbase/topics/is-there-a-formula-within-quickbase-that-would-calc...
- This is awesome! The earth is flat... The people in the middle ages were right after all :)
I'll try your approach.
Thank you! - The Earth is an oblate spheroid.
