Tuesday, December 30, 2008

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 (http://www.mapalist.com).  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='http://mapalist.com'>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='http://mapalist.com'>MapAList HQ</a>

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

href='http://mapalist.com' - 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 http://www.mapalist.com.

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)


  1. Nice works folks. This is pretty awesome. Thank you very much for the resources!

  2. Pune city is one of the largest city of Maharashtra state. Here guide to travel of Pune with Pune city map, pune tourism map, Pune road map, location of hotel in Pune and all about Pune city. Also get about colleges in Pune, uni pune. Pune job,etc. Pune City Map

  3. Maharashtra Map | Maharashtra State Map | India in Maps. Maharashtra State Map
    Maharashtra State Map showing its political features. Get the detailed information about List of all Districts in Maharashtra, Maharashtra, Facts About Maharashtra, Maharashtra Tourism, Maharashtra Districts, government of Maharashtra, Maharashtra cities and Maharashtra Map.

  4. Programming Assignment help
    Programming Assignment Help is efficient in reducing stress from your academic life. It can save most of your time. Hence you can utilize your time in other necessary works. However, it is essential to choose a proper service; else it can trouble you badly. To avoid this, you must check the online reviews for a better Computer Science assignment

  5. Looking at divorced couples make me feel that marriages are ephemeral. But you both have proved that marriages are truly eternal. Happy anniversary. anniversary wishes messages

  6. It is nice to read such high-quality content. It is a good article that discusses the topic at hand quite well. I am looking forward to read more articles from your site. Keep up the good work.
    assignment help

  7. I’m blessed three times over. You’re a wonderful mother to my grandchild, an amazing wife to my son
    happy mothers day 2019
    happy mother day quotes