Feb 07, 2022 12:41 AM
Hello all,
I have a table to document my driving activity within my business.
It has 3 colummns:
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!
Feb 07, 2022 02:09 AM
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.
Feb 07, 2022 02:25 AM
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
Feb 07, 2022 02:31 AM
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.
Feb 07, 2022 02:34 AM
Thanks - will do.
The pricing you’re linking to shows 0.00 USD? Is that correct?
Feb 07, 2022 05:57 AM
Here’s some code to nudge your project along.
May 01, 2024 05:03 AM
Can anyone just share the airtable automation code required? I tried to build it with chatgpt but was unsuccessful