Sunday 28 May 2017

How to filter 10 values of an array at a time with a delay?

I have a JSON file with around 400 elements I want to put onto a google sheets. I got that working but I need to keep delay it.

So current code is something like

 function workingWithCells(step) {
 sheet.getCells({
     'min-row': 2,
     'max-row': 500,
     'return-empty': true
}, function(err, cells) {
  for (var i = cells.length - 1; i >= 0; i--) {
    var row = parseInt(cells[i].row)
    var tdata = data[row - 2];

How would I make it so I would filter 10 rows of the spread sheet and fill in data accordingly, then wait 5 seconds then add another 10 rows of information?



via Daniel.M284

No comments:

Post a Comment