Dump Quiz responses to a file or e-mail

First you need to create the Google Sheet and publish it to get an API key.

You need to create an external JavaScript file included in the Captivate index html file.

Refer to the Common JavaScript Interface:

https://helpx.adobe.com/captivate/user-guide.html/captivate/using/common-js-interface.ug.html

You will need to add 2 event listeners:

eventEmitterObj.addEventListener( 'CPAPI_QUESTIONSUBMIT', qSubmit, false );
eventEmitterObj.addEventListener( 'CPAPI_SLIDEENTER', checkSlide, false );

Create the functions qSubmit and checkSlide.

The check slide function in mine checks to see if the slide title is "Results" and if so, send the data to the sheet.

function checkSlide( e )
{
if ( e.Data.lb.toLowerCase() === 'results' )
{
if ( Number( window.cpAPIInterface.getVariableValue( 'cpQuizInfoAttempts' )) > 0 )
{
formatResults();
}
}
console.log( e.Data );
}

The qSubmit function gets the question number and attempt, correct answer and selected answer and puts them in an array of objects.

function qSubmit( e )
{
var num = Number( e.Data.questionNumber );
att = 'attempt_' + Number( e.Data.questionAttempts );
quizResults[ num ].questionNumber = Number( e.Data.questionNumber ) + 1;
quizResults[ num ].correctAnswer = e.Data.correctAnswer;
quizResults[ num ].attempt[ att ] = e.Data.selectedAnswer;
}

You initialize this array and objects in the moduleReadyEvent like so:

window.addEventListener( 'moduleReadyEvent', function ( e )
{
interfaceObj = e.Data;
eventEmitterObj = interfaceObj.getEventEmitter();
initializeEventListeners();

idx = cp.model.data.project_main.questions.split( ',' );
for ( var i = 0; i < idx.length; i++ )
{
var temp = { };

temp.questionNumber = 0;
temp.correctAnswer = 0;
temp.attempt = {
'attempt_1' : '',
'attempt_2' : ''
};

quizResults[ i ] = temp;
}
});

It can get quite complicated but the directions above can get you started with how to get and populate the information.

Below is how the info is sent to the sheet (Not that at the top of the file I create a case statement that checks the course name and populates a variable that has the correct API key, a seperate sheet is created for each course.)

The variables qa11 and qa12 and so on ar variable that get populated in a function called format results. They stand for question1 attempt 1 and question 1 attempt 2.

function sendResults()
{
var xhttp;

sheetURL = getKey( window.cpInfoProjectName );

console.log( 'Project Name = ' + window.cpInfoProjectName );
console.log( 'Acknowledge = ' + window.ACK );
console.log( 'Sheet Key = ' + sheetURL );
console.log( 'Quiz Results = ' + quizResults );
console.log( 'Correct Answers = ' + correctAnswers );

if ( window.XMLHttpRequest )
{
xhttp = new XMLHttpRequest();
}
else
{
xhttp = new ActiveXObject( 'Microsoft.XMLHTTP' );
}

a = window.cpInfoProjectName;
b = SCORM2004_GetStudentID();

var dt = new Date();
c = dt.toDateString() + ' ' + dt.toLocaleTimeString();

if ( window.cpQuizInfoPassFail.toString() === 'true' )
{
d = 'Pass';
}
else
{
d = 'Fail';
}

xhttp.open( 'GET', sheetURL + '?cn=' + a + '&lid=' + b + '&dt=' + c + '&att=' + quizAtt + '&pass=' + d + '&qa11=' + qa11 + '&qa12=' + qa12 + '&results=' + correctAnswers, true );

xhttp.send();

xhttp.onreadystatechange = function()
{
if ( xhttp.readyState === 4 && xhttp.status === 200 )
{
resetAttempts();
console.log(JSON.parse(xhttp.responseText));
}
};
}

In the Google sheet you then read in and parse the variable to populate the cells.