tag:blogger.com,1999:blog-64464486404713061052024-03-13T05:03:48.597+00:00map a listTutorials & Newsmap a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comBlogger24125tag:blogger.com,1999:blog-6446448640471306105.post-7543667307219845062020-05-17T01:27:00.002+01:002020-05-17T01:31:08.051+01:00Updates of Note - May 2020<p dir="ltr" id="docs-internal-guid-7dc7be60-7fff-e83f-6010-b33187ea716a" style="background-color: white; border: 0px; box-sizing: border-box; font-family: arial; font-size: 15px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: 1.38; margin: 0pt 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: arial; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">Hello Map Fam.</span></p><br style="background-color: white; box-sizing: border-box; font-family: arial; font-size: 14px;" /><p dir="ltr" style="background-color: white; border: 0px; box-sizing: border-box; font-family: arial; font-size: 15px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: 1.38; margin: 0pt 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: arial; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">Yeah, we know, it has been a while since our last update. Our team has been hard at work over the last few months streamlining things on the back-end - if all went to plan, you were not the wiser.</span> <span style="border: 0px; box-sizing: border-box; color: dimgrey; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">At your leisure, track updates big and small </span><a href="https://mapalist.com/releasenotes" style="background: transparent; border: 0px; box-sizing: border-box; color: #1188e6; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; outline: none; padding: 0px; text-decoration-line: none; transition: color 0.3s ease 0s; vertical-align: baseline;">here</a><span style="border: 0px; box-sizing: border-box; color: dimgrey; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">.</span></p><span style="background-color: white; font-family: arial; font-size: 14px;"> </span><p dir="ltr" style="background-color: white; border: 0px; box-sizing: border-box; font-family: arial; font-size: 15px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: 1.38; margin: 0pt 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: arial; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">We have also spent time creating <a href="https://www.youtube.com/channel/UC0CF7ZOKnCjm-bKUKllQ78Q" style="background: transparent; border: 0px; box-sizing: border-box; color: #1188e6; font-family: inherit; font-size: 14.6667px; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; outline: none; padding: 0px; text-decoration-line: none; transition: color 0.3s ease 0s; vertical-align: baseline;">video tutorials</a> </span><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: arial; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">that walk through common workflows like </span><a href="https://www.youtube.com/watch?v=jvMxiZw8zCg" style="background: transparent; border: 0px; box-sizing: border-box; color: #1188e6; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; outline: none; padding: 0px; text-decoration-line: none; transition: color 0.3s ease 0s; vertical-align: baseline;">creating your first map</a>, <a href="https://www.youtube.com/watch?v=6kLV_-sl1bY" style="background: transparent; border: 0px; box-sizing: border-box; color: #1188e6; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; outline: none; padding: 0px; text-decoration-line: none; transition: color 0.3s ease 0s; vertical-align: baseline;">starting from excel files</a>, <a href="https://www.youtube.com/watch?v=s5iUUcUHbXM" style="background: transparent; border: 0px; box-sizing: border-box; color: #1188e6; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; outline: none; padding: 0px; text-decoration-line: none; transition: color 0.3s ease 0s; vertical-align: baseline;">editing</a><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: arial; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;"> </span>and <a href="https://www.youtube.com/watch?v=paTArHNVOwo" style="background: transparent; border: 0px; box-sizing: border-box; color: #1188e6; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; outline: none; padding: 0px; text-decoration-line: none; transition: color 0.3s ease 0s; vertical-align: baseline;">syncing </a>maps, and using <a href="https://www.youtube.com/watch?v=DADk0P3goYM" style="background: transparent; border: 0px; box-sizing: border-box; color: #1188e6; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; outline: none; padding: 0px; text-decoration-line: none; transition: color 0.3s ease 0s; vertical-align: baseline;">custom pin images</a>.</p><span style="background-color: white; font-family: arial; font-size: 14px;"> </span><p dir="ltr" style="background-color: white; border: 0px; box-sizing: border-box; font-family: arial; font-size: 15px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: 1.38; margin: 0pt 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: arial; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">From a capability perspective, we added </span><span style="border: 0px; box-sizing: border-box; font-family: arial; font-size: 14.6667px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">delights </span><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: arial; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">to make your experience that much more streamlined.</span></p><p dir="ltr" style="background-color: white; border: 0px; box-sizing: border-box; font-family: arial; font-size: 15px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: 1.38; margin: 0pt 0px; padding: 0px; vertical-align: baseline;"><br style="box-sizing: border-box;" /></p><ul dir="ltr" style="background-color: white; border: 0px; box-sizing: border-box; font-family: arial; font-size: 14px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: inherit; list-style-image: initial; list-style-position: initial; margin-block-end: 0px; margin-block-start: 0px; margin: 0px; padding: 0px 0px 0px 40px; vertical-align: baseline;"><li style="border: 0px; box-sizing: border-box; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 1.38; margin: 0pt 0px; padding: 0px; vertical-align: baseline;"><span id="docs-internal-guid-e036cb61-7fff-3ec4-7598-f7a5a0a23eba" style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: arial; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">You can now create </span><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: arial; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; font-weight: 700; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">heat maps based on pin weight</span><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: arial; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">, as well as set </span><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: arial; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; font-weight: 700; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">icon size based on pin weight</span><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: arial; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">. Previously “the heat” on a heat map was based solely on pin count. A new video tutorial that walks you through it can be found </span><a href="https://www.youtube.com/watch?v=AAVptqqGxCA" style="background: transparent; border: 0px; box-sizing: border-box; color: #1188e6; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; outline: none; padding: 0px; text-decoration-line: none; transition: color 0.3s ease 0s; vertical-align: baseline;">here</a>.</li></ul><div><font face="arial"><span style="font-size: 14px;"><br /></span></font></div><a href="https://mapalist.com/map/cb1681a5-45ac-4430-896a-28be6e2ec61d"><img border="0" data-original-height="359" data-original-width="510" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuhIKDy0Tw_pNifl-8v8TW5jGtHJwLUB8zakeh4wFWNmhWzkeRMh2nvyiXLkCaowV4t-I3fQ_2RtOgeCFJvoUQ8TNwPaj_M2rQ07YKxMIQhIGkj08P3NVSABA0RpoifdZCNTUP1fA_QPOT/s320/heatmap0.png" width="320" /></a><a href="https://mapalist.com/map/a3f3045c-fa77-41fa-94f2-b5364c996e99" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" data-original-height="361" data-original-width="510" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-xC9KrQvCz4LO7x8mWl6_39TqkhImW1HbWBPYf8iUegGY5CDLsQgAnmCEIGxRHlnycnNIEONmocUoqudQ4tLT1hPNXkFEYgT4yUGe63XmkBISnvfyK7axW7AhfdI8bl7ngKIgDw3BPuCf/s320/heat.png" width="320" /></a><div><br /></div><div><div style="text-align: center;"><i><font face="arial" size="2">COVID-19 Cases as of 5/12/2020</font></i></div><div><font face="arial"><span style="font-size: 14px;"><br /></span></font></div><div><font face="arial"><span style="font-size: 14px;"><br /></span></font></div><div><ul dir="ltr" style="background-color: white; border: 0px; box-sizing: border-box; font-family: arial; font-size: 14px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: inherit; list-style-image: initial; list-style-position: initial; margin-block-end: 0px; margin-block-start: 0px; margin: 0px; padding: 0px 0px 0px 40px; vertical-align: baseline;"><li role="presentation" style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: arial; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: 1.38; list-style-type: disc; margin: 0pt 0px; padding: 0px; vertical-align: baseline; white-space: pre;"><span style="border: 0px; box-sizing: border-box; font-family: arial, helvetica, sans-serif; font-size: 14.6667px; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: inherit; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">Rather than being presented with our landing page when you log in, we are now routing you to a </span><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: inherit; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; font-weight: 700; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">customized dashboard </span><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: inherit; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">where you can sync, print, view, and see </span><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: inherit; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; font-weight: 700; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">when each of your maps was last publicly viewed</span><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: inherit; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">.</span></span><br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /></li><li role="presentation" style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: arial; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: 1.38; list-style-type: disc; margin: 0pt 0px; padding: 0px; vertical-align: baseline; white-space: pre;"><span style="border: 0px; box-sizing: border-box; font-family: arial, helvetica, sans-serif; font-size: 14.6667px; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: inherit; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">You can now </span><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: inherit; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; font-weight: 700; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">sign in with one click </span><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: inherit; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">if your username is the same as your Gmail/G Suite address. </span><span style="background-color: transparent; border: 0px; box-sizing: border-box; color: #666666; font-family: inherit; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">One click sign-up has also been enabled via OAuth2, though since you’re not a new user you probably don’t care.</span></span></li></ul><br style="background-color: white; box-sizing: border-box; font-family: arial; font-size: 14px;" /><p dir="ltr" style="background-color: white; border: 0px; box-sizing: border-box; font-family: arial; font-size: 15px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: 1.38; margin: 0pt 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; box-sizing: border-box; font-family: arial, helvetica, sans-serif; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: inherit; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">On a far less exciting note, turns out subscriptions to mapalist are considered taxable digital goods by “the man” per </span><a href="https://otr.cfo.dc.gov/release/taxation-digital-goods-district-columbia" style="background: transparent; border: 0px; box-sizing: border-box; color: #1188e6; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; outline: none; padding: 0px; text-decoration-line: none; transition: color 0.3s ease 0s; vertical-align: baseline;">D.C. Code § 47-2001(d-1)</a><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: inherit; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">. As a result, we will be implementing a </span><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: inherit; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; font-weight: 700; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">6% sales tax </span><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: inherit; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">starting this week. The incremental 6% will apply to all future charges/invoices issued.</span></span></p><span style="background-color: white; border: 0px; box-sizing: border-box; font-family: arial, helvetica, sans-serif; font-size: 14px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><p dir="ltr" style="background-color: white; border: 0px; box-sizing: border-box; font-family: arial; font-size: 15px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: 1.38; margin: 0pt 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; box-sizing: border-box; font-family: arial, helvetica, sans-serif; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: inherit; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">Do let us know if there is a pain point you are experiencing that we need to focus on. We seek that squeaky wheel.</span></span></p><span style="background-color: white; border: 0px; box-sizing: border-box; font-family: arial, helvetica, sans-serif; font-size: 14px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><p dir="ltr" style="background-color: white; border: 0px; box-sizing: border-box; font-family: arial; font-size: 15px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: 1.38; margin: 0pt 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; box-sizing: border-box; font-family: arial, helvetica, sans-serif; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: inherit; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">Stay healthy, and try to cook something different this weekend?</span></span></p><span style="background-color: white; border: 0px; box-sizing: border-box; font-family: arial, helvetica, sans-serif; font-size: 14px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><p dir="ltr" style="background-color: white; border: 0px; box-sizing: border-box; font-family: arial; font-size: 15px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: 1.38; margin: 0pt 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; box-sizing: border-box; font-family: arial, helvetica, sans-serif; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: inherit; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">Cheers,</span></span></p><p dir="ltr" style="background-color: white; border: 0px; box-sizing: border-box; font-family: arial; font-size: 15px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: 1.38; margin: 0pt 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; box-sizing: border-box; font-family: arial, helvetica, sans-serif; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; border: 0px; box-sizing: border-box; font-family: inherit; font-size: 11pt; font-stretch: inherit; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: pre-wrap;">Benjy and Brian</span></span></p></div><br /></div>map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-64040425872149441632020-05-14T15:16:00.002+01:002020-05-14T15:17:18.887+01:00Heat Maps And Icon Sizing Based on Column/Pin Weight (Video Tutorial)<font size="2"><span class="style-scope yt-formatted-string" dir="auto" style="background: rgb(249, 249, 249); border: 0px; color: #030303; font-family: arial; margin: 0px; padding: 0px; white-space: pre-wrap;">In this tutorial, we discuss how to create heat maps based on weight vs pin count, as well as how to create pin maps with the icon size being driven off of a weight column. </span><br /><span style="font-family: arial, helvetica, sans-serif;"><br /><br /></span></font>
<iframe width="560" height="315" src="https://www.youtube.com/embed/AAVptqqGxCA" frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-66314358509617259092020-02-28T05:52:00.001+00:002020-03-01T03:32:36.294+00:00New Video Tutorials (Updated)<span style="font-family: "arial" , "helvetica" , sans-serif;">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 <a href="https://mapalist.com/">mapalist</a> and how to utilize them.</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span><span style="font-family: "arial" , "helvetica" , sans-serif;">We hope you find value in the first few we put out.</span>
<br />
<br />
<label>Creating your First Map</label>
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/jvMxiZw8zCg" width="560"></iframe>
<br />
<br />
<label>Using Custom Icons</label>
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/DADk0P3goYM" width="560"></iframe>
<br />
<br />
<label>Starting from an Excel Sheet</label>
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/6kLV_-sl1bY" width="560"></iframe>
<br />
<br />
<label>Editing your Maps, Post-Creation</label>
<iframe width="560" height="315" src="https://www.youtube.com/embed/s5iUUcUHbXM" frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
<br />
<br />
<label>Syncing your Map and Google Sheet</label>
<iframe width="560" height="315" src="https://www.youtube.com/embed/paTArHNVOwo" frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-64212715724244493632019-12-13T06:20:00.001+00:002019-12-13T06:20:14.996+00:00Valid Geocode RangePer <a href="https://docs.mapbox.com/help/glossary/lat-lon/">mapbox</a>, here is some insight on geocode range (that I always have to google to remember):<br />
<br />
<div style="border: 0px; box-sizing: inherit; color: #1f3349; font-family: "Open Sans", sans-serif; font-size: 15px; margin-bottom: 18px; padding: 0px; vertical-align: baseline;">
<strong style="border: 0px; box-sizing: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Latitude and longitude</strong> are a pair of numbers (<em style="border: 0px; box-sizing: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">coordinates</em>) used to describe a position on the plane of a <a href="http://en.wikipedia.org/wiki/Latitude_and_longitude" style="border: 0px; box-sizing: inherit; color: #4264fb; cursor: pointer; margin: 0px; padding: 0px; text-decoration-line: none; transition: color 0.125s ease 0s; vertical-align: baseline;">geographic coordinate system</a>. The numbers are in decimal degrees format and range from -90 to 90 for latitude and -180 to 180 for longitude.</div>
<div style="border: 0px; box-sizing: inherit; color: #1f3349; font-family: "Open Sans", sans-serif; font-size: 15px; margin-bottom: 18px; padding: 0px; vertical-align: baseline;">
For example, Washington DC has a latitude <code style="background: rgba(31, 51, 73, 0.05); border-radius: 3px; border: 0px; box-sizing: inherit; font-family: Menlo, "Bitstream Vera Sans Mono", Monaco, Consolas, monospace; font-size: 13.5px; line-height: 1.5em; margin: 0px; padding: 2px 4px; vertical-align: baseline; white-space: pre-wrap;">38.8951</code> and longitude <code style="background: rgba(31, 51, 73, 0.05); border-radius: 3px; border: 0px; box-sizing: inherit; font-family: Menlo, "Bitstream Vera Sans Mono", Monaco, Consolas, monospace; font-size: 13.5px; line-height: 1.5em; margin: 0px; padding: 2px 4px; vertical-align: baseline; white-space: pre-wrap;">-77.0364</code>. </div>
map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-73330090768176588182019-12-05T23:24:00.001+00:002019-12-05T23:24:20.375+00:00Turkeys and bugs<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">In the spirit of Thanksgiving, we decided to ask Google for some interesting facts about Turkeys. We learned that turkeys can swim, that baby turkeys are called poults, and most importantly that in the fall turkeys eat bugs. </span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">To that end, we primarily focused on fixing <a href="https://mapalist.com/">mapalist</a> bugs in November. Here are just a few of the many bugs that our engineering team squashed. </span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://mapalist.com/releasenotes"><img border="0" data-original-height="180" data-original-width="297" height="120" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi30rk6f1MvG8CjvS8sAZKh9axAadfJ6hZQeaGnx1IaSJz4BM0IPOLVa-t88m-z2LPXCu4osChTIQmLa1k90zitt4M_NvKOrCsqNDImSS80ffhY4BWG3XsUjzFFda5rS0vAqU6OYLnDskl1/s200/deadbug.png" width="200" /></a></div>
<br />
<ul>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;"><b>Maps with more than 25,000 pins</b> were not rendering well - fixed! </span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">The pin filter was ignoring the icon filter but not vice versa - fixed!</span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;"><b>Pin search</b> was failing when the icon key was not visible - fixed!</span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">When an address failed the <b>geocoding</b> process, the process was stopping - fixed!</span></li>
</ul>
<br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Also, in the spirit of the season, we’ve added some new holiday themed pins.</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://mapalist.com/wizard/new"><img border="0" data-original-height="213" data-original-width="1049" height="128" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqZbZR_dhc2AN8oFD6nsZKPSLSb2w-ebO9Vur_MF2bdtYLkR8NWlgAEAbAoDxfvIEs7cS26QsRFhAyl7g3E1Q8bcX-JqJ3g4-qxwafQj6CMfcCGJ_Fn4ZVE22yPsZ8DwkKs6a3WwByHQBN/s640/seasonicons.png" width="640" /></a></div>
<br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><a href="https://mapalist.com/wizard/new">Get to mapping</a> once the tryptophan wears off.</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Many thanks,</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Benjy</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="color: #999999; font-family: "arial" , "helvetica" , sans-serif;">P.S. You can see the full monty of features we added this month and since this year’s reboot by checking out the ever updated <a href="https://mapalist.com/releasenotes">release notes</a>.</span></div>
map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-71291638518191876742019-11-06T12:07:00.001+00:002019-11-06T14:12:02.608+00:00Happy Feature-ween: Pin Filtering, Toggling, and Sizing, Updates to Map Printing, and Sharing, and much more.<div dir="ltr" style="line-height: 1.38; margin-bottom: 12pt; margin-top: 12pt;">
<div style="text-align: justify;">
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Boo!</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">October is now behind us and, in the spirit of Halloween, we have a number treats (in the form of new features) to share.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Dropping a ton of pins on a map can be powerful. At the same time, it can make a map cluttered and at times unwieldy. To that end, we’ve enabled the concept of <b>pin filtering</b> as well as <b>pin toggling</b>. Give it a try on your active maps...we think you’ll like it. </span></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">But that’s not all when it comes to pins! Many of you have asked about <b>resizing pins</b> - requesting the ability to make them bigger or smaller based on a specific use case. Pin size configuration is now live and in the wild allowing you to <b>start small</b> (as low as 50% of the standard pin size) or <b>go big</b> (up to 300% of the standard pin size).</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYUBatjSH-TBxD3MoYdTWM_t-3rdxXZV8IVok3LgPruU76yOAS8dZ7_bhS2kmoQBUvLPp2BRm1Vaiw16usePNpodgFp8RX6iSM4AqJ0SvDlrrASfDfSvAhkSVJRtT-r0zMH5OXmH1KILuP/s1600/nov-gif2.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1006" data-original-width="1336" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYUBatjSH-TBxD3MoYdTWM_t-3rdxXZV8IVok3LgPruU76yOAS8dZ7_bhS2kmoQBUvLPp2BRm1Vaiw16usePNpodgFp8RX6iSM4AqJ0SvDlrrASfDfSvAhkSVJRtT-r0zMH5OXmH1KILuP/s640/nov-gif2.gif" width="640" /></a></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">We get a fair number of questions about <b>printing maps</b>. To that end, we’ve added a print button to the manage maps page and map view page. We’ve also hidden some footer information upon print to make things look a bit cleaner.</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><b>Map sharing</b> has also been improved. We’ve added share buttons on the <a href="https://mapalist.com/map/manage">manage maps page</a> and refactored the share via email process.</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Every now and again we get a request to delete a user’s account. While it makes us a bit sad, we of course comply. To make the process easier, we’ve enabled a <b>self serve approach to account deletion</b> on the <a href="https://mapalist.com/a/privacy">account privacy tab</a>.</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Got questions about mapalist? If so, head on over to our <b><a href="https://mapalist.com/faq">updated FAQ page</a></b> (it’s been a long time coming) for answers.</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Got an idea for a new feature? <a href="mailto:ping@blarghlabs.com">Send us a note</a> and let us know.</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Happy mapping,</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;">Benjy and Brian</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="color: #666666; font-family: "arial" , "helvetica" , sans-serif;">P.S. You can see the full monty of features we added this month and since this year's reboot by checking out the ever updated <a href="https://mapalist.com/releasenotes">release notes</a>.</span></div>
</div>
map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-39707974072646925252019-10-08T07:59:00.001+01:002019-10-08T08:00:52.802+01:00Map Creation Just Got a Whole Lot Better...and Kittens!<span style="font-family: "arial" , "helvetica" , sans-serif;">Hello Mappers,</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">September was another fantastic month in terms of feature development. The majority of our focus over the last 30 days or so was on <b>improving the user experience associated with map creation</b>. The process has been <b>simplified and streamlined </b>through a lot of work on the back-end. There are now fewer steps and error messaging/handling is a heck of a lot better a well. Please give <a href="https://mapalist.com/wizard/new">the new map creation wizard</a> a try...we’re pretty sure it will change your life!</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Oh, and while you’re at it, feel free to select 1 of the <b>9 new kitten icons available</b>. So cute!</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgE43zh5WiKdjb0yXFcouB_OzyjeTezAWELClr8_hBFez_r-_41oP3LdqwSgNVAMkOxOK2HOO3cnuJrOgROjV6SqE47XfEMkt-o8IyRuCC8CsLCzztSgv5QAFEtt6IjXLI3kevV3KuAgI7L/s1600/Screen+Shot+2019-10-08+at+2.26.22+AM.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="68" data-original-width="611" height="71" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgE43zh5WiKdjb0yXFcouB_OzyjeTezAWELClr8_hBFez_r-_41oP3LdqwSgNVAMkOxOK2HOO3cnuJrOgROjV6SqE47XfEMkt-o8IyRuCC8CsLCzztSgv5QAFEtt6IjXLI3kevV3KuAgI7L/s640/Screen+Shot+2019-10-08+at+2.26.22+AM.png" width="640" /></a></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">In other news, we now provide <a href="https://mapalist.com/mapview/calendarmonth?year=2019&month=9"><b>granular visibility into your map views</b></a> - when each view occurred and the associated IP address in addition to the location of the viewer (nicely visualized on a map of course).</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBNlY9qGAPrqq7KVBYW-D5r_yXrdoiYfp0O0Kc_BBz9HMh15Kcr8gY1cl4Y5AggXRdeKnlrR-HwPwWfNp7KugnkRTWyXfTn-irfwUjQLTqFo-NP28mVNHN0hMz5pvVt3u_ppIQHEBumFPT/s1600/Screen+Shot+2019-10-08+at+2.31.22+AM.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="982" data-original-width="1146" height="548" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBNlY9qGAPrqq7KVBYW-D5r_yXrdoiYfp0O0Kc_BBz9HMh15Kcr8gY1cl4Y5AggXRdeKnlrR-HwPwWfNp7KugnkRTWyXfTn-irfwUjQLTqFo-NP28mVNHN0hMz5pvVt3u_ppIQHEBumFPT/s640/Screen+Shot+2019-10-08+at+2.31.22+AM.png" width="640" /></a></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;"></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;"></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">The <a href="http://mapalist.com/forgot"><b>password reset workflow</b></a> has also been refactored to make life easier...for you and for us. </span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">What’s next you ask? That’s entirely up to you. Well, maybe not entirely but we’re all about user centered design and very open to your feedback. Please shoot us a note about the feature(s) you’d like to see added in the coming months.</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Thanks for your support and happy mapping,</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Benjy and Brian</span>map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-58173147435484776522019-09-18T11:39:00.001+01:002019-09-18T11:55:29.994+01:00Password Reset Workflow Refactor<div style="text-align: center;">
<h2>
<span style="font-size: large;"><span style="font-family: "arial" , "helvetica" , sans-serif;">
We rolled out a new password reset workflow yesterday.
</span></span></h2>
</div>
<span style="font-size: large;"><span style="font-weight: normal;"><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: x-small;"><span style="font-size: xx-small;"><br /></span></span></span></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimNqu2uL37mTyOfi3yAJwgMTv0XBBq8NBrQS3B1S7JFy8r_cdnvHjcgdRPtxpqLNTolbJdZLJoLTKf_U39tejMWPejWq6jhX1Ht0OEabNtTb5a-_7KLN8CO2GIY9i-dmdiI3f8ggwwn6jm/s1600/Screen+Shot+2019-09-18+at+12.41.15+PM.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="492" data-original-width="1376" height="142" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimNqu2uL37mTyOfi3yAJwgMTv0XBBq8NBrQS3B1S7JFy8r_cdnvHjcgdRPtxpqLNTolbJdZLJoLTKf_U39tejMWPejWq6jhX1Ht0OEabNtTb5a-_7KLN8CO2GIY9i-dmdiI3f8ggwwn6jm/s400/Screen+Shot+2019-09-18+at+12.41.15+PM.png" width="400" /></a></div>
<br />
<br />
<br />
<b><span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;">Why did we spend time on this? </span></span></b><br />
<br />
<ol>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;">Sending passwords via email on reset and requiring security Q+A, ... these were normal for 2007 when we started this, but UX and opsec best practices has evolved.</span></span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;">Users had been having trouble w/ the existing workflow, which meant user pain and our time to service - more time on support means less time on developing.</span></span></li>
</ol>
<br />
<b><span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;">What was the approach?</span></span></b><br />
<br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;">Find a best practice to copy from the wild: <a href="https://slack.com/">Slack</a>. </span></span><br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9NOUsA4ANsryyjsYxoPhNo6S08u73n8L9HXdJb8Riweu0HRjbpGnofn3cZia-N93f6dp4lOESpK10jgMBcsDzpvBteX7eKosPcKx7b_AHbYYGX6JSir_KsHjw2u3ShmV93A2Q7uDRYa6x/s1600/reset+your+password.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="693" data-original-width="1273" height="216" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9NOUsA4ANsryyjsYxoPhNo6S08u73n8L9HXdJb8Riweu0HRjbpGnofn3cZia-N93f6dp4lOESpK10jgMBcsDzpvBteX7eKosPcKx7b_AHbYYGX6JSir_KsHjw2u3ShmV93A2Q7uDRYa6x/s400/reset+your+password.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;"> </span></span><br />
<br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><b><span style="font-size: small;">Nitty Gritty</span></b></span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<br />
<ul>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;">We looked for the best experience and that was slack, so we copied 90% of what we saw. </span></span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;">Magic links are not yet rolled out but are a stones throw if we so desire in the future.</span></span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;">One difference between us and slack is that some of our usernames are not emails, so we had to account for that. </span></span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;">No longer are secret question and answer requested on register, nor managed on account page. </span></span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;">In helping users w/ password issues, users can now head to the <a href="https://mapalist.com/forgot">forgot page</a> and self serve. </span></span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;">Link is only valid for 24 hours. </span></span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;">Users will get an email on password reset. </span></span></li>
</ul>
<br />
<div style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2YyM3xjxzf2p64xjj041sRfeIcRwOOquTRy7Eni8LOdIhm71qkltRA34GNsbNO3Bx28mRGflBRikYl3VbR7YJDKcTO9TGfL2hGOV3j22V0WwdCnCyWTSylQ6GlHUTrsJK_ZhZg6Cac4Q-/s1600/you+have+a+new+password+copy.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="824" data-original-width="1268" height="258" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2YyM3xjxzf2p64xjj041sRfeIcRwOOquTRy7Eni8LOdIhm71qkltRA34GNsbNO3Bx28mRGflBRikYl3VbR7YJDKcTO9TGfL2hGOV3j22V0WwdCnCyWTSylQ6GlHUTrsJK_ZhZg6Cac4Q-/s400/you+have+a+new+password+copy.png" width="400" /></a></div>
<br />
<br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;">Now back to regularly scheduled development. </span></span>map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-28977123294918505482019-09-02T13:21:00.000+01:002019-09-02T14:40:35.566+01:00Edit Maps, Pink Styling, and More Icons? It’s all here!<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div style="text-align: justify;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Hello Mappers,<br /><br />We’re proud to share that one of your most requested features is now live - the ability to <b>edit existing maps</b>. From the <a href="https://mapalist.com/map/manage">manage page</a>, simply click on the edit map button to be whisked away to a magical place that allows you to change all the settings for your map (and make your wildest dreams come true). That means no need to recreate your maps just to change the map type, advanced criteria, icons, or any other attributes for that matter. We’ve also enabled <b>map cloning </b>from the manage page as a nice to have feature.</span></div>
<div class="separator" style="clear: both; text-align: justify;">
</div>
<div style="text-align: justify;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Piggybacking on last month’s release of custom map icons, we've added support for <b>JPG and GIF formats</b> (in addition to PNG and SVG). We've also <b>added to the stock set of icons </b>available through the normal map creation process. Behind the scenes, <b>map security and privacy</b> has also been a focus.<br /><br />Last but not least, for those that want to add some flair to their maps, we’ve added <b>custom map styles</b> - pink, retro, night, aubergine*, silver, and dark. Now that map editing is enabled, you can easily give them a go on your existing maps.</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;"></span>
<br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBN0Nmx1z25bKc5RW5f0-rNMwo-Fxh5l6_8SdGxTRph3zaqziafEMo5QzX7kFY4p_D5jahucG-KbsEaBnJvMNDXenqsA3xW1h0RtG6iFtfHYja2bBiEolE-NusMtPchWDlDaPxtK2Z5_-g/s1600/septstatic0.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="864" data-original-width="1152" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBN0Nmx1z25bKc5RW5f0-rNMwo-Fxh5l6_8SdGxTRph3zaqziafEMo5QzX7kFY4p_D5jahucG-KbsEaBnJvMNDXenqsA3xW1h0RtG6iFtfHYja2bBiEolE-NusMtPchWDlDaPxtK2Z5_-g/s640/septstatic0.png" width="640" /></a></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br />It’s your creativity in mapping and direct feedback that drives our passion to evolve <a href="https://mapalist.com/">mapalist </a> Thank you and please keep it coming!<br /><br />Brian and Benjy<br /><br />*Bonus points if you know what this means without googling</span></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-4279425669762523832019-08-10T22:11:00.001+01:002019-08-10T22:32:34.375+01:00July Product Update<br />
<span style="color: #999999;"><i><span style="font-family: "arial" , "helvetica" , sans-serif;">(We neglected to post this in July)</span></i></span><br />
<br />
<span style="font-family: "arial" , "helvetica" , sans-serif;">Hello Mappers,<br /><br />Hope your summer (or winter for those in the southern hemisphere) is off to a fantastic start. <br /><br />Exciting times here at <a href="https://mapalist.com/">mapalist</a>! We’ve been busy jumping into our admittedly aging code base, rolling out new features, and thinking about what’s on the horizon. <br /><br />In the last 30 days we’ve made some awesome progress (if we don’t say so ourselves). Most of the site is now mobile friendly, Unicode/UTF8 support has been added (finally!), and a ton of old code has been refactored to improve things like synchronization between maps and sheets.<br /><br />A <a href="https://mapalist.com/releasenotes">Release Notes</a> page is now available for your viewing pleasure. It offers insight into what’s new as well as a view into what’s next in the queue development. <br /><br />Got something in mind? Please <a href="mailto:ping@blarghlabs.com">give us a shout</a> and share your ideas.<br /><br />Of course, we’ve also added <a href="https://mapalist.com/pricing">a new pricing plan</a> that now supports self service changes along with configurable usage alerts. Thank you to our current subscribers for both your support and patience as we worked out the kinks.<br /><br />Sincerely,<br /><br />Your mapalist Team</span>map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-59602741934870190042019-08-09T09:04:00.002+01:002019-08-09T09:55:30.487+01:00Custom Icons... and other Features of Note Hello Mappers,<br />
<br />
Good things are happening at <a href="https://mapalist.com/" target="">mapalist </a>and we’re excited to share them with you. Just a few days ago, we released a fun new feature that enables the use of your custom icons on your maps.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpCbaA4eSOXQ4wB6YDb4tywCUQiLMvnaFKf-4x7owH5iZDgbAOqAHcuix6Edvd6d-75kouhPnIzy3vPHPBmQCgwDjo2Sdy09I5xRDCyiD-7c7ShicMSS2zatl9Dt0mtgP6czO2oAleH0fH/s1600/custommapgif_800_1.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="579" data-original-width="800" height="463" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpCbaA4eSOXQ4wB6YDb4tywCUQiLMvnaFKf-4x7owH5iZDgbAOqAHcuix6Edvd6d-75kouhPnIzy3vPHPBmQCgwDjo2Sdy09I5xRDCyiD-7c7ShicMSS2zatl9Dt0mtgP6czO2oAleH0fH/s640/custommapgif_800_1.gif" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
Ready to give it a whirl? <a href="https://mapalist.com/a/maps">Make all your custom icon dreams come true.</a> We hope this long time coming highly requested update is intuitive, but just in case, we added a step by step.
<br />
<ol>
<li>Log in and click on your username (upper right) to visit the <a href="https://mapalist.com/a">account page</a>.</li>
<li>Click on the <a href="https://mapalist.com/a/maps">custom map settings tab</a>.</li>
<li>If you have an image ready to go, click on the box to upload (we support PNG and SVG formats).</li>
<li>If not, visit <a href="https://images.google.com/">images.google.com</a> and search for “PNG” or “SVG” followed by the type of image you’re looking for (e.g., “PNG baseball bat”, “SVG windmill”) - from there you can save and upload it.</li>
<li>Rinse and repeat for as many images you desire.</li>
</ol>
<br />
In other release related news, we’ve updated the account page with tabs making it easier to navigate. On that same page (<a href="https://mapalist.com/a/billing">on the billing tab</a>), we’ve also added transparency in addition to enabling you to download invoices and receipts. Our full release notes, as always, can be found <a href="https://mapalist.com/releasenotes">here</a>.
<br />
<br />
Want to weigh in on our next set of features? <a href="https://forms.gle/QLSiWbYFbKpremTR9">Take this 1 question survey</a> and help us decide what to build next.<br />
<br />
You all have created nearly 700,000 maps using our solution to date; for that we’re amped and thankful.<br />
<br />
Party on!<br />
<br />
Sincerely,<br />
Brian and Benjymap a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-4676883526882632112019-05-27T23:16:00.001+01:002019-05-27T23:16:50.167+01:00Free to Freemium: The Path (and Impetus)<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /><br />Hello Map Creators, </span><br />
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Since 2007, we have provided you the ability to quickly create, view, share, and update an unlimited number of maps at no cost. What was created around a simple use case for a friend’s wedding (see below) turned into a useful solution for a user base of now over 115,000. Huzzah! </span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><img height="382" src="https://lh6.googleusercontent.com/ZWJkMowc82GYIDto5V9UHMgTN_nnpb2b2J2fKzbT0tz5uDpsu8FHv9fJEsmqRlkzatDZUWyowzkRxNnPjiHwY7IVVckoC4dj8iCivGGwdXD8X1yhU9BXQR-AKbxUWSoNOk_pb8Uj" width="640" /> </span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Over the past 12 years, we’ve received donations from happy users that have covered a small portion of our costs. More than anything though, each donation made us smile and reinforced our desire to continue supporting the solution year over year. Thanks to all of you that have kept us motivated! </span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">This model was sustainable until <a href="https://geoawesomeness.com/developers-up-in-arms-over-google-maps-api-insane-price-hike/" target="_blank">Google, out of nowhere, announced a new pricing policy</a> for developers (like us) using their mapping services. In the spring of 2018, Google started charging heavily for maps usage - they essentially raised prices by 1400%. </span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">For a year, we continued to self-fund the solution, but recently reached a point where the model became unsustainable. To that end, we’ve decided to add a paid plan to our service. </span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">MapAList will remain 100% free of charge for users that have fewer than 10 maps and fewer than 100 views per map. For those exceeding these limits, we have created <a href="https://mapalist.com/pricing" target="_blank">a simple monthly paid plan</a> allowing for the creation of an unlimited number of maps, and up 2000 map views across all maps in your account per month. </span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">We realize that some users will require more than 2000 map views per map per month and are actively working on a solution. Please feel free to <a href="mailto:help@mapalist.com" target="_blank">shoot us a note</a> in the meantime if you can’t wait. </span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Thank you for your support over the years and for sticking with us as things evolve - we sincerely appreciate it, </span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Your <a href="https://mapalist.com/" target="_blank">MapAList</a> Team </span></div>
map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-15418686662967758232014-04-10T18:29:00.002+01:002014-04-10T18:35:25.204+01:00Now Supporting The New Google Sheets: Upgrade Steps for Legacy UsersHowdy.<br />
<br />
Just a quick post to announce we recently launched support for the new Google Sheets -- I think they were previously called Google Spreadsheets, but alas, the new name and UI are more aerodynamic...<br />
<br />
MapAList has recently been updated to support the new Google Sheets.<br />
<br />
To harness these new features, one must re-authorize MapAList's access to one's Google Docs. (Note: This is only required for legacy users.)<br />
<br />
Take no action and only (the old) Google Spreadsheets will be supported. Follow the steps below, to keep up with the Joneses, and be able to map from the new Google Sheets, as well as the old format.<br />
<br />
<b>Steps:</b><br />
1) Go to <a href="http://mapalist.com/" target="_blank">mapalist.com</a> and log in<br />
2) Go to <a href="http://mapalist.com/Public/GoogleAuth.aspx" target="_blank">MapAList's Google Auth Page</a><br />
3) Click "Accept" on the Google page to enable MapAList to use your Google Sheets on your behalf<br />
3.5) 10 push-ups, because if you don't have your health...<br />
4) Try creating your map again<br />
5) Let us know how you fared<br />
<br />
What you are doing is switching your account from AuthSub (the way we previously accessed users' spreadsheets) to OAuth2 (the new way), and the new way should enable the new Google Sheets to work in MapAList.<br />
<br />
Good luck, and please let us know how it goes.<br />
<br />
Cheers,<br />
Brianmap a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-56312937437644444342010-11-28T15:34:00.018+00:002010-11-30T08:11:20.116+00:00Allow your Member/User Base to Add Pins to your Map Using Google Forms<div style="text-align: left;"><p class="MsoNormal">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.<span style="mso-spacerun:yes"> </span>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.</p></div> <p class="MsoNormal">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.<span style="mso-spacerun:yes"> </span>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.</p> <p class="MsoNormal">Sounds cool – right?<span style="mso-spacerun:yes"> </span>Well, implementing such a solution on your site with MapAList is not terribly difficult.<span style="mso-spacerun:yes"> </span>Those folks at Google have made Google Forms easy to design and feed to a Google Spreadsheet.<span style="mso-spacerun:yes"> </span>We at MapAList have made it easy to transform that Google Spreadsheet into a map. </p> <p class="MsoNormal">Here’s the process – step by step – to make it happen…</p> <p class="MsoNormal"><b style="mso-bidi-font-weight:normal"><u>Create a Google Form<o:p></o:p></u></b></p> <p class="MsoNormal">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.<span style="mso-spacerun:yes"> </span>For our purposes, let’s focus on the former.</p><p class="MsoNormal"></p><p class="MsoListParagraphCxSpFirst" style="margin-left:.25in;mso-add-space:auto; text-indent:-.25in;mso-list:l0 level1 lfo1"><!--[if !supportLists]--><span style="mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin"><span style="mso-list:Ignore">1.<span style="font:7.0pt "Times New Roman""> </span></span></span><!--[endif]-->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.</p> <p class="MsoListParagraphCxSpMiddle" style="margin-left:.25in;mso-add-space: auto;text-indent:-.25in;mso-list:l0 level1 lfo1"><!--[if !supportLists]--><span style="mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin"><span style="mso-list:Ignore">2.<span style="font:7.0pt "Times New Roman""> </span></span></span><!--[endif]-->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.</p> <p class="MsoListParagraphCxSpLast" style="margin-left:.25in;mso-add-space:auto; text-indent:-.25in;mso-list:l0 level1 lfo1"><!--[if !supportLists]--><span style="mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin"><span style="mso-list:Ignore">3.<span style="font:7.0pt "Times New Roman""> </span></span></span><!--[endif]-->Save your Spreadsheet and give it a name.</p><p class="MsoNormal"><span style="mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin"><span style="mso-list:Ignore"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSKMvoSieS6Kcm7DabKu1VodUpxCs6-gLrTLEJF82tCwNqBFVF_eoIuwLknrK_Ul4lVklVRIBcp8FlyrfyZXV85_DA-78LTELEjdPkzz1iTh7P_24JNigN5UhVv2Pe4ejDoOObt0UZqk-B/s1600/Form+1.PNG"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 180px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSKMvoSieS6Kcm7DabKu1VodUpxCs6-gLrTLEJF82tCwNqBFVF_eoIuwLknrK_Ul4lVklVRIBcp8FlyrfyZXV85_DA-78LTELEjdPkzz1iTh7P_24JNigN5UhVv2Pe4ejDoOObt0UZqk-B/s400/Form+1.PNG" border="0" alt="" id="BLOGGER_PHOTO_ID_5544626220430429410" /></a>4.<span style="font:7.0pt "Times New Roman""> </span></span></span>On the toolbar, click on Form and select Create a Form </p><p class="MsoNormal"><span class="Apple-style-span" style="color: rgb(0, 0, 238); -webkit-text-decorations-in-effect: underline; "><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4HPZi-unNtVk_mhMB_z1CkFcJfi-pUdFBvfQdSnZVK2ggiCRRVIHuga-iniARtR7MLbyLSekyP6TdQsd4whSXhxT3-SXqtK8yggUQRQ_uMQ33-j1-SGae62MkQAkMU7MeTZtiWuRFqzwq/s400/Form+2.PNG" border="0" alt="" id="BLOGGER_PHOTO_ID_5544626970593062146" style="display: block; margin-top: 0px; margin-right: auto; margin-bottom: 10px; margin-left: auto; text-align: center; cursor: pointer; width: 400px; height: 200px; " /></span></p> <p class="MsoNormal">At this point, Google should present you with a very basic looking Google Form that contains the columns that were on your Spreadsheet.</p> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj759mEk9f4c7hh8PD30JcXJhsxbjRl7ttGqbQWXt-pbvLtnDNUybI4mC57oSNSChZl7S3KIkW7v4N2f7GXWr09elepYPf5psMNsYlqUdHRZnHYzv1ovEyK4V7L72HaYFWSvNO6IIHogcpX/s1600/Form+3.PNG"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj759mEk9f4c7hh8PD30JcXJhsxbjRl7ttGqbQWXt-pbvLtnDNUybI4mC57oSNSChZl7S3KIkW7v4N2f7GXWr09elepYPf5psMNsYlqUdHRZnHYzv1ovEyK4V7L72HaYFWSvNO6IIHogcpX/s400/Form+3.PNG" border="0" alt="" id="BLOGGER_PHOTO_ID_5544627209977082498" style="display: block; margin-top: 0px; margin-right: auto; margin-bottom: 10px; margin-left: auto; text-align: center; cursor: pointer; width: 400px; height: 384px; " /></a><p class="MsoNormal"><span style="mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin"><span style="mso-list:Ignore">5.<span style="font:7.0pt "Times New Roman""> </span></span></span>Edit your form as you see fit.<span style="mso-spacerun:yes"> </span>You can do a lot of things with the form – such as add a theme, edit the “type” of each field, make fields mandatory.<span style="mso-spacerun:yes"> </span>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: <a href="http://docs.google.com/support/bin/topic.py?topic=15166">http://docs.google.com/support/bin/topic.py?topic=15166</a></p><p></p> <p class="MsoNormal"><span style="mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin"><span style="mso-list:Ignore">6.<span style="font:7.0pt "Times New Roman""> </span></span></span>Once you feel good about your form, go ahead and save it by clicking on the Save button in the upper right hand corner.</p><p class="MsoNormal">7. Embed the your new Google Form in your Website</p> <p class="MsoNormal">Google makes this process pretty easy.<span style="mso-spacerun:yes"> </span>All you have to do is click on More Actions and select Embed.<span style="mso-spacerun:yes"> </span>Google will then present you with the HTML required to embed the form you have created into your website.</p> <span class="Apple-style-span" style="color: rgb(0, 0, 238); -webkit-text-decorations-in-effect: underline; "><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5scsufRRhZnnbsSU-701weL3tF34OmQ1yoJ2CBWW1L4PqcPclNvZwxQ7P4wM1aCnjiMB5y9vo8jabKtxVCIhMPjVmy_AnGn54S3Y_yOplWcTHzB95FBwzcdOEMS7hKH6FX_Att2Jblsrc/s400/Form+4.PNG" border="0" alt="" id="BLOGGER_PHOTO_ID_5544627412730865538" style="display: block; margin-top: 0px; margin-right: auto; margin-bottom: 10px; margin-left: auto; text-align: center; cursor: pointer; width: 400px; height: 355px; " /></span><p class="MsoNormal">And we’re done...now 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). </p> <p class="MsoNormal"><o:p> </o:p></p> <p class="MsoNormal"><iframe src="https://spreadsheets0.google.com/embeddedform?formkey=dEMtQ2hJYkdVMnRyQWtkLXFpRm5BX1E6MQ" width="100%" height="850" frameborder="0" marginheight="0" marginwidth="0">Loading...</iframe></p> <p class="MsoNormal"><iframe id="ifMap" width="100%" height="420" frameborder="0" scrolling="no" allowtransparency="true" src="http://mapalist.com/Public/pm.aspx?mapid=144554"></iframe></p><p class="MsoNormal">A couple things to keep in mind when using Google Forms to feed your MapAList spreadsheet:</p> <p class="MsoListParagraphCxSpFirst" style="margin-left:.25in;mso-add-space:auto; text-indent:-.25in;mso-list:l1 level1 lfo1"><!--[if !supportLists]--><span style="mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin"><span style="mso-list:Ignore">1.<span style="font:7.0pt "Times New Roman""> </span></span></span><!--[endif]-->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.</p> <p class="MsoListParagraphCxSpLast" style="margin-left:.25in;mso-add-space:auto; text-indent:-.25in;mso-list:l1 level1 lfo1"><!--[if !supportLists]--><span style="mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin"><span style="mso-list:Ignore">2.<span style="font:7.0pt "Times New Roman""> </span></span></span><!--[endif]-->Pins will not show up immediately after a user enters their information due to the fact that the MapAList auto-update process runs overnight.<span style="mso-spacerun:yes"> </span>I’d suggest that you make it clear to your users that this is the case.<span style="mso-spacerun:yes"> </span>Otherwise they will enter their info, not see it immediately reflected on the map, enter it again, get frustrated, and leave the site.<span style="mso-spacerun:yes"> </span>You will, in turn have multiple entries in your spreadsheet for the same user along with someone who is frustrated.<span style="mso-spacerun:yes"> </span>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.</p>map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-62178030657759665252009-11-07T16:41:00.008+00:002010-04-17T19:10:41.522+01:00Concentration/Heat Maps Are Here!<div style="text-align: left;">Hello MapAList Faithful - it's been a while!</div><br />Our most recent release includes a new map type called "Concentration/Heat Map."<br /><br />This new map type is great for large data sets with many addresses. It essentially creates a map in which the density of color (red) displayed is higher in areas with more addresses.<br /><br />The creation process is super simple...just choose "Concentration/Heat Map" in step 4 of the mapping process and you're good to go. Check it out:<br /><br /><div><span class="Apple-style-span" style="color: rgb(0, 0, 238); -webkit-text-decorations-in-effect: underline; "><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1U9yE8Hn0bfnSzvLYZhbb1X0UCl1VedpdsaFCHgUFk_Assy9NZ6fbxZ04wSYrmlee8KWNScj456WZIcf9grV2UZDBS_W-cougY9fKJaon_pYciEB9rLRA-lGSMOCupGPPDAiWMV06ihZ9/s400/Step+4.png" border="0" alt="" id="BLOGGER_PHOTO_ID_5401404735117542690" style="display: block; margin-top: 0px; margin-right: auto; margin-bottom: 10px; margin-left: auto; text-align: center; cursor: pointer; width: 400px; height: 228px; " /></span>The rest should be very straightforward with a result that looks like the map you see below (note that I have about 4000 points in my Google Spreadsheet):</div><div><br /><iframe id="ifMap" width="100%" height="620" frameborder="0" scrolling="no" allowtransparency="true" src="http://mapalist.com/Public/pm.aspx?mapid=98402" ></iframe><br /><br /></div><div>Unfortunately, right now Concentration/Heat Maps don't allow you to see actual points on the map or click on them and get a pop up bubble, but if you have a big data set this might be just what you're looking for.</div><div><br /></div><div>If you have a large data set, give it a go and see what you think...</div><div><br /></div>map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-68698403005914367732009-03-15T20:09:00.010+00:002009-03-20T00:14:02.421+00:00A MapAList Milestone - 5000 Users!<div>Roughly 18 months ago we launched <span class="blsp-spelling-error" id="SPELLING_ERROR_0">MapAList</span> with no publicity whatsoever. Brian, our founder, head developer, and resident visionary, shared his excitement around the solution with friends and family triggering our user base to slowly begin growing. </div><div><br /></div><div>Within a few months a handful of publications picked up on the simplicity and utility of <span class="blsp-spelling-error" id="SPELLING_ERROR_1">MapAList</span> and started to help us spread the word. <a href="http://lifehacker.com/400382/map-a-list-puts-spreadsheet-addresses-on-google-maps"><span class="blsp-spelling-error" id="SPELLING_ERROR_2">LifeHacker</span>.com</a> was one of the first and gave us a huge boost. A week or so later <a href="http://www.chicagotribune.com/technology/orl-ymhowto2408aug24,0,58713.story">The Chicago Tribune</a>, <a href="http://www.orlandosentinel.com/technology/orl-ymhowto2408aug24,0,6907811.story">The Orlando <span class="blsp-spelling-error" id="SPELLING_ERROR_3">Sentinal</span></a>, and <a href="http://www.baltimoresun.com/topic/orl-ymhowto2408aug24,0,2648966.story">The Baltimore Sun</a> featured <span class="blsp-spelling-error" id="SPELLING_ERROR_4">MapAList</span> in <span class="blsp-spelling-corrected" id="SPELLING_ERROR_5">their</span> "How 2" column and things really started to heat up.<br /></div><div><br /></div><div><div>From churches and wine distributors to real estate agents and news <span class="blsp-spelling-corrected" id="SPELLING_ERROR_6">organizations</span>, our users were finding creative and unique ways to make the most of <span class="blsp-spelling-error" id="SPELLING_ERROR_7">MapAList</span>. </div></div><div><br /></div><div>International press soon followed with articles in <a href="http://abava.blogspot.com/2008/12/blog-post_5146.html">Russian</a>, Indian, and <a href="http://media.baliz-geospatial.com/fr/blogue/mapalist-geocodage-entre-google-docs-et-google-maps">French</a> publications just to name a few. An influx of Brazilian users soon made us aware that we had been featured in <a href="http://info.abril.com.br/">Info <span class="blsp-spelling-error" id="SPELLING_ERROR_8">Exame</span></a> (a highly-popular Brazilian technology magazine). Users all over the world were leveraging <span class="blsp-spelling-error" id="SPELLING_ERROR_9">MapAList</span> to visualize <span class="blsp-spelling-corrected" id="SPELLING_ERROR_10">their</span> lists and share them with <span class="blsp-spelling-corrected" id="SPELLING_ERROR_11">their</span> own user bases on the web.</div><div><br /></div><span class="Apple-style-span" style="font-weight: bold;"><span class="Apple-style-span" style="text-decoration: underline;">On March 14<span class="blsp-spelling-error" id="SPELLING_ERROR_12">th</span>, 2009 at 9:53 AM Eastern time, our 5000<span class="blsp-spelling-error" id="SPELLING_ERROR_13">th</span> user created an account and began visualizing his lists using <span class="blsp-spelling-error" id="SPELLING_ERROR_14">MapAList</span>.</span></span> <div><br /></div><div>This <span class="blsp-spelling-corrected" id="SPELLING_ERROR_15">marked</span> an incredible milestone for the <span class="blsp-spelling-error" id="SPELLING_ERROR_16">MapAList</span> team. Thank you all for your enthusiasm around our solution and your excellent questions, comments, and ideas that ultimately make <span class="blsp-spelling-error" id="SPELLING_ERROR_17">MapAList</span> better. </div><div><br /></div><div>Also, <span class="Apple-style-span" style=""><span class="Apple-style-span" style="text-decoration: underline;">t</span></span><span class="Apple-style-span" style="text-decoration: underline;"><span class="Apple-style-span" style="">hank your for your donations</span></span> - they are much appreciated and help keep our free service afloat. Please keep them coming...</div><div><br /></div><div><div><div><a href="https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=help%40mapalist%2ecom&item_name=Support%20MapAList%20Fund&page_style=PayPal&no_shipping=1&return=http%3a%2f%2fmapalist%2ecom%2fPublic%2fYouAreAwesome%2easpx&cancel_return=http%3a%2f%2fmapalist%2ecom%2fPublic%2fYouAreAwesome%2easpx&cn=Optional%20Message&tax=0¤cy_code=USD&lc=US&bn=PP%2dDonationsBF&charset=UTF%2d8"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6qLMWYSLrfJPOed9uthHg7nK5EYeizkaD8lbxYnLtNGm4tzb1DcdrjalhMWmljSlmviW5R5w0U7tBdbfIUaxzf990ekBASB0lHniEzLSPXoA8l4TYv2kLkpDUpaqOLOWfpZO9QWXmqFDH/s400/Picture1.png" alt="" id="BLOGGER_PHOTO_ID_5313523419059358546" style="cursor: pointer; width: 63px; height: 32px;" border="0" /></a><br /></div><div><br /></div><div>--The Map Commissioner (<a href="mailto:bmokotoff@mapalist.com">E-mail</a>)<br /></div><div><br /></div></div></div>map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-1667393086752036602009-03-15T19:53:00.007+00:002009-03-15T21:08:00.867+00:00Do You Live In Atlanta, GA?<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0hs_pEUx_OPq276URUBFQBEtlEkuLA6KZPmFhK5e8eIUNpQyHIFr00NKO9_8Yh9z4QqzbZZ7bbnB9ccnTaspNifmWT2v1zBWvDY8VaU5VvV3zzfaVaF5Y1H64eYSu9WHhAjWi9OOezlim/s1600-h/ATL_noshell.jpg"><img style="float:right; margin:0 0 10px 10px;cursor:pointer; cursor:hand;width: 267px; height: 400px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0hs_pEUx_OPq276URUBFQBEtlEkuLA6KZPmFhK5e8eIUNpQyHIFr00NKO9_8Yh9z4QqzbZZ7bbnB9ccnTaspNifmWT2v1zBWvDY8VaU5VvV3zzfaVaF5Y1H64eYSu9WHhAjWi9OOezlim/s400/ATL_noshell.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5313507901809666338" /></a><div><span class="Apple-style-span" style=" ;font-family:'Times New Roman';"><div style="border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; width: auto; font: normal normal normal 100%/normal Georgia, serif; text-align: left; "><div><span class="Apple-style-span" style="font-size:medium;">If so you should definitely check out our most recent endeavour - an IPhone app called </span><a href="http://areyousafeatlanta.com/"><span class="Apple-style-span" style="font-style: italic; "><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="color: rgb(51, 102, 255); ">AreYouSafe Atlanta</span></span></span></a><span class="Apple-style-span" style="font-size:medium;">.</span><div><span class="Apple-style-span" style="font-size:medium;"><br /></span></div><div><a href="http://areyousafeatlanta.com/"><span class="Apple-style-span" style="font-style: italic; "><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="color: rgb(51, 102, 255); ">AreYouSafe Atlanta</span></span></span></a><span class="Apple-style-span" style="font-size:medium;"> lets you know how safe you are at any given time based on your current location within the city. All it takes is a quick tap to see a simple visual depiction of your safely level in addition to hyperlocal crime data broken down by type. Detailed crime statistics for the entire city of Atlanta, GA are pushed through a series of algorithms before producing a relative safety level for your exact geographic location.<br /></span><div><span class="Apple-style-span" style="font-size:medium;"><br /></span></div><div><span class="Apple-style-span" style="font-size:medium;">Walk/drive/bike/bus/canoe around the city and see your safety status update as you go!</span></div><div><span class="Apple-style-span" style="font-size:medium;"><br /></span></div><div><span class="Apple-style-span" style="font-size:medium;">More cities coming soon...</span><br /></div><div><br /></div><div><a href="http://itunes.apple.com/WebObjects/MZStore.woa/wa/viewSoftware?id=307511685&mt=8"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHMndH8hc6jbR_b6l6xn3100nm56oDdH3Y4rGsMr3mIDJ3cE96Nou5KNGJUo1GismBQrq2-joDQ4grc7PCMZLHPjc7ruFa1rKqwQ-QhrZH8HLYgZShHe22VcFfUWCqAJZIkm7AK1sedv0e/s400/button_app_store.gif" border="0" alt="" id="BLOGGER_PHOTO_ID_5302703009148060194" style="cursor: pointer; width: 142px; height: 45px; " /></a><br /></div><div><br /></div></div></div></div></span></div>map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-16327203134806694702009-02-14T14:36:00.016+00:002009-02-14T17:24:32.869+00:00Do You Live in Washington, DC?<div style="text-align: left;"><a href="http://areyousafedc.com/"><br /></a></div><img style="float:right; margin:0 0 10px 10px;cursor:pointer; cursor:hand;width: 267px; height: 400px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5wqRiztDvCWx6V33X4rYrTKsVCYqwBr_Qo8beq_FU4-H15CQuryC0uQYhjB5PZS-qY-lyhr8o3xEc2hBeSk-V73JVobLkrRpGI3_gWCyXzt1BVslyOocjwW3h20krC6JYET97-8cJx0dv/s400/noshell.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5302665665043546002" /><span class="Apple-style-span" style="font-size:medium;">If so you should definitely check out our most recent endeavour - an IPhone app called </span><a href="http://areyousafedc.com/"><span class="Apple-style-span" style="font-style: italic;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="color: rgb(51, 102, 255);">AreYouSafe DC</span></span></span></a><span class="Apple-style-span" style="font-size:medium;">.</span><div><span class="Apple-style-span" style="font-size:medium;"><br /></span></div><div><a href="http://areyousafedc.com/"><span class="Apple-style-span" style="font-style: italic;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="color: rgb(51, 102, 255);">AreYouSafe DC</span></span></span></a><span class="Apple-style-span" style="font-size:medium;"> lets you know how safe you are at any given time based on your current location within the city. All it takes is a quick tap to see a simple visual depiction of your safely level in addition to hyperlocal crime data broken down by type. Detailed crime statistics for the entire city of Washington, DC are pushed through a series of algorithms before producing a relative safety level for your exact geographic location.<br /></span><div><span class="Apple-style-span" style="font-size:medium;"><br /></span></div><div><span class="Apple-style-span" style="font-size:medium;">Walk/drive/bike/bus/canoe around the city and see your safety status update as you go!</span></div><div><span class="Apple-style-span" style="font-size:medium;"><br /></span></div><div><span class="Apple-style-span" style="font-size:medium;">More cities coming soon...</span><br /></div><div><br /></div><div><a href="http://itunes.apple.com/WebObjects/MZStore.woa/wa/viewSoftware?id=302732248&mt=8"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHMndH8hc6jbR_b6l6xn3100nm56oDdH3Y4rGsMr3mIDJ3cE96Nou5KNGJUo1GismBQrq2-joDQ4grc7PCMZLHPjc7ruFa1rKqwQ-QhrZH8HLYgZShHe22VcFfUWCqAJZIkm7AK1sedv0e/s400/button_app_store.gif" border="0" alt="" id="BLOGGER_PHOTO_ID_5302703009148060194" style="cursor: pointer; width: 142px; height: 45px; " /></a><br /></div><div style="text-align: center;"><br /></div></div>map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-52507807333143231062009-01-28T21:57:00.004+00:002009-01-30T12:50:23.129+00:00Adding Images & IFrames to your Map Points<p class="MsoNormal"><b><span style="font-family:Georgia;color:black;">What are we talking about here?</span></b><span style="font-family:Georgia;color:black;"><o:p></o:p></span></p> <p class="MsoNormal"><span style="font-family:Georgia;color:black;">So let’s say you have a map that depicts all of the countries you have visited.<span style="mso-spacerun:yes"> </span>It’s one thing to have a pin in France and show “Paris, 2008” in the pop up bubble, but it would be a heck of a lot cooler if you could click on that pin and see an image of you next to the Eifel Tower. <o:p></o:p></span></p> <p class="MsoNormal">Alternatively, maybe you’re looking to provide some information about <st1:country-region st="on"><st1:place st="on">France</st1:place></st1:country-region> to the person looking at the map.<span style="mso-spacerun:yes"> </span>The ability to integrate an IFrame into the pin pop up bubble makes it easy to show the user a fully functional website about French tourism when they click on the pin.<br /></p> <p class="MsoNormal">If you followed the couple tutorials that talked about hyperlinks, e-mail and Skype this should be a piece of cake…<br /></p> <p class="MsoNormal"><span style="font-family:Georgia;color:black;"><span style="mso-spacerun:yes"> </span><br /><b>What does it look like from a spreadsheet perspective?</b><o:p></o:p></span></p> <p class="MsoNormal"><span style="font-family:Georgia;color:black;">Just like our last 2 tutorials, the key here is all in the way you enter data into your Google Spreadsheet. Again, a bit of HTML is all you need. <o:p></o:p></span></p> <p class="MsoNormal">Take a look at the second column in the spreadsheet titled Image. It contains the HTML required to place an image in your pin pop up bubble.<br /></p> <p class="MsoNormal">The third column (you will have to scroll right), titled IFrame, contains the HTML required to display an IFrame in your pin pop up bubble. <br /><br /><iframe src="http://spreadsheets.google.com/pub?key=pqacvdx2XdPfGjeD7Cb4QUw&output=html&gid=0&single=true" width="400" frameborder="0" height="200"></iframe><br /></p><p class="MsoNormal">Feel free to us the CONCATENATE function to make life easier if you want as explained in the a previous post (<a href="http://mapalist.blogspot.com/2008/12/hyperlinks-part-1-links-to-websites.html">Adding Hyperlinks to Your Map Points</a>).<br /></p> <p class="MsoNormal">The HTML, while a bit more complex than that needed to produce e-mail and Skype links, is still relatively self explanatory.<span style="mso-spacerun:yes"> </span>In both cases, all you are doing is providing the location of the Image/IFrame.<span style="mso-spacerun:yes"> </span>The IFrame requires some sizing – feel free to play with that to make it appear how you like it. <br /></p> <p class="MsoNormal">You guessed it - from here, all you have to do is assign your fields in<span class="apple-converted-space"> </span><b>Step 2b</b><span class="apple-converted-space"> </span>of the map creation process and you're good to go. If you have questions feel free to post to the<span class="apple-converted-space"> </span><a href="http://mapalist.com/Public/Help.aspx?tab=forum">help forum</a>.<br /></p> <p class="MsoNormal"><br /></p><p class="MsoNormal"><span class="Apple-style-span" style="font-weight: bold; ">What does it look like from a map perspective?</span><br /></p> <p class="MsoNormal"><span style="font-family:Georgia;color:black;">As you might expect, we see the 2 pins plotted on the map below. When you click on the pin in <st1:country-region st="on">France</st1:country-region> you will see an image of the French flag (sorry, I didn’t have a picture of you next to the <st1:place st="on"><st1:placename st="on">Eifel</st1:placename> <st1:placetype st="on">Tower</st1:placetype></st1:place>). <span style="mso-spacerun:yes"> </span><o:p></o:p></span></p> <p class="MsoNormal"><span style="font-family:Georgia;color:black;"><o:p>Okay, now try clicking on the other pin – which happens to be in <st1:country-region st="on"><st1:place st="on">Israel</st1:place></st1:country-region>.<span style="mso-spacerun:yes"> </span>Give it a second because just like any web page it takes a second to load. <span style="mso-spacerun:yes"> </span>Cool, right – you actually see a website in the bubble with tourist info.</o:p></span></p><iframe id="ifMap" width="100%" height="620" frameborder="0" scrolling="no" allowtransparency="true" src="http://mapalist.com/Public/PublicMapViewerShell.aspx?mapid=33121"></iframe><br /><br /><p class="MsoNormal"><span style="font-family:Georgia;color:black;"><o:p>Your toolbox should be starting to fill up now…have fun with it,</o:p></span></p> <p class="MsoNormal"><span style="font-family:Georgia;color:black;">--The Map Commissioner (<a href="mailto:bmokotoff@mapalist.com">E-mail</a>)<o:p></o:p></span></p>map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-37520863527018764672009-01-11T22:15:00.010+00:002009-01-23T12:18:25.558+00:00Adding Email & Skype to Your Map Points<div><div style="text-align: left; "><span class="Apple-style-span" style="font-weight: bold; ">What are we talking about here?</span><br /></div><div><div>Lots of folks use MapAList to share contact information above and beyond just physical addresses. We see maps all the time that include email addresses and/or phone numbers in the pin pop up bubbles. What you may not know is that it's easy to make those email addresses and phone numbers "active". In other words, you can create your map such that someone looking at it can click on the values in the pin pop up bubbles to initiate an email or a phone call (via Skype). This makes your map more way more interactive. Let's take a look at how it's done...<br /><br /><span style="font-weight: bold; ">What does it look like from a spreadsheet perspective?</span></div></div></div><div>Just like hyperlinks, the key here is all in the way you enter data into your Google Spreadsheet. A little HTML does the trick. Using "mailto" and "callto" make this a pretty straightforward process.</div><div><br /></div><div>Scroll to the right in the frame below and take a look a the third column in the spreadsheet titled E-mail Link. It contains the HTML required to initiate a clickable email link in your pin pop up bubble.</div><div><br /></div><div>The fourth column, titled Phone Link, contains the HTML required to initiate a clickable email link in your pin pop up bubble. Note that the callto tag can be followed by either a telephone number or a Skype ID. <u><span class="Apple-style-span" style="font-size:medium;">Either will work as long as Skype is configured to "Associate Skype with callto: links: in the SKYPEMENU>TOOLS>OPTIONS>ADVANCED OPTIONS.</span></u></div><div><span class="Apple-style-span" style="text-decoration: underline;"><br /></span></div><div>Feel free to us the CONCATENATE function to make life easier if you want as explained in the last post (<a href="http://mapalist.blogspot.com/2008/12/hyperlinks-part-1-links-to-websites.html">Adding Hyperlinks to Your Map Points</a>).</div><div><br /></div><div><iframe src="http://spreadsheets.google.com/pub?key=pqacvdx2XdPe1C_63pxzgWw&output=html&gid=0&single=true" width="400" frameborder="0" height="200"></iframe></div><div><br /></div><div>The HTML is pretty self explanatory so I'm not going to dive into it. From here, all you have to do is assign your fields in <span class="Apple-style-span" style="font-weight: bold;">Step 2b</span> of the map creation process and you're good to go. If you have questions feel free to post to the <a href="http://mapalist.com/Public/Help.aspx?tab=forum">help forum</a>.</div><div><div><div><br /></div></div></div><div><div style="text-align: left; "><span class="Apple-style-span" style="font-weight: bold; ">What does it look like from a map perspective?</span><br /></div><div>As you might expect, we see the 2 pins plotted on the map below. When you click on either pin, you will see 2 links in the pop up bubble. If you click on the first one, MapAList will initiate an email to help@mapalist.com. If you click on the second one MapAList will initiate a Skype call to the MapAList help desk.</div><div><br /></div><iframe id="ifMap" width="100%" height="500" frameborder="0" scrolling="no" allowtransparency="true" src="http://mapalist.com/Public/PublicMapViewerShell.aspx?mapid=31217"></iframe><br /><br /></div><div>This is super simple and super powerful. Give it a try for yourself. </div><div><br /></div><div>Hope this was helpful...more to come.</div><br />--The Map Commissioner (<a href="mailto:bmokotoff@mapalist.com">E-mail</a>)map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-58753234351466873312008-12-31T00:11:00.018+00:002009-01-21T03:24:08.862+00:00Adding Hyperlinks to Your Map Points<div style="text-align: left;"><span class="Apple-style-span" style="font-weight: bold; ">What are we talking about here?</span><br /></div><div style="text-align: left; ">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. </div><div style="text-align: left; "><br /></div><div style="text-align: left; ">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. </div><div style="text-align: left; "><br /></div><div style="text-align: left; ">Sound cool? It is. Sound hard? Don't worry, we'll walk you through it...</div><div><div><br /><span style="font-weight: bold; ">What does it look like from a spreadsheet perspective?</span><br />There are 2 approaches to making this work, one certainly more efficient if you are dealing with multiple address records.</div><div><br /></div><div>In the sample spreadsheet below, you can see a column called <span class="Apple-style-span" style="font-style: italic; ">Site </span>which is used to associate the address with a website (URL). You can see that in the <span class="Apple-style-span" style="font-style: italic;">Site</span> column the MapAList URL has been inserted (http://www.mapalist.com). The next column is called <span class="Apple-style-span" style="font-style: italic;">Site Link </span><span class="Apple-style-span" style="">(you'll have to scroll to the right on the IFrame below to see it)</span><span class="Apple-style-span" style="font-style: italic;">. </span>Here's where those 2 different approaches come in...</div><div><br /></div><div>1. You can simply enter the HTML in the cell. In other words, you can type in the following:</div><div><br /><span class="Apple-style-span" style="font-weight: bold;"><a target='_new' href='http://mapalist.com'>MapAList HQ</a><br /></span></div><div><br /></div><div>2. In order to avoid typing the HTML out for every record, you can use the CONCATENATE function and reference the cell in the <span class="Apple-style-span" style="font-style: italic;">Site</span> column that contains the URL. Instead of entering the HTML in cell D2 (column 4 row 2), you would enter the following:</div><div><br /></div><div><span class="Apple-style-span" style="font-weight: bold;">=CONCATENATE("<a target='_new' href="', C2,'">", A2,"</a>")<br /></span><br /></div><div><br /><iframe width="410" height="200" frameborder="0" src="http://spreadsheets.google.com/pub?key=pqacvdx2XdPetahQIIdk-bw&output=html&gid=1&single=true"></iframe><br /></div><div><br /></div><div><br /></div><div><span class="Apple-style-span" style="font-weight: bold; ">So what the heck do those HTML tags mean?</span><br /></div><div>This isn't a HTML tutorial, but we can still break it down for you briefly...</div><div><br /></div><div><span class="Apple-style-span" style="font-weight: bold;"><a </span><span class="Apple-style-span" style="color: rgb(255, 102, 102);"><span class="Apple-style-span" style="font-weight: bold;">target='_new'</span></span><span class="Apple-style-span" style="font-weight: bold;"> </span><span class="Apple-style-span" style="color: rgb(51, 204, 0);"><span class="Apple-style-span" style="font-weight: bold;">href='http://mapalist.com'</span></span><span class="Apple-style-span" style="font-weight: bold;">></span><span class="Apple-style-span" style="color: rgb(255, 204, 0);"><span class="Apple-style-span" style="font-weight: bold;">MapAList HQ</span></span><span class="Apple-style-span" style="font-weight: bold;"></a><br /></span></div><div><br /></div></div><div><div><span class="Apple-style-span" style="font-style: italic;"><span class="Apple-style-span" style="color: rgb(255, 102, 102);"><span class="Apple-style-span" style="font-style: normal;">target='_new'</span></span> </span>- the <u>target attribute</u> tells your browser to open the link in a new window<br /></div><div><br /></div><div><span class="Apple-style-span" style="font-style: italic;"><span class="Apple-style-span" style="color: rgb(51, 204, 0);"><span class="Apple-style-span" style="font-style: normal;">href='http://mapalist.com'</span> </span></span>- the <u>link URL</u> tells your browser what URL to open in that new window</div><div><br /></div><div><span class="Apple-style-span" style=""><span class="Apple-style-span" style="color: rgb(255, 204, 0);">MapAList HQ</span></span> - the <u>link text</u> defines what will be displayed (and clickable)</div><div><br /></div><div><p class="MsoNormal"><b>Okay, you've got the link in the spreadsheet - now what?</b></p><p class="MsoNormal">This is the easy part. All you have to do is referance the column in the spreadsheet that contains your link in <span class="Apple-style-span" style="font-weight: bold;">Step 2b</span> where you assign your fields to your map. Simply select column that contains the links as either the <span class="Apple-style-span" style="font-style: italic;">Title</span> or <span class="Apple-style-span" style="font-style: italic;">Additional Info</span> values so that they will show up in the bubble when you click on the map pin. That's all you have to do.</p><p class="MsoNormal"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJHs1KdA2DTBBbgZxZO6QE_kai2Etry1Bvg3YOKgWoiFGW-m9Ii3GtJdE_tHWDfLLEZgzT5rF9HhirPWozehPHRjj6YUSl1I88QEuL1skGZVnmJnfzRlQFoamC8Vsulqb9am9tdXVbP2SS/s1600-h/Step2.PNG"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJHs1KdA2DTBBbgZxZO6QE_kai2Etry1Bvg3YOKgWoiFGW-m9Ii3GtJdE_tHWDfLLEZgzT5rF9HhirPWozehPHRjj6YUSl1I88QEuL1skGZVnmJnfzRlQFoamC8Vsulqb9am9tdXVbP2SS/s400/Step2.PNG" border="0" alt="" id="BLOGGER_PHOTO_ID_5290042130383189858" style="display: block; margin-top: 0px; margin-right: auto; margin-bottom: 10px; margin-left: auto; text-align: center; cursor: pointer; width: 400px; height: 157px; " /></a></p><p class="MsoNormal" style="text-align: center;"><span class="Apple-style-span" style="color: rgb(255, 0, 0);">Click on the image above to take a closer look</span></p></div><div><p class="MsoNormal"><b>What does it look like from a map perspective?</b></p><p class="MsoNormal">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.</p><p class="MsoNormal"><br /></p></div></div><br /><iframe id="ifMap" width="100%" height="500" frameborder="0" scrolling="no" allowtransparency="true" src="http://mapalist.com/Public/PublicMapViewerShell.aspx?mapid=30323"></iframe><br /><div><span class="Apple-style-span" style="font-weight: bold;"><br /></span></div><div><span style="font-weight: bold; ">What are other users doing with this feature?<br /></span>The use of hyperlinks within maps is quickly becoming a very popular feature. The most common uses to date are: <br /><div><br />•Mapping companies and linking to their homepages</div><div><br /></div><div>and</div><div><br /></div><div><div>•Mapping friends and linking to their Facebook, LinkedIn, MySpace, or Blog pages</div><div><br /></div><div>So get creative and give it a try!</div></div><div><br />Hope this was helpful...more to come.<br /><br />--The Map Commissioner (<a href="mailto:bmokotoff@mapalist.com">E-mail</a>)</div></div>map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-44774418951957948772008-12-28T17:58:00.002+00:002009-01-09T13:02:20.079+00:00Advanced Grouping to Show Differentiation<div style="text-align: left;"><span class="Apple-style-span" style="font-weight: bold; ">What are we talking about here?</span><br /></div>So basic grouping was, well, a bit basic wasn’t it? When I ran through it with my wife for the first time she was rather impatient and starting asking me why she couldn’t change the pin colors/styles. I explained that she could and that I would walk her through it in the advanced grouping tutorial.<br /><br />Advanced grouping enables a lot more than simply grouping based on distinct values in a column. With advanced grouping, MapAList supports the use of operators and comparison values to create grouping rules. It then allows you to choose the pin image associated with each group. Let me show you what I mean… <div><br /></div><div><p class="MsoNormal"><b style="mso-bidi-font-weight:normal">What does it look like from a spreadsheet perspective?<o:p></o:p></b></p> <p class="MsoNormal"><b style="mso-bidi-font-weight:normal"><o:p><span class="Apple-style-span" style="font-weight: normal; ">In the sample spreadsheet below (which should look familiar), you can see a column called <i style="mso-bidi-font-style:normal">Response </i><span style="mso-spacerun:yes"> </span>which is used to differentiate each address as coming to the wedding (Yes), not coming (No), or no response (Empty).<span style="mso-spacerun:yes"> </span>So let’s see what we get when we map this sheet…</span></o:p></b></p><p class="MsoNormal"><iframe width="400" height="300" frameborder="0" src="http://spreadsheets.google.com/pub?key=pqacvdx2XdPdkS4tSqvidBA&output=html&widget=true"></iframe><br /></p><p class="MsoNormal"></p><p class="MsoNormal"></p><p class="MsoNormal"><span class="Apple-style-span" style="font-weight: bold;"><br /></span></p><p class="MsoNormal"><b style="mso-bidi-font-weight:normal">What does it look like from a map perspective?<o:p></o:p></b></p><p></p><p class="MsoNormal"><span class="Apple-style-span" style="font-size:medium;">What you can see is that MapAList plotted red pins for addresses that had responded No, Green Pins for addresses that responded Yes, and yellow pins for addresses that did not have a response (empty).</span><span style="mso-spacerun:yes"><span class="Apple-style-span" style="font-size:medium;"> </span></span><span class="Apple-style-span" style="font-size:medium;">Coincidence on the colors?</span><span style="mso-spacerun:yes"><span class="Apple-style-span" style="font-size:medium;"> </span></span><span class="Apple-style-span" style="font-size:medium;">I think not.</span><span style="mso-spacerun:yes"><span class="Apple-style-span" style="font-size:medium;"> </span></span><span class="Apple-style-span" style="font-size:medium;">MapAList’s advanced grouping feature allows the user to choose the pin color/type associated with each group.</span><span style="mso-spacerun:yes"><span class="Apple-style-span" style="font-size:medium;"> </span></span><span class="Apple-style-span" style="font-size:medium;">I’ll explain how in just a minute.</span></p></div><iframe id="ifMap" width="100%" height="500" frameborder="0" scrolling="no" allowtransparency="true" src="http://mapalist.com/Public/PublicMapViewerShell.aspx?mapid=30072"></iframe><br /><div><br /></div><div><p class="MsoNormal"><span class="Apple-style-span" style="font-weight: bold;"></span></p><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-family:Georgia;color:black;">Okay – so walk me through it step by step…</span><u1:p></u1:p></b><span style="font-family:Georgia;color:black;"><o:p></o:p></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span class="apple-style-span"><span style=" ;font-family:Georgia;color:black;"><u1:p><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;">The process is very much like making a basic map that shows all addresses – the key difference is in Step 4 – Configure Map below:</span></span></u1:p></span></span><span style="font-family:Georgia;color:black;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;"><o:p></o:p></span></span></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span class="apple-style-span"><span style=" ;font-family:Georgia;color:black;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;">Step 4 – Configure Map</span></span></span></span><span style=" ;font-family:Georgia;color:black;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;"><o:p></o:p></span></span></span></p> <ul type="disc"> <li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l0 level1 lfo1;tab-stops:list .5incolor:black;"><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;">Specify the</span></span></span></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></span></span><span class="apple-style-span"><i><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;">Setting Type</span></span></span></i></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></span></span><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;">as</span></span></span></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></span></span><span class="apple-style-span"><i><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;">Advanced</span></span></span></i></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></span></span><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;">– this will give you the opportunity to specify your grouping criteria.</span></span></span></span></li></ul><div><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2-cygrYvP3ZI6emxGoUYh1dvSHpRHAmItqR-9xkPr7uVjbDKoFUJmRu5FhzuxPlAABEQCha8JxIk69N_SOBv61kbsLclUsbYw9BNreL1UCp-e33N0lBZgJhuif1t0kKWuy0vRH8bJej8V/s1600-h/AG+Image1.jpg"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2-cygrYvP3ZI6emxGoUYh1dvSHpRHAmItqR-9xkPr7uVjbDKoFUJmRu5FhzuxPlAABEQCha8JxIk69N_SOBv61kbsLclUsbYw9BNreL1UCp-e33N0lBZgJhuif1t0kKWuy0vRH8bJej8V/s400/AG+Image1.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5284914353691650802" style="display: block; margin-top: 0px; margin-right: auto; margin-bottom: 10px; margin-left: auto; text-align: center; cursor: pointer; width: 400px; height: 63px; " /></a></div><div><div style="text-align: center; "><span class="Apple-style-span" style="color: rgb(255, 102, 102); ">Click on the image to take a closer look</span></div></div><ul type="disc"><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l0 level1 lfo1;tab-stops:list .5incolor:black;"><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;">Now you can specify your criteria using the simple user interface. </span></span></span></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></span></span><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;">Here’s what I did:</span></span></span></span><span style="font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;"><o:p></o:p></span></span></span></li> </ul> <ul type="disc"> <ol start="1" type="a"> <li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l1 level2 lfo2;tab-stops:list 1.0incolor:black;"><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;">Specified that I want to evaluate the</span></span></span></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;"> </span></span></span></span><span class="apple-style-span"><i><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;">Response</span></span></span></i></span><span class="apple-converted-space"><i><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;"> </span></span></span></i></span><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;">column in my worksheet.</span></span></span></span><span style="font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;"><o:p></o:p></span></span></span></li> <li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l1 level2 lfo2;tab-stops:list 1.0incolor:black;"><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;">Specified that I want MapAList to look for addresses in my worksheet where the value in the</span></span></span></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;"> </span></span></span></span><span class="apple-style-span"><i><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;">Response</span></span></span></i></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;"> </span></span></span></span><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;">column is</span></span></span></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;"> </span></span></span></span><span class="apple-style-span"><i><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;">= “equal to”</span></span></span></i></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;"> </span></span></span></span><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;">the</span></span></span></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;"> </span></span></span></span><span class="apple-style-span"><i><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;">Comparison Value</span></span></span></i></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;"> </span></span></span></span><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;">of No.</span></span></span></span><span style="font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;"><o:p></o:p></span></span></span></li> <li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l1 level2 lfo2;tab-stops:list 1.0incolor:black;"><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;">Specified in the</span></span></span></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;"> </span></span></span></span><span class="apple-style-span"><i><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;">Criteria Description</span></span></span></i></span><span class="apple-converted-space"><i><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;"> </span></span></span></i></span><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;">field that my map key should call these addresses out as</span></span></span></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;"> </span></span></span></span><span class="apple-style-span"><i><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;">Not Attending</span></span></span></i></span><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;">.</span></span></span></span><span style="font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;"><o:p></o:p></span></span></span></li> <li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l1 level2 lfo2;tab-stops:list 1.0incolor:black;"><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;">Clicked on the … box and selected the red pin image to use for addresses that are Not Attending.</span></span></span></span><span style="font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;"><o:p></o:p></span></span></span></li> <li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l1 level2 lfo2;tab-stops:list 1.0incolor:black;"><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;">Clicked on the</span></span></span></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;"> </span></span></span></span><span class="apple-style-span"><i><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;">Plus</span></span></span></i></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;"> </span></span></span></span><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-size:medium;"><span class="Apple-style-span" style="font-weight: normal;">button to add conditions for my other 2 situations – addresses that are attending and addresses that have no response yet (empty).</span></span></span></span></li></ol></ul><div><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqrl2wjCmwnWQ-X3qM2slA6OBwhMRO63miSXL8ueoAbmsSrV32b9yd0yrQvg8vznm7MTV1zVTwP8zC-Gl3xjnKJJNLGfSFuGScUMXg1C2SYBHkGmljmJSJi-ZDDwUZ4HjJkVwP8FUkH7MZ/s1600-h/AG+Image2.jpg"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqrl2wjCmwnWQ-X3qM2slA6OBwhMRO63miSXL8ueoAbmsSrV32b9yd0yrQvg8vznm7MTV1zVTwP8zC-Gl3xjnKJJNLGfSFuGScUMXg1C2SYBHkGmljmJSJi-ZDDwUZ4HjJkVwP8FUkH7MZ/s400/AG+Image2.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5284914446049384194" style="display: block; margin-top: 0px; margin-right: auto; margin-bottom: 10px; margin-left: auto; text-align: center; cursor: pointer; width: 400px; height: 117px; " /></a></div><div><div style="text-align: center; "><span class="Apple-style-span" style="color: rgb(255, 102, 102); ">Click on the image to take a closer look</span></div></div><ul type="disc"> <li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l1 level1 lfo2;tab-stops:list .5incolor:black;"><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;">Click on the</span></span></span></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></span></span><span class="apple-style-span"><i><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;">Preview Map</span></span></span></i></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></span></span><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;">button to display your map. </span></span></span></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></span></span><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;">The pin images you selected for each condition will display.</span></span></span></span><span style="font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;"><o:p></o:p></span></span></span></li> <li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l1 level1 lfo2;tab-stops:list .5incolor:black;"><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;">Click on the</span></span></span></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></span></span><span class="apple-style-span"><i><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;">Next</span></span></span></i></span><span class="apple-converted-space"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></span></span><span class="apple-style-span"><span style=" ;font-family:Georgia;"><span class="Apple-style-span" style="font-weight: normal;"><span class="Apple-style-span" style="font-size:medium;">button.</span></span></span></span><span style="font-family:Georgia;"><o:p></o:p></span></li> </ul><p></p><span class="Apple-style-span" style="font-size:medium;"><div><span class="Apple-style-span" style="font-weight: bold; "><p class="MsoNormal"><span class="apple-style-span"><span style=" ;font-family:Georgia;color:black;"><span class="Apple-style-span" style="font-weight: normal; ">Step 5 – Save Map</span></span></span><span style=" ;font-family:Georgia;color:black;"><span class="Apple-style-span" style="font-weight: normal; "><o:p></o:p></span></span></p><ul type="disc"><li class="MsoNormal" style=" ;color:black;"><span class="Apple-style-span" style="font-weight: normal;">Modify <span class="Apple-style-span" style="font-style: italic;">Additional Settings</span> as you see fit.</span></li><li class="MsoNormal" style=" ;color:black;"><span class="Apple-style-span" style="font-weight: normal;">Click on the <span class="Apple-style-span" style="font-style: italic;">Save & View Map</span> button.</span></li><li class="MsoNormal" style=" ;color:black;"><span class="Apple-style-span" style="font-weight: normal;">Click on the <span class="Apple-style-span" style="font-style: italic;">Close This, and Create New Map</span> button.</span></li></ul></span></div></span></div><br />Give it a try and let us know what you think...<br /><br />--The Map Commissioner (<a href="mailto:bmokotoff@mapalist.com">E-mail</a>)map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-72443181562842528822008-12-27T23:53:00.000+00:002009-01-05T12:35:46.947+00:00Basic Grouping to Show Differentiation<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggeEwW2fKDIzUOSWTHDTy5sZpPe1YN2hDazHpeQ70dJknRNFXZNoBIKzvlAeuyVaGKWAs29FETA0zPt6CRIzWyw3cpbG1pu1WeRfP44nDml1BnNUhf1VTYzOXF1zANSVleUQAjwdjMn9RG/s1600-h/Image3.jpg"></a><div style="text-align: left;"><span class="Apple-style-span" style="font-weight: bold;">What are we talking about here?</span><br /></div>Creating basic maps that simply map all addresses are useful, but grouping allows you to kick things up a notch.<br /><br /><div><div>Let’s say you are mapping your wedding attendee list for your wedding website and want to allow the map viewer to easily differentiate between the bride’s family and the groom’s family. MapAList has a <span class="Apple-style-span" style="font-style: italic;">Map Type</span> built to handle just that – it’s called <span class="Apple-style-span" style="font-style: italic;">Group by Distinct Column Values (using unique pin images)</span> and can be selected in <span class="Apple-style-span" style="font-style: italic;">Step 4 – Configure Map</span> of the map creation process.<br /><br />This <span class="Apple-style-span" style="font-style: italic;">Map Type</span> allows you to tell MapAList which column in your worksheet contains the grouping attribute. MapAList then examines the values in that column and assigns a unique pin image to each distinct value. Running with the wedding example, what this means is that you would need a column in your worksheet that associates each address with the bride or groom…let’s take a look at an example.<br /><br /><span style="font-weight: bold;">What does it look like from a spreadsheet perspective?</span><br />In the sample spreadsheet below, you can see a column called <span class="Apple-style-span" style="font-style: italic;">Group </span>which is used to distinguish each address as a member of the bride’s family, a member of the groom’s family, or a friend. <u>Note that you may need to click on the image below and drag to the right to see this column (due to the way Blogger sizes iframes)</u>. I could have called the column anything I wanted – for example Family or Side, MapAList doesn’t care. I could also have additional values in the Group column – for example Groomsmen and Bridesmaids. The point I’m trying to get across is that the number of groups is not limited to 3. You could have 50…all MapAList needs to know is the name of the column that contains the grouping attributes. So let’s see what we get when we map this sheet…<div><br /><iframe src="http://spreadsheets.google.com/pub?key=pqacvdx2XdPdkS4tSqvidBA&output=html&widget=true" width="400" frameborder="0" height="300"></iframe><br /><a href='http://spreadsheets.google.com/ccc?key=pqacvdx2XdPdkS4tSqvidBA' target='_gss'>http://spreadsheets.google.com/ccc?key=pqacvdx2XdPdkS4tSqvidBA</a><br /><br /><div><div style="text-align: left;"><span class="Apple-style-span" style="font-weight: bold;">What does it look like from a map perspective?</span><br /></div><div><br />What you can see is that MapAList selected red pins to represent the addresses associated with the bride’s family white pins to represent the groom’s family, and green pins to represent friends. If my worksheet had contained addresses with a <span class="Apple-style-span" style="font-style: italic;">Group </span>called Groomsmen, we would have seen a 4th pin type on the left side of the map that represented the Groomsmen addresses and the associated pins on the map.<br /><br /><iframe id="ifMap" allowtransparency="true" src="http://mapalist.com/Public/PublicMapViewerShell.aspx?mapid=29972" scrolling="no" width="100%" frameborder="0" height="500"></iframe><br /><br /><span style="font-weight: bold;">Okay – so walk me through it step by step…<br /></span>The process is very much like making a basic map that shows all addresses – the key difference is in Step 4 – Configure Map below:<br /></div><div><br /><span class="Apple-style-span" style="font-style: italic;">Step 4 – Configure Map</span><br />•Choose <span class="Apple-style-span" style="font-style: italic;">Group by Distinct Column Values (using unique pin images)</span>.<div><br /></div><div><span class="Apple-style-span" style="color: rgb(85, 26, 139);"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggeEwW2fKDIzUOSWTHDTy5sZpPe1YN2hDazHpeQ70dJknRNFXZNoBIKzvlAeuyVaGKWAs29FETA0zPt6CRIzWyw3cpbG1pu1WeRfP44nDml1BnNUhf1VTYzOXF1zANSVleUQAjwdjMn9RG/s400/Image3.jpg" alt="" id="BLOGGER_PHOTO_ID_5284890526196700130" style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 97px;" border="0" /></span></div><div><div style="text-align: center;"><span class="Apple-style-span" style="color: rgb(255, 102, 102);">Click on the image to take a closer look</span><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">•Choose the <span class="Apple-style-span" style="font-style: italic;">Column </span>that contains the attribute that you would like to group by.</div></div><div><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwszVGdpPGzOCDCgvG9mbb_rWW-Xwj3hmQJFEDU-EbcAWlzRhiOR5g6MuyHx0FNVs1oXUhPO_MQlViIeuNk1_oeVWjDBU6jmakaEj7JChmg3HqBB7DEP2XESdGHPahpLHSW6cuQLnZKj5D/s1600-h/Image2.jpg" style="text-decoration: none;"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwszVGdpPGzOCDCgvG9mbb_rWW-Xwj3hmQJFEDU-EbcAWlzRhiOR5g6MuyHx0FNVs1oXUhPO_MQlViIeuNk1_oeVWjDBU6jmakaEj7JChmg3HqBB7DEP2XESdGHPahpLHSW6cuQLnZKj5D/s400/Image2.jpg" alt="" id="BLOGGER_PHOTO_ID_5284890396327260098" style="margin: 0px auto 10px; text-decoration: underline; display: block; text-align: center; cursor: pointer; width: 450px; height: 125px;" border="0" /></a><div style="text-align: center;"><span class="Apple-style-span" style="color: rgb(255, 102, 102);">Click on the image to take a closer look</span></div><div style="text-align: center;"><span class="Apple-style-span" style="color: rgb(255, 102, 102);"><br /></span></div></div><div>•Click on the <span class="Apple-style-span" style="font-style: italic;">Preview Map</span> button to display your map. A unique pin image will represent each distinct column value in the column you selected.<br />•Click on the <span class="Apple-style-span" style="font-style: italic;">Next </span>button.<br /><br /><span class="Apple-style-span" style="font-style: italic;">Step 5 – Save Map</span><br />•Modify <span class="Apple-style-span" style="font-style: italic;">Additional Setting</span> as you see fit.<br />•Click on the <span class="Apple-style-span" style="font-style: italic;">Save & View Map</span> button.<br />•Click on the <span class="Apple-style-span" style="font-style: italic;">Close This, and Create New Map</span> button.<br /><br /><br /><span style="font-weight: bold;">What are other users doing with this feature?<br /></span>So now that you know how to use Basic Grouping to Show Differentiation, give some thought to how you might use it. Other users have used grouping to differentiate between:<div><br />•Bride’s and groom’s friends/family (you saw that one coming)<br />•Sales targets that are hot/medium/cold<br />•Clients using specific versions of a their software<br />•Types of crimes committed in a specific area<br />•Regular and premium users of a website<br />•Destinations visited in 2008, 2007, 2006, etc.</div><div><span class="Apple-style-span" style="font-style: italic;">•Comment and us how you're using Basic Grouping<br /></span><br />Hope this was helpful...more to come.<br /><br />--The Map Commissioner (<a href="mailto:bmokotoff@mapalist.com">E-mail</a>)</div></div></div></div></div></div></div>map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.comtag:blogger.com,1999:blog-6446448640471306105.post-28387029448956110712008-12-24T21:28:00.004+00:002009-01-30T12:52:44.430+00:00Taking your Maps to the Next LevelAs 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.<br /><br />What does that tell us?<br /><br />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.<br /><br />For the next several weeks we will be publishing installments of <span style="text-decoration:underline">Taking Your Maps to the Next Level</span> – 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.<br /><br />Here’s the current plan…<br /><br />01/02/09 –<a href="http://mapalist.blogspot.com/2008/12/basic-grouping-to-show-differentiation.html">Basic Grouping to Show Differentiation</a><br />01/09/09 – <a href="http://mapalist.blogspot.com/2008/12/advanced-grouping-to-show.html">Advanced Grouping to Show Differentiation</a><br />01/16/09 – <a href="http://mapalist.blogspot.com/2008/12/hyperlinks-part-1-links-to-websites.html">Adding Hyperlinks to Your Map Points</a><br />01/23/09 – <a href ="http://mapalist.blogspot.com/2009/01/adding-email-skype-to-your-map-points.html">Adding E-mail & Phone Calls (via Skype) to Your Map Points</a><br /><div>01/30/09 – <a href ="http://mapalist.blogspot.com/2009/01/adding-images-iframes-to-your-map.html">Adding Images & Iframes to your Map Points</a><br /><br /><br /><br />If you have other ideas for topics please give us a shout.<br /><br />--The Map Commissioner (<a href="mailto:bmokotoff@mapalist.com">E-mail</a>)</div>map a listhttp://www.blogger.com/profile/01020311655848539803noreply@blogger.com