12 Replies Latest reply on Aug 11, 2016 3:47 AM by sam0723

    Calculation of travelling time between two address


      hello, everyone, i am new to filemaker. Recently, i am working on auto-calculation of travelling time of two places.

      I have read several posts in this forum, i still don't know how to calculate the time.

      Here is my script i tried. My data are in a portal(tour details)


      Go to my portal row(first)

      Set Variable [$starting; Value: tour_details::address]

      Go to my portal row(next)

      set variable[$end; Value: Tour_details::address]

      Set field[tour_detail::distance; ""http://maps.googleapis.com/maps/api/directions/xml?origin=" & $starting & "&destination=" & $end & "&sensor=false""]


      loop should be inserted into the script as i want to calculate the time between portal line.


      So the next step, i need to parsed to get time. how could i get the time?


      i am using Filemaker 11 Pro