Forum Discussion
Articulate Storyline: Export to Google Drive
PREVIEW | SOURCE
On the Articulate user days in Utrecht (2015), we held a session about exporting Articulate Storyline variables to Google Drive (Spreadsheet). This export is achieved via...
After some "console.log" tests, it seems that the google ASL code can't go after this line (see in bold):
"
function handleResponse(e) {
// shortly after my original solution Google announced the LockService[1]
// this prevents concurrent access overwritting data
// we want a public lock, one that locks for all invocations
var lock = LockService.getPublicLock();
lock.waitLock(30000); // wait 30 seconds before conceding defeat.
try {
Logger.log("Starting handleResponse"); THING THAT I'VE ADD AND APPEARS IN THE CONSOLE
// next set where we write the data - you could write to multiple/alternate destinations
var doc = SpreadsheetApp.openById(SCRIPT_PROP.getProperty(KEY));
Logger.log("Spreadsheet opened successfully"); THING THAT I'VE ADD AND NOT APPEARS IN THE CONSOLE
var sheet = doc.getSheetByName(SHEET_NAME);
Logger.log("Sheet found: " + SHEET_NAME); THING THAT I'VE ADD AND NOT APPEARS IN THE CONSOLE
// we'll assume header is in row 1 but you can override with header_row in GET/POST data
var headRow = e.parameter.header_row || 1;
var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
var nextRow = sheet.getLastRow()+1; // get next row
"
"
