Calculate kilometers/miles based on two adresses

[Csanko]

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!

[dilipborad]

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.

Google Developers

Overview  |  Distance Matrix API  |  Google Developers

Calculate travel distance and time between a number of points using the Google Maps API. Find out about usage limitations and how to get a key to get started.

[Csanko]

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]

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.

Google Developers

Google Maps Platform Pricing  |  Google Developers

[Csanko]

Thanks - will do.

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

[Bill_French]

Csanko:

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

Here’s some code to nudge your project along.

Calculate Distance Between Two Addresses Ask the community

Incorrectly, both Airtable and Zapier refer to their integration glue as a “webhook”. The correct way to describe these processes is “polling”. Airtable does not support events and webhook posts - two things that make it possible to build near-real-time integration processes. Zapier (and other integration platforms) are forced to mimic webhooks by constantly polling for changes and that’s where it gets dicey. Detecting changes in records is not always a perfect science. As such, the only way t…

[atusr]

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