Distance from list

[Mas_Syahdan_Fil]

hi dear
i want to ask, how to formula distance from this

its possible with appsheet?

Description for the image above
when user klik “mulai perjalanan” application set geotagging to initial location
when my sales travel to a, then the application will record the location a and then add it with the initial location. when my sales continue to travel to place B,the application will record location b then add it with location a, and initial location
and this my database

i want onlytrack when user check in on different location

[Aurelien]

Hi @Mas_Syahdan_Filsafan

Mas_Syahdan_Filsafan:

i want onlytrack when user check in on different location

You may want to use a Yes/No condition, like:
[initialLocation]<>[finalLocation]

Mas_Syahdan_Filsafan:

i want to ask, how to formula distance from this

This could be helpful. Note this will use LatLong information only, which seems to fit your data:

help.appsheet.com

DISTANCE()

Distance between locations

Also, if you need “googleMaps”-ish distances (calculated from the SpreadSheet though):

Is there a (easy) way for Appsheet to calculate the "driving" distance between two addresses? Questions

Is there an easy way to calculate the distance between two points (addresses)? We use a google script to calculate the distance between addresses using google sheets. (See Script Below) Is there a way to have AppSheet call the script and get the distance in a cell? function jobdistance(start_address, end_address){ /* * Get Distance between 2 different address. * @param start_address = Address as string. Ex: "1350 SW 57th ave, miami, Florida"; * @param end_address = Addr…