Skip to main content

Adding Hyperlinks to Your Map Points

What are we talking about here?
The ability to visualize a list of addresses on a map is definitely useful - and it's what we're all about here at MapAList.  Leveraging hyperlinks within maps makes them even more interactive for you and your users.  

In this first post about hyperlinks, the goal is to show you how to associate a link to a website with a pin on your map.  This will allow whomever is viewing your map to click on a pin and see hyperlinks in the bubble that pops up. Furthermore, it will enable the viewer to click on the hyperlinks to navigate to a URL directly from the map. 

Sound cool?  It is.  Sound hard?  Don't worry, we'll walk you through it...

What does it look like from a spreadsheet perspective?
There are 2 approaches to making this work, one certainly more efficient if you are dealing with multiple address records.

In the sample spreadsheet below, you can see a column called Site which is used to associate the address with a website (URL).  You can see that in the Site column the MapAList URL has been inserted (  The next column is called Site Link (you'll have to scroll to the right on the IFrame below to see it).  Here's where those 2 different approaches come in...

1. You can simply enter the HTML in the cell.  In other words,  you can type in the following:

<a target='_new' href=''>MapAList HQ</a>

2. In order to avoid typing the HTML out for every record, you can use the CONCATENATE function and reference the cell in the Site column that contains the URL.  Instead of entering the HTML in cell D2 (column 4 row 2), you would enter the following:

=CONCATENATE("<a target='_new' href="', C2,'">", A2,"</a>")

So what the heck do those HTML tags mean?
This isn't a HTML tutorial, but we can still break it down for you briefly...

<a target='_new' href=''>MapAList HQ</a>

target='_new' - the target attribute tells your browser to open the link in a new window

href='' - the link URL tells your browser what URL to open in that new window

MapAList HQ - the link text defines what will be displayed (and clickable)

Okay, you've got the link in the spreadsheet - now what?

This is the easy part.  All you have to do is referance the column in the spreadsheet that contains your link in Step 2b where you assign your fields to your map.  Simply select column that contains the links as either the Title or Additional Info values so that they will show up in the bubble when you click on the map pin.  That's all you have to do.

Click on the image above to take a closer look

What does it look like from a map perspective?

So give it a try - click on the green pin on the map below and you'll see MapAList HQ in the pop up bubble.  Click on MapAList HQ in the pop up bubble and a new browser window will open up to

What are other users doing with this feature?
The use of hyperlinks within maps is quickly becoming a very popular feature.  The most common uses to date are: 

•Mapping companies and linking to their homepages


•Mapping friends and linking to their Facebook, LinkedIn, MySpace, or Blog pages

So get creative and give it a try!

Hope this was helpful...more to come.

--The Map Commissioner (E-mail)

Popular posts from this blog

New Video Tutorials (Updated)

We decided to experiment and create some video tutorials in the hope they might be more effective instruction and better at getting the word out about what features exist in mapalist and how to utilize them. We hope you find value in the first few we put out. Creating your First Map Using Custom Icons Starting from an Excel Sheet Editing your Maps, Post-Creation Syncing your Map and Google Sheet

Taking your Maps to the Next Level

As our user count has steadily grown, the MapAList support team has received an increasing number of calls and e-mails from users looking to do more with our solution. Over 80% of the feature requests we’ve received are, well, features that already exist within the base MapAList solution. What does that tell us? What it tells me is that we need to do a better job articulating the feature set MapAList has to offer out of the box...and that’s exactly what we’re going to do. For the next several weeks we will be publishing installments of Taking Your Maps to the Next Level – a series of short tutorials meant to enable you, the user, to get more out of MapAList. Each installment will focus on a single feature, show examples of both spreadsheets and maps, and provide step by step instructions to make it work. Here’s the current plan… 01/02/09 – Basic Grouping to Show Differentiation 01/09/09 – Advanced Grouping to Show Differentiation 01/16/09 – Adding Hyperlinks to Your Map Points 01/23/0

Allow your Member/User Base to Add Pins to your Map Using Google Forms

As the MapAList user base has grown over the past couple of years, one of the things we’ve noticed is that we have a ton of organizations leveraging our toolset to map their member/user bases. Religious organizations use MapAList to track their congregations; alumni associations use MapAList to track their members; campaigns and non-profits use MapAList to track their supporters/donors…you get the point. The reason I bring this up is because a few of these organizations have gotten smart and realized that they could push the work of updating their maps out to the user based directly using Google Forms. It’s like self check-out at the grocery store – the users love it because they are empowered (and because it’s a novelty to scan those barcodes) and so does the store because it reduces labor. Sounds cool – right? Well, implementing such a solution on your site with MapAList is not terribly difficult. Those folks at Google have made Google Forms easy to design and feed to a G