Can I use appsheet to automatically calculate...

(Justin Magill) #1

Can I use appsheet to automatically calculate mileage based on two address locations? if so, any guidance?

(Aleksi Alkio) #2

Unfortunately only with LatLong values.

(Justin Magill) #3

i have those too

(Justin Magill) #4

i have a sheet with columns: Location Name, Addess, Latitude, Longitude

I also have a form for Date, Start Location, End Location, and hopefully an autocalculated milage between the two.

Right now, the start and end named are selected by enum. I’m not sure how to connect all of it for a route/mileage calculation…

(Praveen Seshadri (AppSheet)) #5

Justin, we have a function to compute distance between two points (as the crow flies). But you need road distance. For that, you’re going to need to use an external service (like Google Maps API). You might have to figure out how to integrate that into a spreadsheet formula. Eg: http://www.gadgetsappshacks.com/2014/02/calculating-distance-between-two.html

(Justin Magill) #6

Got it. Worked perfect! Thanks for your help