Good Day,

How do you add the last row count number onto every passing, let's say the function repeatloop() code below passing 2000 for 1 pass, how do you add 2000 to each passing that happens so if the passing is 10 that would == to 20 000 at the end of 10 passing, please see my code below:

function rowcount()
{ 
 var token = getAccessToken();
 var module = "sHistory";
 var rows = 0;
 var go = true;
 var i = 1;
 var data;
 
  
  while (go) {
    //Utilities.sleep(10000)
   data = getRecordsByPage(i,200,token,module);
   
   if (Number(data.info.count) < 200) {
     go = false;
   };
   if ((i) == 0) {
      go = false; 
   }
   rows = Number(rows)   Number(data.info.count);
     i  ;
  
     Logger.log("rowcount "   rows)
     }
     return rows
  }
 
 
function repeatloop()
{
 for(var i = 1; i <= 93; i  )
     {
       Utilities.sleep(10000)
       Logger.log(i);
       Logger.log(rowcount());
     }
     return rowcount();
}

So currently the output is doing this:

2:20:15 AM Info 1.0 2:20:16 AM Info 200.0 2:20:16 AM Info 400.0 2:20:17 AM Info 600.0 2:20:17 AM Info 800.0 2:20:17 AM Info 1000.0 2:20:18 AM Info 1200.0 2:20:18 AM Info 1400.0 2:20:18 AM Info 1600.0 2:20:19 AM Info 1800.0 2:20:19 AM Info 2000.0 2:20:19 AM Info 2000.0 2:20:19 AM Info 0.0 2:20:29 AM Info 2.0 2:20:30 AM Info 200.0 2:20:31 AM Info 400.0 2:20:31 AM Info 600.0 2:20:31 AM Info 800.0 2:20:32 AM Info 1000.0 2:20:32 AM Info 1200.0 2:20:32 AM Info 1400.0 2:20:33 AM Info 1600.0 2:20:33 AM Info 1800.0 2:20:33 AM Info 2000.0 2:20:33 AM Info 2000.0 2:20:34 AM Info 2000.0 2:20:34 AM Info 200.0 2:20:34 AM Info 400.0 2:20:35 AM Info 600.0 2:20:35 AM Info 800.0 2:20:35 AM Info 1000.0 2:20:36 AM Info 1200.0 2:20:36 AM Info 1400.0 2:20:36 AM Info 1600.0 2:20:37 AM Info 1800.0 2:20:37 AM Info 2000.0

CodePudding user response：

Didn't get you well, but maybe you need something like:

let counter = 0;
function repeatloop() {
  for (var i = 1; i <= 10; i  ) {
    Utilities.sleep(10000);
    Logger.log(i);

    counter  = rowcount();
    Logger.log(counter);
  }
  return rowcount();
}