How can I create a report link field that will give me a report of the 10 nearest data entries by location?

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress
I'm creating a database to help us keep track of our projects we bid on and to be able to easily find information on other projects we did in the same basic location. So I would like to learn how to create a report link field that will give me a report of the 10 nearest projects we have bid on by location. Thank you!
Photo of Luke Fray

Luke Fray

  • 70 Points

Posted 5 months ago

  • 0
  • 1
This is not so easy to do as natively, at this time, Quick Base does not record the geocodes of the address fields.  So done properly, you will need to geocode (Latitude Longitude) your locations manually or with an add on product.

Then there is a technique to rank by distance from a location.

Contact me at QuickBaseCoach.com for an initial no charge discussion of what is involved.