Forum Discussion
exporting variables to be read in a Google docs spreadsheet
I've seen Tom's helpful screencast on how to embed a Google docs form into a Storyline project. However, what I want to do is a little different. I'd like to be able to export the values of about...
Sending data from Storyline using variables to a Google spreadsheet can be done...and quite effectively, too. I just finished a project doing this very thing.
First is setting up a Google Script. In Storyline you'll need to write a Javascript that will read all the variables and fire the data off. In our project we had over 50 questions each with 3 possible choices. We wanted to see the result (choice1, choice2, or chioce3) for each of the questions.
The neat thing is the Google Spreadsheet would update dynamically. We tested several outputs including a stand alone Storyline output on a web server, Storyline published as SCORM on an LMS, Storyline published for AO, and Storyline as a web object in a Studio '09 output in both SCORM and AO. Same project all sending data to the same spreadsheet while multiple users were accessing the various platforms and being able to literally watch the spreadsheet as it fills up.
Please can you share the demo? and the java script code that will read all the variables and fire the data off. I want to store the result (choice1, choice2, or chioce3) for each of the questions.. exactly what you made, So it'll be of a great help!
