Demo

Demo 11 - Show Same Location Marker

Scenario: Prepare a map to view the customer's location

This scenario involves displaying all customer details and their respective locations on a map. If customers share the same geocode, their locations will be shown separately without any overlapping.

List customer location data in a Google Sheet as shown below

Map My Sheet - Demo Spreadsheet

Let's start to configure the map settings

Step 1:

Name the map as required.
Select the required sheet tab.
Select the required map type.
Select the required zoom level.
Switch on Clustering if required.(Clustering combines a group of markers into one marker with the count as a label)
Switch on Refresh automatically if required.

Step 2:

Choose type of location as "Address" and Choose the "Address" field from the Google Sheet.
To Map your Data Longitude and latitude is Mandatory.
if you already have longitude and latitude then just select the header wherever it is necessary.
else click on button which has plus(+) symbol to add latitude and longitude in your Google sheet.

Step 3:

Select the Filter is required.
Select the required column from the sheet.
Select the required type.
Click Add Filter to add more filters.
Change the order of the filter as required.

Step 4:

Select the required marker color.
Select the required animation.
Click Add Marker to add more markers.
Select the required Label. (A marker label is a letter or number that appears inside a marker.)
The Show Same Location Marker switch will come by default switched off.
Enable Show Same Location Marker, if your spreadsheet data contains identical geocodes and you wish to display each address associated with those geocodes as individual markers on the map, without any overlapping.

Step 5:

Configure the info window.
So that when the users click or hover on the marker the information will be displayed.
Click the "+" symbol to add more to the info window.
Change the order of the Info window as required.