Is there a way to create a report based on distance from an address?

  • 1
  • 2
  • Question
  • Updated 2 years ago
  • Answered

I would like to run a report that pulls up a lists of contacts that are within 1 mile from the current contact. Is there a way to do this?

Photo of Michael

Michael

  • 10 Points

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
Photo of Michael

Michael

  • 10 Points
where?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
sorry, i had not pasted in the link.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,904 Points 20k badge 2x thumb
I am on a tablet and can't type a lot. See this application where you can find the closest White Castle dining establishment based on your location (lat & lon):

https://haversineconsulting.quickbase.com/db/bi5963543

The name of my business is Haversine Consulting and haversine is a little known trig function used to calculate the distance between two points on a sphere:

https://en.m.wikipedia.org/wiki/Haversine_formula
Photo of Ann Swelgin

Ann Swelgin

  • 382 Points 250 badge 2x thumb
I have the same question basically. I have a customer and I need to find other customers within a certain distance from that customer. Another question, is there any way to have that address field use the zip+4 when it does the lookup?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
There was a discussion here. https://community.quickbase.com/quick...

You would need to gricode your addresses.
Photo of Ann Swelgin

Ann Swelgin

  • 382 Points 250 badge 2x thumb
when I click that link it goes right back to the place I found this question.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
Greetings from 30,000 feet.  Sorry, I forgot that those links to the old forum no longer work.

Search this forum on the keyword     pythagoras