Skip to main content
Question

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

  • October 27, 2016
  • 0 replies
  • 37 views

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?

    This topic has been closed for replies.

    There was a discussion here.

    https://quickbase-community.intuit.com/questions/1452643-can-qb-set-up-the-ability-to-search-within-...
    where?
    sorry, i had not pasted in the link.
    • anomDiebolt
    • Registered
    • October 27, 2016
    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
    • AnnSwelgin
    • Registered
    • March 1, 2017
    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?
    There was a discussion here. https://community.quickbase.com/quick...

    You would need to gricode your addresses.
    Terms & ConditionsAccessibility statement