JavaScript 2 Dimensional Arrays, Reading & Writing Array To and From Ranges - Part 2 - Apps Script

Learn about 2 Dimensional JavaScript arrays & array methods. This tutorial covers 2 dimensional arrays, using Apps Scirpt to write array to Google Sheets, moving Google Sheets data to a JavaScript array & more.

[RamBabu-inek]

your teaching style is superb sir. very clear and very easy to understand...

[rotrose]

Thak you very much, very practical, just the tutorial I am searching for. binding google spread sheet with javascript, revolutional. thank you

[ericjohnson]

Thank you for your videos. I've been subscribed for 2 years, and it has help tremendously. Is there a video on how to filter out duplicates on the first column of a 2-dimensional array? Thanks again.

[geova]

I had hours looking something in google and I just saw it easily in your video... it took me only 5 min... thanks for the awesome video and the way to teach, bro! PD: I have learned other stuff in other videos from you :D

[firzaaldian]

thanks for the video i was trying to push element and forgot that to adding index in front of variable. your videos make it clear

[yxngmxnny]

At 21:40 to automatically calculate the length of the row you used
*newarray[0].length*
What if any row that is not the first row [0] is longer than the first row [0] itself?
How do we now get it to automatically calculate the row length of the array?

[vishaljangra]

What an easy way for describing complicated things. Thanks a lot

[MarcelSIKLI]

Thanks for your video. Its very useful. But can you explain how to initialize an EMPTY array with 2 dimensions. Thanks

[howmightwe]

Thank you for sharing! I'm trying to get T/F values of individual cells separately, and I'm stuck on the A1 notation... Any ideas? I know I could just make a helper column with it all lined up, but I'm curious...
None of these seem to work:

let checkboxArray = [["F30"], ["J30"], ["N30"], ["R30"]];
    let checkboxArray = ["F30", "J30", "N30", "R30"];
    let checkboxArray = [[30, 6], [30, 10]]

[daviddelgado]

Hi, how can I insert the 2d array into a range with combine cells ??

[vladk.]

oh my fk god.... i search 3h how i can write 3d matrix. and only u show this. TY so much!!!

[bnproduction]

how to apply a default spreadsheet function e.g., SUM, Mean etc. to a range of selected column (P.S. the range is not fixed)

[tazulislam]

How to setValues array of array from web app?
Make a time for me please!

[dmsmcc]

I was able to log date range with get Range method however, I faced problem in returning that particular date range as an array of array. please help me.

[maxieearle]

Hi, do you know why I can't set the Range row and column using the values in an array.. when I chack the logs they seem to output a number but that number doesn't seem to work..


var range
var dates = sched.getRange(2, 1, 2, 30).getValues();

var startDate = range[0][2];

var col = range[0][4];
var row = range[0][5];

Logger.log(col);
Logger.log(row);

sched.getRange(row, col).setValue(startDate);

[davidstahl]

Very helpful Tutorials! Thank you a lot for this!

Can you show how use Spreadsheet as an Database with a own custumized HTML Interface where i can change the values from the sheet?
If i have a Spreadsheet with a 2D-Array with all Kinds of Data (text, radio, checkbox, date, datetime, Dropdown-List).
I want to select a row and can show its Data in my html templete. Then i change all the values in the html Template.
Then Press a Submit Button which update the right row in my Spreadsheet with the new Values.

I can only find Tutorials to do this with Text Fields, but i dont know how to handle checkboxes, Radio, date, datetime, Dropdown-Lists

[KhalilYasser]

Thanks a lot for awesome tutorials. Can you post the code used in the video?

[rogerangel]

is there a such thing as indexOf() for two dimensional array?

[ajadsingh]

Please make project file upload from html single upload to google drive and multiple.

[nayltonlopes]

Hi Everyone, How can I apply a "breakpage" on spreadsheet using Google Script?
Thank you all!