MikeKlausing
6 years agoQrew Assistant Captain
Calculate distance (in Miles) between two zip codes
I have two zip codes that I need to calculate, in miles, the total distance between and populate that in a field on my form.
Our zip code will remain constant which I have a field for, "[address 1]
There is also a field on my form for an address of the ship to, [address 2]
Right now I have a formula URL that looks like this:
"https://www.google.com/maps/dir/"&URLEncode([Address1]) &"/"&URLEncode([Address 2])
This pulls up google maps and calculates distance.
My question is can I get the 500 miles that google maps calculates to generate back onto my QB form. As of now it appears in google maps just fine, but then I have to manually type that number back into QB.
Our zip code will remain constant which I have a field for, "[address 1]
There is also a field on my form for an address of the ship to, [address 2]
Right now I have a formula URL that looks like this:
"https://www.google.com/maps/dir/"&URLEncode([Address1]) &"/"&URLEncode([Address 2])
This pulls up google maps and calculates distance.
My question is can I get the 500 miles that google maps calculates to generate back onto my QB form. As of now it appears in google maps just fine, but then I have to manually type that number back into QB.