Good morning everyone!
I need to use "Spreadsheet formula" to make AppSheet calculate the geolocation of a series of addresses, I found on the net the code to perform this function on Google Sheets, configured both programs and everything works fine.
The problem arises when AppSheet has to geolocate several addresses because the formula is executed on all columns at each data update and Google Maps has a daily limit and after a while it goes in error ...
Is it possible to configure AppSheet to just add the formula on Google Sheets at each new row, avoiding the automatic recalculation of all the formulas in the sheet?
Thanks
Enzo
Solved! Go to Solution.
Welcome to the community Enzo!
See this:
Solved: Calculate Driving Miles Using Google App Script - Google Cloud Community
Welcome to the community Enzo!
See this:
Solved: Calculate Driving Miles Using Google App Script - Google Cloud Community
User | Count |
---|---|
33 | |
30 | |
30 | |
19 | |
17 |