Search Results for: lockservice

Creating a Google Sheets Row Archiver with Google Sheets API Advanced Service and Apps Script

I have a client project coming up shortly where I will be diving back into the Google Sheets API Advanced Service in Google Apps Script. As part of my refamiliarisation with the API, I was thinking about the minimum number of API calls it would take to efficiently create a Google Sheets line archiver based … Continue reading “Creating a Google Sheets Row Archiver with Google Sheets API Advanced Service and Apps Script”

Prevent consecutive clicks of Google Sheets Image Buttons in with Lock Service and Google Apps Script

Ever seen an overzealous user madly clicking on an image button in Google Sheets to run an automation script? It’s maddening, frustrating and most importantly, may cause errors in your beautifully crafted code. How Iplaysmash GIFfrom How Iplaysmash GIFs In this short tutorial, we explore how to use Google Apps Script’s Lock Service to prevent … Continue reading “Prevent consecutive clicks of Google Sheets Image Buttons in with Lock Service and Google Apps Script”

Creating an embedded interactive Chain Story app with Google Apps Script and Google Sheets

Google Apps Script: WebApp, HtmlService, LockService; Google Sheets In this tutorial, we are going to create an interactive story chain app that we can embed into a Google Site or your own site like WordPress. What’s a chain story, Yagi?  Maybe you did this in school. Someone wrote the first part of a story. You … Continue reading “Creating an embedded interactive Chain Story app with Google Apps Script and Google Sheets”