Skip to main content

I am building out a road trip planner and would like to calculate the distance between two inputted addresses in:





  • Driving Miles


  • Driving Hours




I plan to set up a Button Field connected to this script, so every time I add a new stop along the route, I can manually run the script to determine driving distance and time (recorded in 2 separate fields) between the new stop and the previous one.



There are a number of examples using the Script Editor in Google Spreadsheets alongside the Google Maps API:


*Using the Google Maps Distance Matrix API


*Using Script Editor


*Sample



Thank you!!

Hi Tom,



I’m looking for something similar to your scenario. Did you find a solution?



Br,


Casper


Hi Tom,



I’m looking for something similar to your scenario. Did you find a solution?



Br,


Casper


This is really easy to set up using the Data Fetcher extension to connect Airtable to the Google Maps Distance Matrix API.







You can then run that API request from a button field


Reply