Blog

Recording an AutoFill with the Macro Recorder

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

Google Sheets charts in your inbox

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) […]

New Apps Script IDE

First look at the new Google Apps Script Integrated Development Environment (IDE) Script Editor

As part of Next OnAir week 2 the focus was on ‘Productivity and Collaboration’ Charles Maxson from the G Suite DevRel team not only provided some highlights from the week, but he also premiered the new Google Apps Script IDE

One Comment
Image: CC-BY mhawksey

How we survived a pandemic: Part 3 – Ups and Downs (and sideways) of life as a virtual team

In this month’s post we share some thoughts prompted by our joint talk at a virtual team day held by the Centre for Teaching and Learning at the University of Oxford. You can access the slides from our talk here (CC-BY-SA). As we pass 100 days since the lockdown in the UK commenced we discuss the impact and look to the future as the measures start to be eased.

How we survived a pandemic: Part 2 – Music, spice and other things nice

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’. It’s open leadership in practice and in pandemic times. For regular readers this is a slight departure from our regular ‘Virtual Teams’ posts (you […]

Meeting around a document by Visual Thinkery is licenced under CC-BY-ND

How we survived a pandemic: Part 1 – No kind of normal

We are using this approach to create some space to think together in ‘unprecedented times’. It’s open leadership in practice and in pandemic times. For regular readers this is a slight departure from our regular ‘Virtual Teams’ posts taking a broader view of work whilst midst global pandemic.

Mail merge steps

A bulk email/mail merge with Gmail and Google Sheets solution evolution using V8

Last year I had a ‘mail merge using Gmail and Google Sheets’ contribution accepted on the G Suite Developers Solution Gallery. Just over 6 months on there has been lots of useful feedback and requests for solutions to some of the limitations of the original published script. In the meantime Google has also made the new V8 runtime for Google Apps Script generally available. Given this it seemed appropriate to revisit the original solution updating it for V8 as well as covering the most commonly asked for changes. In this post I’ll highlight some of the coding changes as well as some easy modifications.

92 Comments
Examples of hyperlinks in Google Sheets cells

Everything a Google Apps Script Developer wanted to know about reading hyperlinks in Google Sheets … but was afraid to ask

I’ll start off by saying this is a very geeky post and if you’ve landed here because you are struggling with extracting hyperlinks in Google Sheets then you might prefer to jump straight to Alexander Ivanov’s Extract URL’s Add-on or alternatively the Info Inspired post Extract URLs in Google Sheets Without Script. The problem: hyperlinks in Google Sheets can be in three different formats…

4 Comments
VLOOKUP in action

Tips for using Google Sheets for event programme planning

At the Association for Learning Technology (ALT) hosting large events is a regular activity and over the years we have developed bespoke workflows largely based in Google Sheets. In this post I’m going to share some of the tips we use for scheduling our events including drafting/publishing an event programme and how to keep in touch with your presenters.

« Previous Page — Next Page »
css.php