Help

Re: Calculate kilometers/miles based on two adresses

2871 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!

6 Replies 6

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

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.

atusr
7 - App Architect
7 - App Architect

Can anyone just share the airtable automation code required? I tried to build it with chatgpt but was unsuccessful