In March 2018 Google announced it was closing it’s Google URL Shortener giving developers one year to migrate to their new Firebase Dynamic Links (FDL) service or other providers. The URLShortener is also an […]
Google Apps Script
At Google Cloud Next ‘18 it was great to see and hear about a number of G Suite and Google Apps Script updates. This post highlights a number of launched and future developments for Google Apps Script
If your G Suite Add-on or Apps Script project needs to add personal data protection this post identifies 12 steps you can take now
This post looks at key definitions to help you identify if you G Suite Add-on or Google Apps Script project needs to consider personal data protection
In this post I’ll show you some patterns you can use for using Google Analytics client side in HTMLService and server side with any Google Apps Script code you are running backend. As part of this I include GATrack, a Google Analytics tracking helper class for Google Apps Script
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.
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