Google

Google Spreadsheet Graph with Dynamic Data by Eric on February 1, 2020

Recently we started dumping some data from the database into a shared spreadsheet on Google Docs.  With all of this data it would be helpful to visualize it in some way.  After searching the net it seems there isn't really a good way to create a chart that is dynamic with what data is in the spreadsheet.  What I want is to have my graph update every time a new row is added to the sheet without having to edit the graph directly.  The solution was to write a custom Google Apps Script to do just that. To add a Google Apps Script to a document open the document and click Tools -> Script editor...  This opens up a page for editing scripts.  If a prompt appears for what type of script you want to do just select Blank.  Now you just need to paste in this code below.//Runs on document open function onOpen() { createGraph(); }; //Runs on any edit function onEdit() { createGraph(); } /** * This function reads the data in the Totals columns */ function createGraph() { var tabName = ...

Chromecast - Unboxing and First Thoughts by Eric on February 1, 2020

![](/img/marquee-product-300x277.png) Google has released their own competitor to Apple TV and Roku called Chromecast.  It's a very small device that plugs into an HDMI port in your TV and can stream Internet video right to your TV.  The box is very small and does not come with a remote because your tablet/smart phone/laptop/desktop is your remote.  Using the apps on your tablet or smart phone you can stream YouTube videos, Google Play purchases, and Netflix to your TV with the push of a button.  For the desktop/laptop you can stream anything that is in your Google Chrome browser, which you should all be using anyway.  At a price tag of $35 it's pretty easy to convince yourself to just jump in.  Below is the unboxing as well as my thoughts on setup and use.  I've had it for a few days now so I'm not a huge expert on it but it's so simple there really isn't much to it. Let's walk through the pictures and setup.  That small box is all you get when you order Chromecast.  Opening it u...

Add a Simple Google Map to Your Webpage by Eric on February 1, 2020

![null](/img/map-title-300x164.png) There's just something about having a map of an address that is appealing to people.  Why just list the address like a mailing label when you can place a nice marker on an interactive Google Map?  That's what I thought too when I was adding content to our customer profiles.  I'd never done this before but knew that Google has a great API for accessing their data as well as some pretty good examples to follow.  The API covers how to use Google Maps on any device but for the purposes of this post I will be focusing solely on web. Let's go over some ground rules for using Google Maps API and then move on to a very simple example and build upon it slightly.  To start off with, you can only make a limited number of requests to Google for maps data before you have to start paying.  For a small company or webpage this limit will not be a problem.“For-profit web sites are permitted to generate up to 25 000 map loads per day using the Google Maps JavaScr...

Google Calendar for Business and Life by Eric on February 1, 2020

Google has worked really hard at making their Google Apps for Business to be something great that all businesses can use. They say that over five million companies are using Google Apps for their business and the company I work at is one of them. In order for Google to compete with the powerhouse that is Microsoft Office Suite they need to have some pretty great things, and they do. I've already done a post about Hangouts which works well as a chat client and awesome for video conferencing. Today I'm going to show off Google Calendar and how to use it to its fullest in a business setting as well as a few tips for making Google Calendar your personal online calendar of choice. A lot of basic features you can find with any calendar program are already present including multiple calendar support, calendar sharing, and permissions.  Let's quickly run through how to create a new calendar and share it with your company.Create a New Calendar • From the main calendar view, on the left sid...

Google Hangouts - Why You Should Be Using It by Eric on February 1, 2020

Recently Google said goodbye to their chat system Google Talk and replaced it with Google Hangouts.  If you aren't currently on Google+, and I know that is a lot of people, you probably don't know what Hangouts is.  Google Hangouts is Google's voice/video/chat client and is very comparable to Skype and Apple's Facetime.  This post will discuss some of those comparisons and why Hangouts should replace your current video/voice/chat client.Universal Compatibility Google Hangouts works on any computer or mobile device you have.  Whether you are chatting on your iPhone or sitting at your Windows PC you can talk and chat with anyone using Hangouts.  We've started using it in our office to replace our instant messaging client and it has been a dream.  Not only do you get messages while sitting at your machine but you can install the app on your mobile devices to get messages even when you are away from your desk.  Some people might not like this, you don't need to install the app, but fo...