With the address field in QuickBase, is there a way to create a report that uses multiple address fields?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
We are looking to create a report based on multiple address fields.  We have a site address field setup for our site location, but we want to know what the distance is to all the delivery locations.  We have setup the site location as an address lookup field for each delivery location and want to be able to map this out and show the distance from the site location to each delivery location.  Is this function currently available?
Photo of Mike

Mike

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
There is not a native QuickBase function to calculate the distance between addresses.  The addresses need to be "geocoded' with their Latitude and Longitude.  This can be done manually or can be automated using ItDuzzit.  Once they are gecoded, there is a formula that will give the distance which I can provide


I have done custom development work for clients to automatically geocode addresses.  Contact me off line via the infomation in my profile if you want to discuss one-on-one.