Once a web page has been generated by Integrating Excel with Maps and Earth, the connection to the original data is lost - meaning that we can't get feedback from the web app back into Excel. Using ScriptDB as a dead drop we can get round this problem by instrumenting the generated webapp to write back data that Excel can subsequent read from a cloud based noSql database.
like this...
How to configureAs far as using the dead drop is concerned, you should read ScriptDB as a dead drop, since the example use case is about Integrating Excel with Maps and Earth. GoogleMappinsg.xlsm by default will not do this. To turn it on you need to change a couple of parameters in the geocoding parameter sheet, and also set up your PC to use dead drop as described here - Getting started with deadDrop.
In the markerHtml section set these parameters as below
How this worksI wont cover the detail of deaddrop which you can follow here, but there are customizable points in the code generated by googleMapping. The parameter sections below contain customizable code. By selecting to use deaddrop test, the custom code I have provided for that is used at the hook points in the web app. You can create your own custom code by copying the default or the deaddrop test, modifying it as required and changing the "use custom" parameter in markerHtml to point at your code entry
You can get me on Google plus, Twitter or this forum. For more on this see Mapping and adding markers to maps
|
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Things that have been deprecated >