Mapping locations - a how to video

re: Mapping locations - a how to video

Malachi Elguera — Wed, 01 Jul 2009 21:58:59 GMT

It's a great tool, but I am trying to figure out how to get that address info on to one line without having to manually copy and paste it. Do you know of any reports or functions in Excel that can do this for you?

re: Mapping locations - a how to video

Malachi Elguera — Wed, 01 Jul 2009 23:22:28 GMT

FOLLOW UP: I found this article that shows how to merge the contents of several cells and display them in one cell.

http://office.microsoft.com/en-us/excel/HP052510211033.aspx#MergeCellContents

It worked like a charm. Please feel free to email me if you have any questions and I'll try my best to help. malachi.elguera@rockchurch.com

re: Mapping locations - a how to video

CurtisHarris — Thu, 02 Jul 2009 14:43:33 GMT

I usually use the 'concatenate' command. I simply create a new column, and type =concatenate(a1," ",b1); the result will be a cell with the content of cell a1, a space and the contents of cell b1. I get a little crazy sometimes with this one and will create a bunch of html in the tool tip field, something like this...

=concatenate("<b>",a1,"</b><br><a href='",b1,"'>",b1,"</a>")

end game: when I click on the tool tip I see the church name (a1) in bold followed by a line break and the church website as a link. Actually I have a lot more data, but you get the idea.

re: Mapping locations - a how to video

andrew.lang — Thu, 02 Jul 2009 20:48:56 GMT

Curtis,

This is a very helpful tool, especially since it does the geocoding for you. What I'd like to see in your Groups 2.0 implementation is the option to do this with any group of people or households, and optionally display some or all of the following in the popup that appears when clicking on a flag:

1. Household Info (names of people, optionally children and ages)

2. Photos

3. Allow selecting or coloring flags differently based on a wide range of criteria (for example, we use substatus for identifying which campus a person attends: it would be useful to color one substatus on the map red, another blue, and a third green).

4. Control what information is visible based on who is viewing the map.

I'll post this in the Ideas area, but I just wanted to say thanks for the video and keep up the helpful tips!

Andrew Lang

re: Mapping locations - a how to video

jkoscinski — Fri, 14 Aug 2009 18:18:16 GMT

What is the best REPORT to get this data from F1?