Ok, total noob here. Figured out a bunch but need help.
Data comes into a table starting a new record including the name of the person, the name of the location they are at. Also is the lat/long of the place they are physically at and the lat/long of the place they’re supposed to be. Each lat/long is separated in their own fields (lat1,lon1,lat2,lon2). There is a final field (Distance) to which I want to calculate the straight line distance between those two points.
I currently have an automation that when a new record is created, it performs the script…but then where do I go from there?
Please assist. Thanks.
Hi @Paul_Tong ,
What distance measurement do you wish to use? mi, km, ft?
Do you want straight line or greater circle? Is your distance in the air or on the ground? If on the ground do you need to accommodate for roads/traffic and obstacles?