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
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:
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?](https://community.appsheet.com/t/is-there-a-easy-way-for-appsheet-to-calculate-the-driving-distance-between-two-addresses/58199) 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…
1 Like
