This is what I am trying to achieve with the function propertiesstorage():
Code
function rowcount()
{
var token = getAccessToken();
var module = "sHistory";
var rows = 0;
var go = true;
var i = 1;
var data;
var page = 0;
while (go) {
Utilities.sleep(20000);
data = getRecordsByPage(i,200,token,module);
if (Number(data.info.count) < 200)
{
go = false;
};
if ((i%10) == 0)
{
go = false;
}
else if (Number(data.info.page) === true)
{
go = true;
}
page = Number(page) + Number(data.info.page);
rows = Number(rows) + Number(data.info.count);
//Logger.log("Page " + page);
//Logger.log("Zoho Recruit Records" + rows);
i++;
}
return rows;
}
function propertiesstorage()
{
// saving rowcount in GAS properties
var scriptProperties = PropertiesService.getScriptProperties();
scriptProperties.setProperty("sHistoryRows",rowcount());
//reading rowcount from GAS properties
var scriptProperties = PropertiesService.getScriptProperties();
var data = scriptProperties.getProperties();
for(var key in data)
{
Logger.log([key,"sHistory total count "+ rowcount()]);
}
var scriptProperties = PropertiesService.getUserProperties();
var updatevalue = userProperties.getProperty(rowcount());
updatevalue = rowcount();
scriptProperties.setProperty("sHistory total count",updatevalue)
Logger.log([key,"sHistory total count "+ updatevalue])
}
}
This is the reference I am using to try and achieve this - https://developers.google.com/apps-script/guides/properties