The distance between 2 coordinates JS Query

Queries and Resources
,
1

Hi,

I am running this query and the {{table1.selectedrow...}} bit is causing issues. If i plug float values into lat and lon it works though.

const getDistanceFromLatLonInKm = (lat1,lon1,lat2,lon2) => {
  var R = 6371; // Radius of the earth in km
  var dLat = deg2rad(lat2-lat1);  // deg2rad below
  var dLon = deg2rad(lon2-lon1); 
  var a = 
    Math.sin(dLat/2) * Math.sin(dLat/2) +
    Math.cos(deg2rad(lat1)) * Math.cos(deg2rad(lat2)) * 
    Math.sin(dLon/2) * Math.sin(dLon/2)
    ; 
  var c = 2 * Math.atan2(Math.sqrt(a), Math.sqrt(1-a)); 
  var d = R * c; // Distance in km
  return d;
}

const deg2rad = (deg) => {
  return deg * (Math.PI/180)
}

const lat1 = {{table1.selectedRow.data.destination_addresses['0'].location['0']}};
const lon1 = {{table1.selectedRow.data.destination_addresses['0'].location['1']}};
const lat2 = {{table1.selectedRow.data.location['0']}};
const lon2 = {{table1.selectedRow.data.location['0']}};
// const lat1 = 37.8136
// const lat2 = 33.8650
// const lon1 = 144.9631
// const lon2 = 151.2094
if (lat1 && lon1 && lat2 && lon2) {
  return getDistanceFromLatLonInKm(lat1, lon1, lat2, lon2)
}
2

Hi @yasir19! Could you help share with us in the community what kind of issue you're running into? Are you getting errors? Are your numbers not evaluating? Is the query returning a different result than expected? This would be helpful for us in the community to know so we can help unblock you as quick as possible. :slightly_smiling_face:

3

Hi @Kenny,

Sorry for not getting back to you I ended up figuring it out. However, I have run into another issue:
I am trying to change this query to a column on my table take lat1, lat2, lon1, and lon2 from a selected row on the table to something like .currentRow, so it shoots out a value for each row. If you have any insight that would be great.
Thank

image
image850×503 50.3 KB