Discussions

Expand all | Collapse all

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?



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



  • 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
    sorry, i had not pasted in the link.


  • 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...

    You would need to gricode your addresses.


  • 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