Returning Multiple Argument Values in Google App Script

Question

I'm currently building a sheet which institutes a modal/sidebar. My issue is that I really need multiple values passed from a function in my *.gs file.

Currently I know I can implement this:

google.script.run.withSuccessHandler(myFunction).gasFunction('argument value');

Index.html

<html>
<head></head>
<body>
<script>
    var hello = 'Not Working';
    google.script.run.withSuccessHandler(indexLog).logMe('hello');
    function indexLog(hello) {
        console.log(hello);
    }
</body>
</html>

GAS SCRIPT

function logMe(hello) {
    return  hello;
}

So I'm in a position where I'm running a continuous method multiple times in order to return all arguments needed, ie.

google.script.run.withSuccessHandler(indexLog).logMe('value 1');
google.script.run.withSuccessHandler(indexLog).logMe('value 2');
google.script.run.withSuccessHandler(indexLog).logMe('value 2');

My values would be cell references, but I need a range not a single cell value

I'm then taking those values and would like to build an array from those to iterate the values across my for loop function correctly.

Thanks in advance!

John Slegers · Accepted Answer · 2016-02-12 15:40:51Z

1

It was in the minute details of the methods.

SpreadsheetApp.getActiveSheet().getRange(cell).getValue();

function returnCellValue(cell) {
    return (SpreadsheetApp.getActiveSheet().getRange(cell).getValue());
}

This will only return 1 value even if a range is inputted. getValue() only returns 1 value regardless of the range.

SpreadsheetApp.getActiveSheet().getRange(cell).getValues();

function returnCellValue(cell) {
    return (SpreadsheetApp.getActiveSheet().getRange(cell).getValues());
}

Using getValues() passed the range as an array that I could then iterate over. Currently Google App Scripts and Sheets only support ranges for touching cells so you cannot use a comma separator to define all ranges needed if they are not neighbors of the referenced cell.

edited Feb 12, 2016 at 15:40

John Slegers

47.4k23 gold badges205 silver badges173 bronze badges

answered Feb 12, 2016 at 15:38

Brian Ellis

2,4612 gold badges20 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Returning Multiple Argument Values in Google App Script

Index.html

GAS SCRIPT

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Index.html

GAS SCRIPT

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related