One of the major advancements we've made for Tech Field Day in 2011 was streaming and posting video of all presentations. For all events in 2012, we will be posting video to both YouTube and Vimeo, and we've had great viewership numbers at both sites. I know the viewership numbers because I have developed a custom Google spreadsheet that automatically imports video statistics … [Read more...] about How to Automatically Import YouTube and Vimeo Viewer Statistics into Google Docs Spreadsheets
Google Apps
Google Broke Public Calendar Sharing For Apps Users – Here’s How To Fix It
Sometime on November 30, Google broke public calendar sharing for apps users. This means that any calendars previously shared with the world (like, for example, my IT events calendar) are no longer visible. As is typical for Google, the change was made quietly and it was not immediately obvious how to fix it. But here's what you should do if your calendar is no longer … [Read more...] about Google Broke Public Calendar Sharing For Apps Users – Here’s How To Fix It
Cool Google Spreadsheet XML/XPath Mojo
Google Spreadsheet sure isn't as responsive for a power user like me, but I love the ability to share information with others and cooperatively edit a workbook. It's become our main tool for planning the Gestalt IT Tech Field Day events. I was thrilled to discover that Google's spreadsheet supports the importXML tag, which allows it to automatically gather information from … [Read more...] about Cool Google Spreadsheet XML/XPath Mojo
How To Enable ActiveSync For Google Apps Accounts
Here's a quick tip, but a timely one now that the iPhone supports multiple Exchange ActiveSync servers: Although Google supports the Exchange ActiveSync protocol to synchronize mail, contacts, and calendars between Gmail and mobile devices, it is not active by default for custom Google Apps domains. It's pretty easy to enable it, though. How To Enable Google Sync For example, … [Read more...] about How To Enable ActiveSync For Google Apps Accounts
How To Keep Your Family Activities In Sync With A Shared Google Calendar
Smartphones, computers, and iPads are proliferating in families today. Although my three kids do not (yet) have their own mobile phones, we still have quite a few devices with calendar functions: An iPhone each for me, my wife, and our au pair along with an iPad and a few computers. Using Google Calendar, we have set up an awesome shared calendar to keep all of our activities … [Read more...] about How To Keep Your Family Activities In Sync With A Shared Google Calendar