Accessing HTML script variable from google script

Question

I'm trying to put together a picker in google sheets. Once a file has been uploaded to google drive, I want the url to be posted in the current cell in the spreadsheet.

This is my pickerCallback located in an html file:

var message;

function pickerCallback(data) {
    var action = data[google.picker.Response.ACTION];
    if (action == google.picker.Action.PICKED) {
        var doc = data[google.picker.Response.DOCUMENTS][0];
        var id = 'https://drive.google.com/open?id=' + doc[google.picker.Document.ID];

        google.script.run.accessSpreadsheet(); 

    } message = id;
    document.getElementById('result').innerHTML = message;
}

This returns the url in the picker dialog box.

My accessSpreadsheet function looks like this and is located in a google script file:

function accessSpreadsheet() {
     var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
     var currentCell = sheet.getCurrentCell();
     currentCell.setValue(message);
     return spreadsheet;
}

The function runs but it cannot define message. Is there a way to access the variable defined in the function in the html file from the google scripts function? Or is there another better way to do this?

https://stackoverflow.com/questions/14109538/trying-to-read-cell-1-1-in-spreadsheet-using-google-script-api Check this out. May be helpful — Chandra Shekhar, Dec 17 '18 at 12:29
Thank you for the response, however this doesn't really relate to my problem — PhilipB, Dec 17 '18 at 12:50

TheMaster · Accepted Answer · 2018-12-17T13:30:26.307

0

Solution:

Pass the string id from client side to server.

Snippets:

google.script.run.accessSpreadsheet(id);

function accessSpreadsheet(id) {

 currentCell.setValue(id);

Reference:

Client-Server communication

edited Dec 17 '18 at 13:30

answered Dec 17 '18 at 13:00

TheMaster

45,448
6
62
85

Thank you, it worked! Is there any place I can learn more about this? – PhilipB Dec 17 '18 at 13:28
@PhilipB Added a reference. – TheMaster Dec 17 '18 at 13:30

Accessing HTML script variable from google script

1 Answers1

Solution:

Snippets:

Reference: