Talks in 2020

Just for personal reflection I thought I would go through the talks I gave in 2020. To be honest I wasn’t expecting there to be as many as this for obvious reasons. Not entirely sure what 2021 will bring talk wise, you’ll just have to watch this space :)

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.

Totally Unscripted

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.

Recording an AutoFill with the Macro Recorder

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

Google Sheets charts in your inbox

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.