
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 23, 2020 07:34 AM
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!!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 03, 2022 04:01 AM
Hi Tom,
I’m looking for something similar to your scenario. Did you find a solution?
Br,
Casper

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 23, 2022 07:51 AM
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
