ActivePresenter Saola Animate Pricing Download

Reporting quiz results on Google Sheets

Hi,

I would like to create a quiz which reporting is on a google sheet.
Following your instructions on https://atomisystems.com/elearning/send-quiz-report-google-sheets-email/
i made it and everything works fine but i would like to make some changes.
For example i would like to collect some informations such as name, surname, email, ecc. of the learner. I used the filli in blank tools, but then in the details on Google sheet, it does not appear.
What type of interaction do you suggest me for doing this? Anything else to do?

Thank you

Hi Stefano,

Please use the Text Box (Interactions -> TextBox) interaction to store that information. You should settings the reporting option of the text box like below:
image

In Google Script, please look up this interaction by its ReportID to get the data.

    // Fill details report information
    var reportDetails = report["Details"];
    headers = sheet.getRange("A20:I20").getValues();
    values = sheet.getRange("A20:I20").getValues();
    
	var userName;
    for (var row = 0; row < reportDetails.length; row++) {
      for (var i = 0; i < headers[0].length; i++) {
		// Find the username, email... data here
		var reportID = JSON.stringify(reportDetails[row]['ReportID']);
		if (reportID == 'UserName') {
			userName = JSON.stringify(reportDetails[row]['ReportID']);
		}
        values[0][i] = JSON.stringify(reportDetails[row][headers[0][i]]);
      }
      var nextRow = 21 + row;
      var range = "A" + nextRow.toString() + ":" + "I" + nextRow.toString();
      sheet.getRange(range).setValues(values);
    }

Regards,

Thank you very much.
I’ll try immediately.
Is it possible to use a button to assign a variable instead of Enter on the keyboard?

Stefano

Yes, you should use a button with Submit action:
image

Regards,

Thank you again!
Good to know.
Stefano

Hi.
Is it possible to send the results of the quiz to the google sheet without the last pop up? (that is, when the quiz is over, pressing the button, data is send to the sheet directly)

Thank you

Hi Stefano,

You can add the following script to Project Properties > Event tab to set a dummy user id to prevent the pop up:

$.cookie('userid', 'dummyId');

Regards

Thank you so much.
Tested and working

In der Beschreibung Tutorial


fragt das Programm vor der Sendung nach der Benutzer-ID, die dann an Google versendet wird.

In Reporting quiz results on Google Sheets
wird diese durch Script $.cookie(‘userid’, ‘dummyId’); unterdrückt. Es erfolgt die Übergabe des Text dummyid.

Wie kann im Verlauf der Präsentation die “Benutzer-ID” abgefragt werden und diese am Ende versendet wreden?

Hi Roland,

I’m not sure if I understand your question correctly.
If you want to collect the user id yourself (without poping up a dialog at the end of the quiz), you can use a text entry box as @namnt’s answer, and disable the user-id popup as in my answer above.

Regards

The code $.cookie(‘userid’, ‘dummyId’); unfortunately doesn’t work for me in Google Chrome (working on Mac). The popup gets blocked in Safari and Firefox and the report is successfully sent to my email-address. In Chrome it still appears and I get an error when sending the report.
(I exported the test to HTML5 and host the test on a Webpage.)

Any help would be highly appreciated!

Hi @lisette,

We can’t reproduce this issue in Google Chrome on Mac machines.
Please make sure that you open your HTML5 via http/https protocol, viewing directly from the local html file (via file protocol) will not work on some browsers.

Regards