JavaScript Arrays - Programming Like a Grown Up - Google Sheets Apps Scripts - Array Methods Part 5

In this tutorial learn how to superspeed your google scripts using JavaScript arrays. Programming Google Sheets Apps Scripts - Array Methods Series Part 5

#javascript #arrays #programming

[mizmoman]

Yet another great series! I learn something eye opening from each one. Please keep them coming, and thank you for so graciously sharing your knowledge and expertise.

[PhamTienPhong]

Thank you. This is also a fundamental knowledge that a GAS dev must know. Try not to interact with GG Sheet (using GAS API) if you can. Instead, read all data in one time, process it in javascript then return the processed data to the GG Sheet.

[lunaRdeltaY]

now this is what i missed as a newbie to app scripts, thx bro!

[mistharmarbles]

one of the best and best app script tutorial

[TheKeule]

BTW, you can switch to the sheet, while running the code and watch what happens as the code runs

[TheOrteme]

Awesome man, very clear illustration, thanks a lot

[lauramcooley]

yes and yes and yes. Thank you so much!!

[RajaGiri_tvpm]

I like arryformula script, (let me use & check) 👌

[TheKaun]

Why not return just r if it is arleady an array?

[filipdaszkiewicz]

Thanks a lot for that tutorial with JS. BTW how we can do some more advanced math with arrays? For example, 2 or 3 numbers are divide by num of columns to get average, we can do that with for loop but that is not the case in the map method as I think

[kwanfong]

I believe for loop works fine. but for loop call the google sheet API every single time will slow down the script. Do you think set var of the spreadsheet range, do the mechanic on the var and setvalues at the end help ?

[VideoNOLA]

Somehow I find it SO MUCH EASIER to deal with GAS/Sheets data as mapped arrays instead of the native nested ones. It's sad that Google waited so many years to updates GAS to ES6!

[eiger]

Hi, with the new version 8, editor & way to write the scripts are changed. I'd like to know if you plants to update some video concerning the way to write arrays methods. The VAR declaration method was substitute by CONST, arrays with callback are update with ARROWS method, method to write LOOPS is no more longer (for var i=0) but data.map(callback). Personally i still confuse which kind of array should i use to get the result i want, map, filter, indexOf, every, some, foreach... Do you think you plant a serie of videos where you maybe would answer questions from your followers with real example? This would be just for private and absolute NOT commercial porposes. I would really appreciate a kind of videos concerning update of the way to write array method and answer ours questions...I'm sure i'm not the only one would appreciate that. By the way, a very big thank you for you effort and for share your knowledgees, with all humans beans.

[rajeshr]

In the first example when I add new rows will the Profit be auto calculated or do I need to run the script each time? If the script has to be run each time then “Arrayformula” option would be better for simple functions like Profit.

[kim]

return [ r[0].split(", ") ] is okay?
I think this takes more short time.

[tazulislam]

how to post 2dumentional array to sheet using api? Please!

[Blackdocks]

Great video again ! Using .map just made my day but I'm stuck because if have a custom function an i copy the code in the .map(function XXX) i got it working, but by calling it i end up with nulls
Dataset is small so i could go with loop through the data in my sheet but I would love to get it and understand the good way. if anyone has ressources to point me to learn around this so I can go further i would be glad

Awesome! Is it faster to run these scripts compared to using normal formulas copied down (or arrayformulas in the first row)?

[RoseLK]

Could you share the sheet for everyone to practice? Thanks in advance :D

[fvgoya]

This really cool but, is not easier just do “=E2-F2” and just copy this formula into the cells below? I mean, what’s the benefit to use code??