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.”
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:
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.