This is part of the Step by Step Guides to get started with some of the more complex topics on this site. The full story on marker quicklinks can be found at Quicklinks and Categories What you needGoogleMapping.xlsm from the Download Complete Projects pageObjectiveTo be able to hide or show markers according to a category on a map created according to How to put markers on mapsStepsAll
Mapping activities, are controlled
by 2 parameter sheets. One is general, and tells the procedures how to
deal with the data returned from the various mapping providers
(geoCodingParameters worksheet) and the other is specific to particular
sets of data or desired results (in this case 'step by step parameters')
What just happened ?javaScript code to create these categories was generated as part of the How to put markers on maps process. If you do not want this to be displayed you can amend the web page template according to the instructions at Quicklinks and Categories, or just not include a category column in the data. As with all data items, the name of the column in which to find the categories is tailorable in the parameters sheet.What NextRead more about the detail of how all this works and walk through the source code at Mapping and adding markers to maps or see some more Step by Step Guides. In the meantime why not join our forum,follow the blog or follow me on twitter to ensure you get updates when they are available.You want to learn Google Apps Script?Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas - from VBA to Apps script, available All formats are available now from O'Reilly,Amazon and all good bookshops. You can also read a preview on O'Reilly. If you prefer Video style learning I also have two courses available. also published by O'Reilly. |
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Get Started Snippets > Step by Step Guides >