Google Apps Script access values from dialog box

Question

I followed this tutorial https://yagisanatode.com/2018/06/10/google-apps-script-getting-input-data-from-a-dialog-box-in-google-sheets/ to create a dialog box in Google Sheets and print the values. However, I'd like to feed these values into a new function. If I try to access them in line 29, the code somewhat breaks. I say 'somewhat' because it still runs until line 28, but I think it doesn't execute line 28 as I can't see anything in the log.

I also noticed that it doesn't close the dialog box automatically once I add my two new lines. I assume it has something to do with the function closeIt in testUI.html, but I can't figure out what it is as I'm new to jQuery/Javascript.

code.gs

 //--GLOBALS--

 var ui = SpreadsheetApp.getUi();


function onOpen(e) {
// Create menu options
ui.createAddonMenu()
    .addSubMenu(ui.createMenu("Admin")
        .addItem("Test", "test"))
    .addToUi();
};

function test() {
//Call the HTML file and set the width and height
var html = HtmlService.createHtmlOutputFromFile("testUI")
    .setWidth(450)
    .setHeight(300);

//Display the dialog
var dialog = ui.showModalDialog(html, "Select the relevant module and unit");

};

function runsies(values) {
//Display the values submitted from the dialog box in the Logger. 
Logger.log(values);
//I added the two lines below because I'd like to access the values, not just print them.
var valuesAcc = values[0]["orange"]
Logger.log(valuesAcc);
};

//I'd like to run another function after runsies so I can work with the values which were inputted 
//into the dialogue box.

src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js">

function form_data(){
        var values = [{
          "orange":$("input[name=orange]:checked").val(),
          "blue":$("input[name=blue]:checked").val(),
          "green":$("input[name=green]:checked").val(),
          "purple":$("input[name=purple]:checked").val()
        }];
        google.script.run.withSuccessHandler(closeIt).runsies(values);
      };
      function closeIt(){
        google.script.host.close()
      };

And I think I should use a later version of jQuery?

Cooper · Accepted Answer

Accessing values from a Dialog is easily performed with google.script.run. Information can be found at Client To Server Communication.

Here's a couple of examples of dialog boxes that I've done:

Data Entry Dialog Created from Header Info on Spreadsheet

Simple Example

Google Apps Script access values from dialog box

Answers (1)

Related Questions