How can we improve TrackVia? What features should come next?

formula to calculate distances between locations

A formula to calculate distances beween locations (city, state, zip code, country, latitude, longitude, etc). Also, the ability to plot locations and drive time between locations on maps would be great.

16 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    karthik mathan shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • DJ commented  ·   ·  Flag as inappropriate

        We now have the ability to calculate distances between two coordinates (latitude and longitude. You can use the following function in a Triggered Number field:

        distance({location1},{location2},”mi”)

        The first two inputs to the distance() formula would be Location fields (latitude and longitude) in the table. The last input can be "mi" for miles or "km" for kilometers.

      Feedback and Knowledge Base