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)”