4 Replies Latest reply on Jul 11, 2016 1:28 AM by philmcgeehan

    Using Google Directions to Get Mileage Number

    mkenglen

      Hi, All.

      I have a solution with a travel expense form embedding in it. When local mileage is calculated, at this time, I have to do it manually and enter it in the MileageNumber field. I also have AddressStarting and AddressEnding fields with the starting and ending street address. I'd like to have Google and FileMaker use those fields to calculate the total mileage from start to end, so I don't have to pull out a paper copy of the map to attach for processing.

      Has anyone made something like this work?

      I have tried this with the web viewer and I can get one address, but can't figure out how to get the total distance between two addresses.

      I am using FileMaker Pro Advanced 11 on a Mac.

       

      I'd appreciate it if someone could point me in the right direction.

      Thanks in Advance.

       

      Mary Kay