FileMaker Pro 17 User Guide: Calculating Distance Between Two Addresses

As a FileMaker Pro developer, you may have encountered situations where you need to calculate distances between two addresses. This can be particularly useful in scenarios such as calculating driving distances, fuel costs, flight times, and more. In this article, we will explore how to do just that using FileMaker Pro 17.

The Distance Matrix API is a powerful tool that allows you to calculate driving distances and routes between multiple origins and one destination. By using this API, you can easily calculate the distance between two addresses, cities, states, zip codes, or locations.

To get started, make sure you have the LAT and LON coordinates for all your addresses. Once you have these coordinates, you can use the following formula to calculate the distance:

=DRIVINGDISTANCE (A2,B2)

Enter this formula in cell C2 and press Enter to see the calculated distance between the two addresses.

The Distance Matrix API returns information based on the LAT and LON coordinates provided, allowing you to accurately calculate distances. You can use this data to create custom Google Maps functions within your FileMaker Pro 17 solution, making it easy to display the calculated distance on a map.

In addition to calculating driving distances, you can also use the Distance Matrix API to calculate air distances between two locations. This is useful for calculating flight times and distances from airport to airport.

To take your calculations to the next level, consider using VBA code to automate the process of getting Google Maps distance in meters. With this code, you can easily integrate the calculated distance into your FileMaker Pro 17 solution.

In conclusion, calculating distance between two addresses is a crucial task that can be easily accomplished using FileMaker Pro 17 and the Distance Matrix API. By following the steps outlined in this article, you will be able to calculate distances with ease and take your solutions to the next level.

Filemaker pro 17 user guide