FileMaker – Find Records in a Set Radius
Having the ability to find records with an address in a set radius could come in very handy at times. Nate Williams of DB Services shows us how to do this in FileMaker 14:
Imagine a sales rep visiting a customer in an adjacent state. Since the rep is unfamiliar with the area, it would be great to have a list of nearby customers they could visit afterwards. One of the best ways to accomplish this is to perform a radius search on the customers within your FileMaker solution, evaluating the distance between the rep and each customer’s address. Let’s take a look at how to build one of these yourself using Google Maps API, some custom functions, and a couple calcs.
Bonus: there is a downloadable example file at the link.
Source: FileMaker – Find Clients in a Set Radius – DB Services