This is a sample script for setting alternate background colors for rows in Google Spreadsheet using Google Apps Script.
It has already been known when the conditional formatting rule and custom function are used, this can be simply achieved. In this report, I would like to introduce the method for using Google Apps Script.
Format (bold) a single word or a group of words automatically in sheets, using google apps script.
This example from Sourabh Choraria is a nice example of how you can apply text formatting to parts of Google Sheet cell values. Reading Sourabh post got me thinking if having an Add-on or built in feature that used basic markdown for cell formatting would be useful? e.g. typing `I just love **bold text**` would result in the cell being displayed as `I just love bold text`.
AppsScripters need a quick and easy way to keep objects hanging around, and to persist them across executions. There are services available but using them effectively is a well-worn problem. Why not solve it once-and-for-all?
Adam Morris, GDE Expert and Workspace dev, brings another library to the table to help developers work more efficiently with data in memory. This library handles in-memory storage as well as writing to the Cache and Properties services for persistent storage in Apps Script projects.
When a respondent uploads a file through Google Forms, the file are stored in a fixed folder of your Google Drive. All files are uploaded in the same folder and, thus looking at the file in your Google Drive, it is difficult to determine which respondent has uploaded which set of files.
Learn how to organize file uploads and attachments from Google Forms and move files to a specific folder in Google Drive.
We run a lot of things through Google Sheets and Slack here at August. It’s a way of connecting and sharing information quickly and transparently with our clients and our team. We’ve put together a cheat sheet of a few simple Google Apps Script functions, along with the Slack API, so you can do the same.
Great post if you are looking for a quick start for interacting with Slack using Google Apps Script. As well as a detailed ‘how-to’ the post also includes a video walkthrough to help if you get stuck with any of the steps.
In this article I will showcase one of the many ways you can customize your Google Workspace environment. We will implement two custom functions in Google Sheets. With these functions as an example I will demonstrate how to use Google Apps Script Libraries to organise and distribute your solution. There are multiple ways to distribute your Apps Script code within the Google Workspace, and this article will help you decide if this library method is right for you.
Always nice to have some advanced techniques in your toolbox. In this example from Jasper Duizendstra he explores how custom functions in Google Sheets can be packaged and used in Libraries.
Source: How to write a custom function library for Google Sheets
Learn how to merge cells in Google Sheets, when to use them and when to avoid them [and] finding merged cells in your Google Sheet using Apps Script
Some very useful guidance from Ben Collins on merged cells within Google Sheets. As well as how to merge/unmerge cells Ben also highlights some of the pitfalls when merging cells. The post also includes a very useful snippet for detecting merged cells using .getMergedRanges().
The Properties Service of Google Apps Script is used by developers to store app configuration and user specific settings. The properties data is scoped to a specific user, or a specific project, and cannot be shared between different projects. … In some specific cases, we may want to give access to our store data to another user so they may build upon the existing configuration rather than having to build everything from scratch.
Amit Agarwal shares a useful snippet for letting users export and import data from PropertiesService. There are some nice touches in this solution including using the JavaScript File Reader API.
You can use Google Script to create JSON Web Tokens (JWT) that can be provided to secure routes so that only authenticated requests that contain a valid token can connect to the APIs (e.g., the Zoom API)
Nice little snippet from Amit Agarwal for both creating and decoding JSON Web Tokens (JWT).
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.
Yagi uses a simple but very effective interactive story chain app to explore and explain some very powerful Apps Script functionality all developers should know about. This includes using the LockService which can be used to prevent concurrent access to sections of code. Yagi also highlights some recent discussions around the limitations of Web Apps and concurrent users. Click through to the source for all this and more.
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.
