Map calculations inside an APP

[froggerr]

Hy Guys!!

I'm working on an app that calculates the price of concert sales for a band that has 6 members.

Among the cost variables, I need to calculate the fuel cost:

1) Each member lives at an address

2) I need to calculate the distance from each member's address to the event location.

3) Add up all the routes to be able to multiply by the value of the cost/kilometer traveled.

what would be the optimal solution? Thank you all!!!

[Aurelien]

Hi @froggerr 

You may need to use an Apps Script with your Sheets in order to calculate routes.

Here is how to do so:

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Is-there-a-easy-way-for-Appsheet-to-calculate-t...

[SkrOYC]

I don't know a way to do that on AppSheet.

The only measure you can have is the linear distance between two locations when those ar latlong

https://help.appsheet.com/en/articles/2347652-distance