Change my code from Variable to Array

Question

I have a beautiful set of code provided from one of the best community member. What this code does is it reads a cell value from Google spreadsheet and then automatically check the checkbox of a html form. Now I want to make that code read a range of spreadsheet meaning making the values store in array and perform the same function in html form.

Here is the Javascript which reads a single cell value:-

function getValues(){
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Sheet1");
var match1 = sheet.getRange("B2").getValue();
return match1;
}

My new JS code has changed say match1 = sheet.getRange(2,2,5,1).getValue(); how should my HTML code would change?

Here is the Index.html which performs the auto checkbox function:-

<script>
google.script.run.withSuccessHandler(checkDefault).getValues();

function checkDefault(val){
var checkBoxName = "name"+val;
document.getElementById(checkBoxName).checked = true;
}
</script>

Any help is appreciated. Thank You!

Robin Gertenbach · Accepted Answer · 2017-08-11 09:43:52Z

1

To read ranges you need to use the range's getValues() method, not getValue(); getValue returns the top leftmost cell's contents.
getValues() will return an array of rows. Each row being an array of cells within that row.
Be aware that it returns an array of arrays, even if it's just one column wide or one row high.
So if you want an array you can

var match1 = sheet.getRange("B2").getValues().map(function(row) {return row[0]});

In the script try

google.script.run.withSuccessHandler(checkDefault).getValues().forEach(checkDefault);

edited Aug 11, 2017 at 9:43

answered Aug 11, 2017 at 8:36

Robin Gertenbach

10.9k3 gold badges30 silver badges38 bronze badges

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

6 Comments

Mask Over a year ago

I have a set of values in cell "B2" = "1", cell "B3" = 2, cell "B4" = 3.

Mask Over a year ago

cant make it to run correctly. should I post my sheet link?

Robin Gertenbach Over a year ago

It would help to have a reproducible example yes.

Mask Over a year ago

Here is the link Robin.

Robin Gertenbach Over a year ago

Did you try running onOpen in the script editor? When I did that and approved access to sheets it worked.

|

Collectives™ on Stack Overflow

Change my code from Variable to Array

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related