AppsScriptPulse

Solutions, Web App

Delegating Client-Side Requests with google.script.run in Google Apps Script – Jeff Everhart

Tags:
| | 0 Comments |

After a while, writing code becomes less about knowing all of the specifics of a language, framework, or platform, but more about being able to match patterns. After seeing a sufficient number of different problems, you get better at saying, “Hey, this bit of problem X seems a lot like this part of problem Y, maybe we could use that.”

In this post, learn about the Delegation Pattern that describes an object whose role it is to accept requests, delegate those responses to other objects, then return the responses to the original caller.

Source: Delegating Client-Side Requests with google.script.run in Google Apps Script – Jeff Everhart

Community News

ES 6 Features for Google Apps Script: Template Literals – Jeff Everhart

Tags:
| | 0 Comments |

In this post, I look at using template literals, an ES6 feature now available to Google Apps Script developers, to create dynamic multiline strings.

Source: ES 6 Features for Google Apps Script: Template Literals – Jeff Everhart

Solutions, Sheets

Retrieve Rows from Google Spreadsheet with Google Apps Script

Tags:
| | 0 Comments |

After answering 100’s of Google Apps Script questions, I realized how many projects people are working on that start with a Google Spreadsheet as a base. A lot of my existing examples involve using a Google Form to trigger scripts that do things to data being written to a spreadsheet, so I typically have to describe what to do using quick code snippets or links to other docs.

In this post, we look at the easiest way to retrieve all of the rows of data from a Google Spreadsheet using Google Apps Script.

Source: Retrieve Rows from Google Spreadsheet with Google Apps Script – Jeff Everhart