Google Apps Script

By Barrie Roberts | GAS and Javascript related to GAS

Reply to Google Forms survey respondents direct from Google Sheets

You’re happy!<p>You sent out a Google Forms survey to your customers and received hundreds of responses.<p>They’re sitting pretty in a Google Sheet but now …

Python Programming

Apps Script Basics (17) – Making quizzes in Google Forms

In this post we’re going to look at how you can set up a <b>Google Forms quiz</b> with Apps Script. As an example, I’m going to take you through the example …

Chose

Learn & Understand JavaScript’s Map Function

Lear how to use Array.prototype.map()<p>This is article #1 in a four part series this</b> …

JavaScript

Apps Script Basics (16) – Form page navigation

In this post, we’re going to expand on my previous post on setting up form validation and improve the clocking in and out form we set up, so that the …

Web Development

Apps Script Basics (15) – Form validation

In this post, we’re going to look at automatically setting up validation on a form. Validation allows us to control what the user inputs on the form, …

Web Development

Stranger Things Alphabet Wall Project

Stranger Things

Javascript: What’s `this`?

Many new Javascript developers — and even many that are not so new — struggle to know what this is at some point in their program. Often we learn …

JavaScript

Apps Script Basics (14) – Using Form Responses

In my previous posts we looked at how we can create Google Forms from Google Sheets. This time we’ll look at how we can work with the responses a …

Python Programming

Fetch Data from MYSQL to Google Spreadsheet

MYSQL is the most popular RDBMS. Also it is open-source and is being used by many tech giants like Google and Facebook. Today in this article we will …

Databases

Jazzari lets you sketch musical ideas in your browser, with JavaScript

Open up a browser tab, use code sketch musical loops and grooves (using trigonometry, even), and play / export – all in this free tool.Jazzari has …

JavaScript

Apps Script Basics (13) – Adding different types of questions to a Form

In this post, we’re going to look at how we can add different types of questions to a Google Form from a Google Sheet. As an example, we’re going to …

Python Programming

teacher, traveller, programmer

This project was born from the brain child of Melissa Oliver and her passion project, to create accessibility in classrooms.<p>Teachers do not always …

Google Drive

How I automated weekly document creation using Google Apps Script

We use Google Docs to create and collaborate on Weekly Business Reviews across various departments. An essential part of the process is document …

Google

TSCron — A Google Forms Cron Scheduler powered by Google Apps Script

Introducing <b>TSCron</b> — an open source Google Forms based Cron scheduler powered by Google Apps Script.<p>Cron scheduling is available</b> …

Linux

APPS SCRIPT BASICS (12) – Creating & updating a multiple question form

Following on from my previous post on creating and updating Google Forms, here we’ll look at adding and updating <b>multiple questions</b> to a form.<p>Creating …

Python Programming

APPS SCRIPT BASICS (11) – Creating & updating a Google form

In this post, we’re going to look at how to create a Google Form with a multiple-choice question. We’ll look how you can create the form from data in …

Python Programming

Intro to the map function

<i>this post was originally published on my Github Pages site on September 13th, 2017</i><p>This might sound a bit outlandish or ridiculous, but I seldom write …

Programming

TU12: Teachers are Makers: Coding with Google Scripts

JavaScript project ideas and practical uses

<i>This article originally appeared on Simple Steps Code which tries its best to help people learn JavaScript and actually remember it.</i><p>Over and over, I …

Show data from GitHub's API in Google Sheets, with Apps Script & Oauth

This post shows you how to connect a Google Sheet to GitHub’s API, with Oauth and Apps Script. The goal is to retrieve data and information from …

Software Development

First Step - You Can Code Google Apps Script - Teacher Tech

You Can Code Google Apps Script<p>I literally learned to code Google Apps Script in one hour. I went from knowing zero about Google Apps Script (other …

Programming

YouTube

Debug[[item.title]]Copy Visitor IDShow logging …

Business Intelligence

JavaScript: What is the return statement?

JavaScript tips & tricks in <b>3 minutes or less</b>. Today’s topic: return — when to use it and what it does.<p><b>If you’re a new developer, it’s important you</b> …

JavaScript

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 …

JavaScript

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

by Bradley Nice, Content Manager at ClickHelp.co<p>Wikipedia defines JavaScript the following way:<p><b>JavaScript</b> (<b>JS)</b> is a high-level, dynamic, weakly …

Programming

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