Mar 23, 2018 08:47 AM
I categorized this post under “support” because I suspect it can be accomplished without any additional functionality from Airtable but, if not, it may be more appropriate as a “feature request.”
Is it possible to have a field that calculates the distance (in miles/kil) between two address fields? I am trying to create a base to log miles driven for business since the IRS requires a milage log to take advantage of the “standard mileage deduction.”
Dec 27, 2019 08:06 AM
I checked with the Latitude and Longitude coordinates and that provides better results, but not good enough. I guess it shows the distance from point to point as a straight line and thus not via the routes we use to take.
So the next step is to replace the API, I am curious if this might work.
Mar 17, 2020 02:04 PM
me gustaría que me ayudaran a desarrollar este flujo con zapier. ya que necesito medir dos puntos de coordenadas y obtener la distancia.
Nov 06, 2021 12:55 PM
Hello,
I am trying to do the same thing. I want to calculate the distance between 2 addresses and I don’t have the coordinates (lat,long)
@Bill.French : Should I copy what you wrote and paste it somewhere ? By any chance would you have a tuto or video of the steps?
You mention the word ‘script’. Should I build a custom app based on what you wrote?
If so, which type of app should it be?
Thanks in advance for your help ! :slightly_smiling_face:
Nov 06, 2021 01:01 PM
To do this without lat/lng coordinates you can use the Google Map API that allows you to provide the two addresses and Google will figure out the distance for you.
Um, yes, but only if you have the lat/lng coordinates. This code would need to be modified significantly to accommodate your requirements.
Unfortunately, no.
Probably not. A custom app requires extensive React javascript experience and I get the sense this would be outside your wheelhouse. I recommend you find a good developer on this community to build what you need.
Jan 18, 2022 02:15 AM
I have a database with many places and their coordinates and I’m looking for a script to know all the places within x kilometers from one place.
Do you know if this is possible with Airtable?
Thanks in advance.
Thibaud -
Nov 15, 2022 04:35 AM
Hello it would be helpful if you can tell me what ‘opt’ value is. Thanks in advance.
Nov 15, 2022 10:20 AM
It is an unused param to switch between KM and Miles. O think this code was shared with the intent of it being in miles only.