Google Apps Script

By Barrie Roberts | GAS and Javascript related to GAS

When that “simple” JavaScript tutorial is super complicated

<i>This article originally appeared on Simple Steps Code which tries its best to help people learn JavaScript and actually remember it.</i><p>“For some reason …

Tutorials

Sheetcaster: 3D in Apps Script

article<p>en_US<p>https://gsuite-developers.googleblog.com/2012/03/sheetcaster-3d-in-apps-script.html<p>G Suite Developers …

Optimizing showing and hiding rows and columns - Desktop Liberation

Best JavaScript Books In 2017

Wikipedia defines JavaScript the following way:<p><b>JavaScript</b> (<b>JS)</b> is a high-level, dynamic, weakly typed, object-based, multi-paradigm, and interpreted …

JavaScript

Apps Script Basics (10) – Range Class & Triggers

So far in this series of posts on using Apps Script with Google Sheets, we’ve looked at the classes SpreadsheetApp, Spreadsheet, and Sheet. Now we’re …

Python Programming

Drive_Mapping

For the creation of a vis.js network map to display your Google Drive structure. Be default this will map both files and folders, but can easily be …

JavaScript Showdown: == vs ===

Truthy vs. Falsy Values. Double Equals vs. Triple Equals. Know the difference in three minutes.image via unsplash.comWhy are we here?One simple …

JavaScript

ES6 Arrow Function Is Simple, This Article Just Made It Simpler For JS Beginners

The first time I saw Arrow Function on Stack Overflow it got me thinking which programming language is this. I even checked my laptop keyboard for …

JavaScript: What the heck is a Callback?

Learn and understand the basics of callbacks in just 6 minutes with easy examples.<p>What is a Callback?<p><b>Simply put:</b> <i>A callback is a function that is to</i> …

Apps Script Basics (9) – Sheet Class

In previous posts, we’ve looked at the <b>SpreadsheetApp</b> and <b>Spreadsheet</b> classes. Now let’s look at the next level down, which is the <b>Sheet</b> class.<p>Here, …

Running a Google Apps Script every quarter or x months

One of the great things about Google Apps Script is the way you can automate tasks. I’ve previously written about how I automate reporting and other …

Custom Domains on Google Apps Script

It may have occurred to you that when deploying a Google Apps Script web app, the URL spewn forth looks rather long and …

Apps Script Basics (8) – Spreadsheet Class

In the my last post, we looked at the SpreadsheetApp class. Now, let’s look at the next group related to spreadsheets, which is the Spreadsheet …

Apps Script Basics – SpreadsheetApp & for in loop

In this post, we’re going to look at the G Suite services, the Google documentation that’s available to help you, and then focus on one particular …

Apps Script Basics – if, prompt, menu, & onOpen trigger

In this post, we’re going to look at how we can get the computer to react to data in a spreadsheet and to user input. We’re going to look at the …

Using fetch() and reduce() to grab and format data from an external API - A practical guide

Today we’re going to learn how to get and manipulate data from an external API. We’ll use a practical example from one of my current projects that …

Create quizzes in Google Forms with Apps Script

article<p>en_US<p>https://gsuite-developers.googleblog.com/2017/04/create-quizzes-in-google-forms-with.html<p>G Suite Developers …

Make & Send Kids Reports

In this post, we’re going to look how we can create kids reports from a Google Sheet and convert them into individual PDFs made from Google Docs, …

Apps Script Basics – Arrays, Logger, Execution Transcript

In this post, we’re going to look at another key area in Apps Script and indeed many coding languages, that of arrays, which are just special …

JavaScript: Learn Regular Expressions for Beginners

<b>In JavaScript, a regular expression is simply a type of object that is used to match character combinations in strings.</b><p>Make your first Regular …

Apps Script – Issues reporting form, log & email

In this post, we’ll look at a way to create a quick and simple system to report maintenance and IT issues in the classroom.<p>The teacher fills out a …

Apps Script Basics – Loops

Here, we’re going to look at loops and how they can make repetitive tasks really easy and how they can save you so much coding. For example, if we …

Apps Script Basics – First Docs and Forms Scripts

Following on from my last post on creating your first script, here we’re going to edit a Google Doc and also a Google Form. This will show you how …

Apps Script – Creating & sharing Class folders in Drive

Teachers using Drive often need to set up folders for their class and for their individual students. Doing it in Drive is not the most exciting job …

Apps Script Basics – First Script

Here I want to show you how easy it is to write some code using Apps Script. This is the code that sits in the background of some of the Google Apps. …

Apps Script – Clocking in & out system

In this post, we’ll look at setting up a simple clocking in and out system using Google Forms and Sheets. This idea originally came from a real life …

Multiple FOLDER maker

Making multiple copies of folders in Google Drive is a slow, boring task. You select the folder you want, make a copy, then have to rename it, then …

Multiple FILE Maker

Making multiple copies in Google Drive is a slow, boring task. You select the file you want, make a copy, then have to rename it, then repeat this …

Pimp up your Sheet – Programmatically!

When working with spreadsheets we can spend quite a long time making them look good and if we have to make the same sheets over and over again, …