# Discussions

View Only

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

• #### 1.  Is there a way to create a report based on distance from an address?

Posted 10-26-2016 22:10

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?

• #### 3.  RE: Is there a way to create a report based on distance from an address?

Posted 10-26-2016 22:17
where?

• #### 4.  RE: Is there a way to create a report based on distance from an address?

Posted 10-26-2016 22:19

• #### 5.  RE: Is there a way to create a report based on distance from an address?

Posted 10-26-2016 22:27
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

• #### 6.  RE: Is there a way to create a report based on distance from an address?

Posted 02-28-2017 23:17
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?

• #### 7.  RE: Is there a way to create a report based on distance from an address?

Posted 02-28-2017 23:23
There was a discussion here. https://community.quickbase.com/quick...

• #### 8.  RE: Is there a way to create a report based on distance from an address?

Posted 02-28-2017 23:25
when I click that link it goes right back to the place I found this question.

• #### 9.  RE: Is there a way to create a report based on distance from an address?

Posted 03-01-2017 01:53
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