Month: June 2018

Google Apps Script, Jquery, Javascript, HTML

One of the weekly tasks in my day job as an academic administrator is to look at a number of ‘modules’ or courses that our college is running and complete some analysis and crosschecking. Each week the students complete a ‘unit’. However, during some quarters, not all modules are doing the same unit. Before I can run my code I need to determine what modules are running and what units we are up to for me to run my automated code.

To do this I created a dialogue box when the code is run from the add-on bar. In a few clicks, I can then choose the relevant modules and units and then run the selected code.

Let’s take a look at what the dialogue box looks like:

Upon “Submit”, the dialogue box returns an array of objects of checked values from the radio buttons that can be used in the server-side Google Apps Script.

In this tutorial we will look at the following :

• Creating a Menu Item and Sub-Item in the Add-on’s menu.
• Setting up a Dialog Box.
• Preparing a HTML file to set inside the Dialog Box.
• Getting the data from the Dialog Box and Sending it Server-side.

Continue reading “Google Apps Script – Getting Input Data From a Dialog Box in Google Sheets (Updated January 2022)”