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 […]
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.
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…
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.
Currently one of the most popular posts on this site is my Google Apps Script Patterns: Writing rows of data to Google Sheets. Given Google’s recent announcement of the general availability of the new V8 runtime I thought it was worth revisiting this particular pattern and using the modern syntax now available to Google Apps Script developers.
In this post I want to share some advice and ideas for all the team leaders and managers who have suddenly inherited a virtual team. This advice comes from over two years working with my boss, Association for Learning Technology (ALT) CEO Maren Deepwell, transitioning ALT from a ‘traditional’ office based organisation to one that is fully distributed.
This is a cross-post from OpenScot.net on 28 February 2020. Less than a month on and OER20 has been impacted by the global situation and has had to move online. A number of the face-to-face sessions will no longer be run but a number will be and there is now free registration available for the reduced online programme.
Welcome to this month’s post (cross-posted here) in which we, that is Maren Deepwell (@marendeepwell) and Martin Hawksey (@mhawksey), openly share our approach to leading a virtual team. If this […]
On Friday I had the honour of speaking at a @HDINework workshop in Edinburgh for ALT with my boss Maren Deepwell. The purpose of the workshop was to answer the […]
Welcome to this month’s post (cross-posted here) in which we, that is Martin Hawksey (@mhawksey) and Maren Deepwell (@marendeepwell), openly share our approach to leading a virtual team. If this […]
Welcome to this month’s special podcast (cross-posted here) in which we, that is Martin Hawksey (@mhawksey) and Maren Deepwell (@marendeepwell), openly share our approach to leading a virtual team. If […]
Earlier in the year I managed to get a bulk emailing script published in the G Suite Developer Solutions Gallery. In this post I want to show you how you […]
This time we talk about staff benefits and CPD opportunities for virtual teams, the environmental impact of work travel and discuss the advantages of connecting both virtually and in person.
This is a special #OEB19 post (cross-posted here) sharing our conference session: Leading Change through Open Conversational Digital Practice. In the session the two of us, that is Martin Hawksey […]
I always enjoy presenting at DevFest as usually it is a reason to explore something new. In the case of DevFest London it was an opportunity to think about how voice interfaces could be used as part of a Google Slide presentation. In this post I’ll share some of the ideas I explored and how they did/didn’t work out.
ALT has worked as a fully distributed organization for almost two years now and I thought it would be useful to share the technology and services we use to support our distributed team, aka ‘The ALT Stack’.
How is the way we work and communicate changing as we work in ever-more-distributed ways? In this special #OEB19 post we give you a preview of the work we will share at the conference and the conversation we hope our session will prompt.
Recently I had the opportunity to be interviewed as part of a marketing video that is being pulled together by Google to promote Google Apps Script. This post has the notes I prepared for the video shoot
Recently I’ve been experimenting with a content curation site for the Google Apps Script community (see Apps Script Pulse – Sharing Google Apps Script community content). In this post I […]
Welcome to this month’s post (cross-posted here) in which we, that is Martin Hawksey (@mhawksey) and Maren Deepwell (@marendeepwell), openly share our approach to leading a virtual team. This time […]