0

Calculate Distance using 2 location fields (Road miles)

I am working on a project for a friend that works for a delivery service.  The table is called “Deliveries”.  In this table I have 2 location fields, “Restaurant Address” and Customer Address”.  I needed to either calculate the road distance between the two addresses or imported from the map and store this result in another field that I have created called “Trip Distance”.  If anyone has any suggestions how to do this or suggest a website that would have the information, it would be greatly appreciated.

1 reply

null
    • Mconneen
    • 5 yrs ago
    • Reported - view

    @WiredITPro, 

    There is a similar thread on this forum.. tho I could not quickly find it.. :(.   I looked into this math some time ago.. there are numerous references .. just GTS (Google That S****)..  You will have to play around with how Ninox stores lat/long as most of the math also wants degrees and direction .. 

    What platform will you deploy ???   Let us assume Ninox Cloud.. You can then use a provided API,such as google Maps API..  Weekly Ninox hosts an integration Webinar.. Perhaps bring this request to them.. 

    You can sign up here.. https://ninoxdb.de/en/webinar

Content aside

  • 5 yrs agoLast active
  • 1Replies
  • 1166Views