Help

Re: Calculate kilometers/miles based on two adresses

1385 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Csanko
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

5 Replies 5
dilipborad
8 - Airtable Astronomer
8 - Airtable Astronomer

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.

Csanko
5 - Automation Enthusiast
5 - Automation Enthusiast

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

dilipborad
8 - Airtable Astronomer
8 - Airtable Astronomer

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.

Csanko
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks - will do.

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

Here’s some code to nudge your project along.