I am trying to calculate the distance between two addresses. I put the below formula in but came up with a distance of 5000 and it should be 3. var number OriginLat = [LatitudeVendor];var number OriginLong = [LongitudeVendor];var number DestLat = [LatitudePlant];var number DestLong = [LongitudePlant];var number Distance = Round(((69*($OriginLat - $DestLat))^2 + (53*($OriginLong - $DestLong))^2)^0.5);If($OriginLat =0 or $DestLat=0,0,$Distance)------------------------------Sarah Burres------------------------------

On second thought, the Juiced tool will be easier to deploy and maintain.

MarkShnier__You is referencing Pythagorus, making Canada 51st state plugs, and dropping promos for Empower 2025 all in one discussion thread. All the while providing help in how to accurately capture distance between two points via a formula in Quickbase. Qrew Legend indeed... Thank you to everyone who contributed to this.

Your screen shot shows in fact 1,547 miles not 5,000. It's impossible with the coordinates in the screen shot to only be three miles apart. They are very far apart as they are very different. I think that your source data is incorrect. "My" formula is correct.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

I've just stumbled on this thread as I'm trying something similar. I can get the coordinates to work and the field is calculating. However, I'm getting something different than what maps is showing me. For example, the formula is calculating a distance of 70miles for one example, but when I measure the distance on Google Maps it gives me 66 miles. Is there something in the above formula that is preventing us from getting an accurate number? What Quickbase says:What Google Maps measurement says:

The formula is just an approximation and certainly is not driving distance, but crow flies distance. It also works best at he geographic center of the USA and will utterly fail near the north and south poles (not much demand for distances for Polar Bears or Penguins). It's best used to rank results according to approximate distance. The "exact" formula would require advanced trigonometric non Euclidian functions which do not exists in native Quickbase. But all kidding aside, if you are using it mostly in certain part of he world, it can be adjusted to be better as those values of 69 and 53 refer to the distance between the integer Lat and Long lines in your typical locale.

distance between two addresses

18 Replies

MarkShnier__You
Qrew Legend
3 months ago
Not to beat us to death, but as an intellectual exercise, the formula could be improved by having a look up table to adjust the constant in the formula of 54 to be the number 45 where the latitude of the Base was up at the 49th parallel in the north near Canada (yes we are still a separate country up here and not yet the 51st state), and would be adjusted to a value of 60 for a Base down in the south near New Orleans, home of 2025 EMPOWER. Obviously the table could be loaded with say 100 values representing the range of latitudes in the USA.
Chat GPT is useful for doing the legwork on these values.
- HannahEngelson
  Qrew Trainee
  3 months ago
  We were able to utilize a cosine formula in Excel multiplied by 69miles to determine the longitude distance at the location's latitude (thank you high school trig!). That seems to work well enough when the pilot's location and their base are at a similar latitude. We are running into issues when the pilot lives in Florida and commutes to NYC, for example. I think if we take an average of the two, we could get closer. It'll take some trial and error to determine the best option for our purpose.

Forum Discussion

distance between two addresses

18 Replies

Related Content

Address field not working

Address Field - Set default value?

Calculating Distance from 2 Address Fields

Change From Email Address

Email address validation