Required headers for Mapping

Columns in your datasheet

The columns in your datasheet can have any name and order, it's up to you. However, among the many columns you can have, there are 3-key required columns that plays a special role in your map: Title, Filter, and Location.

Here's from the sample data we use for testing:

Required headers for Mapping

You must select which of those columns you are going to use for Title, Filter, and Location on the add-on sidebar. In this case we will use Name, Category, and Address.

Note: If you have changed the headers in the datasheet and still don't see them in the list, click on icon to refresh the lists.

Let's comment on the roles and restrictions of each one.

Title

The information from the column you choose as Title will appear as the header of the Infowindow that pops up when you click on a marker, and also as part of the tool tip that appears when you move your mouse over a marker.

Look for "Mapping Team" in the image below.

Filter

This is usually a column you could use to group your data under specific labels or categories. In our sample data, it is the type of data as category, but it could be anything.

The column you choose as Filter should have a reasonable small number of unique values. The Filter values will determine the icon color for each marker on the map.

On your map, you will see the values from this column as check boxes for filtering your data on the map. In the image below, we have filtered the map so it only shows the markers from the categories "1-Hints", "Extras" and "Pending".

Location (in a single column)

This is the key piece of information to place a marker on the map. It has to be something that can be converted into a pair of coordinates (latitude and longitude). That being said, it could be a simple address or a name for a location.

The add-on will use the values under the column you choose as Location, to call the Google Geocoding Api service, that would return the map coordinates that best matches each of those values


Location (in multiple columns)

If you have the full address split across several columns, you can combine them and even include some static content, into a Location template using those columns as {{placeholder}}, like for example: {{Address}}, {{City}}, {{Postcode}}, Canada

You can set the Location template under the add-on Preferences > Document

See full details and procedure on this post.


Note: For privacy reasons, the addresses on our sample map are not real; they are associated with random coordinates within the city of Toronto, Ontario, Canada.