Calculate kilometers/miles based on two adresses

Ask the community Automations
, ,
#1

Hello all,

I have a table to document my driving activity within my business.
It has 3 colummns:

  1. Start adress
  2. End adress
  3. Distance from start to end adress.

My question is: Is it possible to autopopulate the third column with the distance between 1. and 2. based on some automation/calculation/script etc. ?

Thanks in advance!

#2

Hello @Csanko
Yes, you can do it.
If you already have google maps places API then you can directly use it in AirTable Automation Script.
Or you can use some other location-based API that calculates distance based on locations.
You can use checkout more details on the attached page.
Keep in mind that you must need to enable API in the google developer console.

1 Like
#3

Hello, Thanks for reaching out in such a short amount of time.

I’m no developer, but will forward your suggestion to my “guy” to see if he can move forward with your suggestion.

If you’ve already done this, i would be very appreciative and compensate you properly for your work if you can implement it for me.

Br,
Casper

#4

Ok, let me know if your guy can’t do it.
You can use any type of place API which supports it.
Also, keep in mind that these types of APIs are not free so you also have to pay for API calls.
You can see pricing here.

#5

Thanks - will do.

The pricing you’re linking to shows 0.00 USD? Is that correct?

#6

Here’s some code to nudge your project along.

1 Like