Totally Unscripted Exclusive: Detailed look at the new Google Apps Script IDE/Script Editor and launch
In the episode we broke the exclusive news that the new Script Editor will be rolling out to all users starting on 07 December 2020. I can’t thank Keith enough for taking the time out to share this news to the Totally Unscripted audience first and also to Charles for making possible as well as providing an expert tour of the new Apps Script Editor.
How we survived a pandemic: Part 6 – Wellbeing as a home-worker… where are you on the unicorns 🦄 and pumpkins 🎃 scale?
In this month’s post we reflect on wellbeing as homeworkers, particularly under the pressures and strains of current times. As part of this we look at ways individuals and teams can check-in on how they are doing using resources from the What Works Centre for Wellbeing and Mental Health First Aid (MHFA) England. We also discuss ways that we have used to find a better balance such as using the Digital Data Detox Kit and even removing ‘work’ from our phones.
Repost: ‘Totally Unscripted’ the Google Workspace and Apps Script developer show is back!
Totally Unscripted the Google Workspace and Apps Script developer community show returns! The shows are an opportunity to learn about the very latest Google Workspace and Apps Script updates from both the community and Google. We are returning with a series of six weekly shows starting with ‘Meet the new Google Workspace Developers Experts’ on 05 November 2020 at 20:00 UTC.
Quick article ratings using Google Tag Manager and Google Analytics
Interested in a way to capture quick article user ratings in your Google Analytics data? Well you are in the right place. In this post I’ll show how I was able to send user article (star) ratings to Google Analytics using Google Tag Manager.
How we survived a pandemic: Part 5 – Virtual team meeting ice breakers from the ALT Staff Team
This month’s post is a bit different from the usual, as we celebrate a team effort of inventing ice breakers for our weekly team meetings, which take place for an hour every Wednesday morning. We’ve got everything from “share your four-legged friends” to “lockdown recipe swap” to “pandemic playlist” to “humble brag” to “Pictionary Jam” and more.
Working with Pivot Tables in Google Sheets using Google Apps Script
Pivot tables are a quick and powerful way to analyse data. Using Google Apps Script, there is an ability to build and modify pivot tables in Google Sheets. In this post I’ll share some tips and tricks for interacting with pivot tables in Google Sheets.
Adding some AutoFill magic to your Google Sheets Apps Script projects
Google Sheets users can already use the magic of AutoFill to expand data automatically detecting a series of numbers, letters or dates. This feature is particularly powerful even when your series includes text or repeating dates. In this post I’ll highlight how you can also use AutoFill in your Google Apps Script projects
Dashboards in your inbox – Revisting tips on emailing inline Google Sheet chart images with Google Apps Script
Back in 2015 I shared a post on Tips on emailing inline Google Charts from Sheets using Apps Script, which looked at how you can email charts from Google Sheets. This solution is one I use in my work on a daily basis and remains largely unchanged. More recently I was faced with the problem that I couldn’t include a Combo Chart. In this post I revisit this problem and share a solution for including copies of your Google Sheet charts in your email reports.
How we survived a pandemic: Part 4 – Virtual pizza nights and other distributed team social activities
This is a conversational blog post (cross-posted here) between Martin Hawksey (@mhawksey) and Maren Deepwell (@marendeepwell). We are using this approach to create some space to think together in ‘unprecedented times’. For regular readers this is a slight departure from our regular ‘Virtual Teams’ posts (you can read those on our Virtual Teams summary page) […]