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

Latitude & Longitude

Love the ability when entering a location that latitude and longitude is displayed as separate entries. I would like the ability to be able to use those coordinates (Latitude & Longitude) in a formula to make our own maps, specifically for our business. I tried using the "Location" field and snipping it and also simply copying it, but neither method works.

I have no clue if this is a major issue, or can be done, but would appreciate it, if possible.

Thank you.

Lee

1 vote
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…)
    Lee Waronker shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    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...
      • Lee Waronker commented  ·   ·  Flag as inappropriate

        Alex,

        Thanks for your help. I found a workaround to use the "Location" field when exporting to Excel. This field (Location) exports as such "80204
        39.732664, -105.013986". When exporting I set "Location" to be the last field (column) when exported to Excel. In Excel, after the merge, the heading says "Location" and the Latitude & Longitude come in as above, with the comma.

        I type over the "Location" header and enter "Latitude, Longitude". Next in Excel on the ribbon I choose "Data", then "Text to Columns". Follow the steps to choose "comma delimited". This creates two separate columns; one with the header of Latitude and the other with a header of "Longitude". This Excel can now be used with most, if not all, map programs as most require a separate column for Lat & Long. Hope this helps someone with mapping data.

      • Alex commented  ·   ·  Flag as inappropriate

        Hi Lee,

        We're not certain what you mean here? Location fields can be used in a formula using the distance() function which would return the miles between those two points for a single record.

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

        Send us your use case at support@trackvia.com and we can investigate further.

        Regards,

        Alex

      Feedback and Knowledge Base