Mapping Sheets add-on Preferences

The User Preferences dialog is part of the Mapping Sheets 2.0 version (preview) that we started rolling out as a Beta opt-in early in 2017.

The User Preferences dialog includes several sections, accessible from the sandwich menu button, as described below:



General section


In General, and any other sections, there is a Save button to save all your preferences and a Help button that would bring you to this page.



Beta section



The Beta program would give you access to new, advanced and experimental features, only in those Google Spreadsheets from where you enroll. You will keep using the stable version in any other Spreadsheet.



Document section

The Document section would include some options related with your data sheet and the way the add-on will process your data into a map
- The "data headers row index" is the row number in your sheet where the headers are (the default and most common value is 1)
- The "template for Location" would allow for multi-column address. See more details on this post.



Filters section



Find a place would show the matches for what you type on an input box and when you select a place from that list, it would place a marker on the map for that location, with a circle around using the current radius and unit, also centering the map around that place
- The default values for radius and unit you set here will be used on your map. While working with the Mapping web app, you can change the value for the radius (by clicking on the circle icon), but the unit will be what you select as default here.
- Optionally, you can set the Mapping web app to filter out any location outside the circle around the selected place.



Map section


Templates are text strings including placeholders between double mustaches {{}} with any header name as they appear in row #1 on your Sheet. You can use \n to enter a new line.
- The map Icon Title is the small text tool-tip that shows up when you hover over any location's icon
- The style map definition would create a custom map appearance available for you to choose. Find more details on this post

If you have already built a map on the active Sheet, by clicking  you will get the current default  or example values.



Infowindow section

Headers-to-Show are a comma-separated-values list with the column headers you want to include in the Info Window associated with each location on the map.

If you have already built a map on the active Sheet, by clicking  you will get the current default values.



Listing section


Templates are text strings including placeholders between double mustaches {{}} with any header name as they appear in row #1 on your Sheet. You can use \n to enter a new line.
- The Location List is the description associated with each location as they appear in the right listing dialog on the map

If you have already built a map on the active Sheet, by clicking  you will get the current default values.





Final notes
The following screenshot shows a partial map corresponding with the preferences described above ...

https://sites.google.com/a/thexs.ca/newgxs/xsmapping/mapping-sheets-add-on-preferences/prefers-mapping.png?attredirects=0


Comments