Exporting Variables into a Google Spreadsheet

You could use other sheets. Depending on the scope and access needs, the way I'd handle that is by adding a field to capture the course ID or title and use a filter to change the report display.

Google Apps Scripts are pretty fantastic. You can even automatically send formatted emails based on a variety of variables. 

This is extracted from a function that gathers info from a sheet and sends emails to program owners for a departure clearance process. There is a limit to the number of emails that can be sent from each account per day. For a corporate or government account it's something like 1500.

if (emailSent =="" && emailAddress!="") { // Prevents sending duplicates
 var subject = "[Exit Clearance] "+SystemName;
 var messageBody="PLEASE DO NOT REPLY TO THIS MESSAGE.<br/><br/>"+MemberName+" ("+MemberOffice+") will be departing the agency after "+DepartureDate+".<br/><br/>You have been listed as program contact for <b>"+SystemName+"</b>. Please process the exit for the member listed above as necessary and click the link below to confirm. <br/><br/><a href='https://docs.google.com/a/nara.gov/forms/d/FORMID/formResponse?entry.2015203526="+uid+"&entry.2111276816="+SystemName+"&entry.2115168075="+MemberName+"&entry.439662642="+MemberOffice+"'>Confirm receipt and action.</a><br/><br/>Clicking the link confirms receipt and indicates that the system or program owner will process the required action on or after the date of departure. A reminder will be sent after the scheduled departure date.";MailApp.sendEmail(emailAddress, subject,'',{htmlBody: messageBody}); 
 sheet.getRange(startRow + i, 3).setValue(EMAIL_SENT);
 // Make sure the cell is updated right away in case the script is interrupted
 SpreadsheetApp.flush();
 }

Hi Laura - 

The Jquery needs to be loaded ahead of the script fire. There is some time-lag between the creation of the object and the actual load and initialization of the library. So if you try to call something immediately, it'll probably fail. I usually try to load it on the base layer then call another layer on a delay to execute. This provides 3 to 5 seconds of lead time which seems to be enough to consistently get the library in.

If you were on a dial-up connection, this could be close.

Hey, all -

(1/2) I've stopped using the script method awhile ago. The less complicated way to tackle this uses a Google Form paired with a Google Spreadsheet. 

1. Create a Google Form. Pair it with a Spreadsheet. 
2. Use the prefilled form option in Google Forms to grab your name/value pair variable names. You'll get something that looks like this. I add the names I want to reference into the fields before submitting.
   https://docs.google.com/forms/d/e/1FAIpQLSeL2Z8hvyxK_EipeC7Fc8NDncE3VtVsMMsQZIOkCfkOPSLKgQ/viewform?entry.1518353193=NAMEFIELD&entry.1403774106=COLORFIELD&entry.1433875917=NUMBERFIELD
3. You'll set your AJAX function to target the form response address. It's the same address as your form except it ends with formResponse instead of viewForm. https://docs.google.com/forms/d/e/1FAIpQLSeL2Z8hvyxK_EipeC7Fc8NDncE3VtVsMMsQZIOkCfkOPSLKgQ/formResponse

Hi Kate..this is so awesome. Once it is in place, though, how will it be used? What are you doing with the Google Sheet containing these data?

Hi Bonnie, in my course I ask my learners to rate their understanding against 4 statements before and after the course. The ratings are variables that get exported to a google spreadsheet so I can analyse the data and how learners feel they have developed over the course. Hope that makes sense!

Thanks! I was very pleased when I got it to work because it is going to be very useful. 

Thanks for that - I get asked for this all the time. Kate I loved your step by step instructions. Steve I loved your idea of using a javascript trigger instead of having to put something in the published folder and being able to put variables into a google form would be awesome - but I think I would need a few more step by step instructions to be able to make it work.  Do you think you could explain how to do it, for say, the variable scorepercent and a variable for name?  I do get asked for this all the time.

Thank's Steve - I will try your javascript to automatically add the jquery line into my files.

Great example, thanks Erich!

Jacinta - you need to set up a spreadsheet where the columns are 'scorepercent' and 'name', follw the instructions above to add code to the google spreadsheet, then in the javascript you add to the articulate trigger you would put (just make sure the column titles and the variables are spelt exactly the same and in the same case):

var player = GetPlayer();

$.ajax({

url:
"Current web app URL",

type: "POST",

data: {"name": player.GetVar("name")
, "scorepercent": player.GetVar("scorepercent")},

success: function(data)

{

alert(data);

},

error: function(err) {
console.log(err);
}

});

return false;

Hope that helps!

Has anyone done this with Chrome lately? The method works beautifully in Firefox, but if you try it in Chrome, it blocks the javascript elements loading on the page by default (you'll get an alert in the browser bar, with the option to load the scripts. Without doing this, none of the scripts will run).

Any way to get around this? It'd be nice and easy if we could limit everyone to one browser, but that won't happen.

Thanks so much Kate. This is so good and worked first time!