Learning Technology Advisor
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.
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.
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.
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
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.
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 […]
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
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.
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 […]
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.