JavaScript Every & Some Array Methods Tutorial - Google Sheets Apps Scripts - Array Methods Part 8

[@bulbulahmed3098]

Great❤❤

[@peraruor]

Hi! Enjoy very much your videos. They're short so, I can take a few minutes a day to learn something new. I just start watching your videos and I can't wathc any other videos about google apps script! Your videos is all I need. However, I notice some of them are quite old. Are you still responding to the comments on this channel? I see some questions unanswered. Thanks. By the way, on the last example using some, my array is empty! Any help?

[@boredomindex3353]

@LearnGoogleSpreadsheets, is it possible to simply delete empty rows without overwriting the entire sheet?

[@ExcelGoogleSheets]

Yes, but it will run very slowly. You would need to loop bottom up and delete each row by its position (index).

[@boredomindex3353]

@@ExcelGoogleSheets I thought it would be quite cool to see the data being processed in front of your eyes but if it is too slow as you said, it isn't worth it. Efficiency outweighs complexity!

[@minabenjamin3660]

Thanks a lot mate, your endeavours are much appreciated!

[@nhule8442]

Wow learn a lot from you. Thank you

[@TheOrteme]

You are doing great thing, thanks a lot for all you lessons, they are usefull!

[@testaccount6075]

Very interesting, thanks a ton!

[@markuswinter-cdps3008]

Thanks for the video!! I have been struggling with removing blank cells from an array across a row. I have dates that I am trying to pull from a row, with each cell that contains a date being a merged cell (of 2 cells). As a result the array logs as [[10/10, , 10/11, , 10/12, , 10/13, , 10/14, , 10/15, , 10/16, , 10/17, , 10/18, , etc]]. A - how do you remove the blank values in the array? B - then use apps script to write the array into one column? getMergedData()? Transpose? I'm stuck. Thanks so much for your time!

[@dme3327]

TypeError: originalData.filter is not a function (line 10, file "FilterOption") getting this problem please give solution

[@aJayBoulder]

You teach the concept of callback functions very well. That is something I've struggled with in the past.

[@johanvandervorst]

Your video's are great! They are exactly what I need to get(a lot) better at google apps script. Thank you!

[@robertmaluka2763]

I really enjoyed the video. I was laughing how the some and every were working in my mind I was thinking that is and and , or function. You even said it. I would really like to learn script.

[@phoenixempire8886]

🙏🏻

[@eiger67]

Yea what to say, thank you a lot. Great job..

[@Shkur777]

👍🏻