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.
Updated on Oct. 2019: Google Maps APIs now require an API key