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%10) == 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
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();
}