Skip to main content

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 Google Spreadsheet. We at MapAList have made it easy to transform that Google Spreadsheet into a map.

Here’s the process – step by step – to make it happen…

Create a Google Form

The form creation process can be done in 1 of 2 ways – either you can create your spreadsheet and then create a form based on that spreadsheet (recommended) or you can create the form from scratch. For our purposes, let’s focus on the former.

1. Go ahead and create a new Google Spreadsheet like you would normally do – from Google Documents simply click on Create New and then select Spreadsheet.

2. Add header columns that you would like users to fill in to support the mapping process (e.g. name, address, city, state, zip, etc.). Also add at least 1 record - perhaps existing data that you have or your contact information.

3. Save your Spreadsheet and give it a name.

4. On the toolbar, click on Form and select Create a Form

At this point, Google should present you with a very basic looking Google Form that contains the columns that were on your Spreadsheet.

5. Edit your form as you see fit. You can do a lot of things with the form – such as add a theme, edit the “type” of each field, make fields mandatory. I’m not going to go into all of the details associated with this process as our friends at Google have already done that here:

6. Once you feel good about your form, go ahead and save it by clicking on the Save button in the upper right hand corner.

7. Embed the your new Google Form in your Website

Google makes this process pretty easy. All you have to do is click on More Actions and select Embed. Google will then present you with the HTML required to embed the form you have created into your website.

And we’re all you have to do is create a map in MapAList that uses the Spreadsheet you created for this process and embed that in your website as well (see working form and map below - feel free to add your info if you like).

A couple things to keep in mind when using Google Forms to feed your MapAList spreadsheet:

1. You’re relying on the user to input correct information – if they make an error you’ll have to fix it within the spreadsheet, so taking a look every once in a while is probably good practice.

2. Pins will not show up immediately after a user enters their information due to the fact that the MapAList auto-update process runs overnight. I’d suggest that you make it clear to your users that this is the case. Otherwise they will enter their info, not see it immediately reflected on the map, enter it again, get frustrated, and leave the site. You will, in turn have multiple entries in your spreadsheet for the same user along with someone who is frustrated. Neither of these things are good. Note that you can always go to the Manage page in MapAList and update your map "on demand" in order to see information that has been entered into the form show up on the map prior to the nightly update.


  1. This is fantastic! Thanks for the step by step instructions. One question: Could someone just enter a city and state to show up in a map, or is an exact address required?

  2. City and state will do just fine...

  3. This looks great. What if you only want to view a subset of data from your spreadsheet on the map. For instance, if my spreadsheets contains hospital addresses in the USA and I only want to map those in Chicago?

  4. awesome awesome AWESOME!!! Gonna do a lil dance now....

  5. Nice trial! Sound great! I have finally understood how to create a map in MapAList. Thanks!Get your essay done by a professional from online!


Post a Comment

Popular posts from this blog

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/09 – Addin…

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 …