Hello,
I was wondering if there is a way to pull the total distance traveled for a certain date from Google maps into a field in AppSheets? Either automatically or ideally by a user clickable button in the app?
Sudo code:
On click: text_field1 = GoogleMaps.getDistanceTraveled(date)
You’d have to use automation, or use some Google Sheets magic. There’s no way to do what you want directly from AppSheet.
I found this video where it explains how to use Google Apps Script to Calculate Distance and Time in Google Sheets.
I hope this helps!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.