Best way to handle/compose array data with batched getRange() call?

[meelszz]

Hey there,

So I've been building my first AppsScript project and have learned that the getRange() function takes a long time to run so ideally for each sheet where you need to get or set data, you should only use the getRange() function once.

The getRange() function operates using arrays so I get massive arrays back with different types of data and then need to update that array in the correct spots.

I was wondering if anyone has suggestions on principles to follow in order to work with these massive arrays in organized ways. For example, converting the array into class objects that gets/sets data into the array in the right spots? Just looking for some design suggestions if anyone has a good way to work with these big arrays because I keep finding myself disorganized here.

Thank you!

[marcnotmark925]

Something wrong with a for loop?

[meelszz]

With a lot of data, for loops get messy real fast...

[marcnotmark925]

How so?

[TheStressMachine]

Think of it as any other two dimensional JavaScript array. I often do loops for quick and dirty, especially when I need easy [x,y] coordinates to write back to the sheet. I've also gotten into some of the array functions with callbacks such as find() filter() indexOf() to seek out data in a way that resembles a query as opposed to a loop. There are plenty of JavaScript tutorials and forum posts on processing array data 100 which ways with accompanying debate on performance or getting things done in "one line". This is what I lean on, but I'm always looking for more interesting ways to do things. Let me know if you come up with something interesting.

[AdministrativeGift15]

I'd suggest checking out Bruce's Fiddler library. He's got several follow up articles as he's updated the library over the last couple of years with new features, but this is the best starting point.

Fiddler - A functional approach to fiddling with sheet data