This is a joint post with Maren Deepwell (cross-posted here) This is the second in a monthly series of blog posts in which we take an open approach to organisational […]
Matt Knoll (@KnollMatt) recently posed me an interesting question asking how to record audio to a user’s Google Drive using Google Apps Script. Having previously played around with WebRTC I […]
I was recently asked me if I knew a way to create custom branching in Google Forms. The scenario was they had a list of employee names in a Google Sheet which they wanted to turn into a Google Form drop-down list which when selected would redirect the respondent to their own section of the form.
This is a joint post with Maren Deepwell (cross-posted here) We work for ALT, the UK’s leading professional body in Learning Technology. We serve a community of over 3,000 Members […]
In the previous post in the Google Apps Script Pattern series we looked at selectively updating rows of data in a Google Sheet. For this post we will look at a couple of patterns for inserting multiple rows of data into Google Sheets.
In the previous post in this Google Apps Script Patterns series we finished with an example of how you can read and use row data from a Google Sheet. In this post we are going to extend this pattern so that as well as reading the data we also update rows.
In my last post I shared a Google Apps Script Pattern for getting a Google Sheet header row. In this post we are going to extend this to look at some patterns for processing rows of data from Google Sheets
Often in Google Sheets you want to grab the header row, this might be in preparation to read/write data, to populate some UI, or something else. Here are some Google Apps Script patterns for doing this
Note: TypeError: Cannot find function insertShape in object Slide error. There is an open issue ticket reporting this problem If you are looking for a way to add snowflakes to […]
In this post I’m going to show you how you can use Google Apps Script with IFTTT to do more than this and that. As part of this I’m going to show you how I got my Wemo Smart Switch to turn on for a defined number of minutes with a Google Assistant applet.