exporting variables to be read in a Google docs spreadsheet

Dec 06, 2012

Dorothy Stark
By Dorothy Stark

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 a dozen variables from Storyline so I could see them in a spreadsheet the way I would if students entered those values into a Google docs form.

I've got a grammar assessment, and I want to export a student's name and either OK/NEED TO REVIEW/MIGHT WANT TO REVIEW for each of a dozen or so topics. Now, I could just use a final page screen in Storyline showing a student her status on these dozen topics and ask her to fill out an embedded Google docs form in which she basically copies the results manually. These are just initial assessment scores, and I'm not worried about honesty issues. However, this seems like a pretty klutzy way to do things. Would anyone be able to help me out with a suggestion for a better method? I don't know any JavaScript, and my familiarity with Storyline is fairly low.

Thanks!

Dorothy

142 Replies
Media Innowijs
almost 6 years ago05/03/18 at 11:33 am (UTC)

Hi Tracy,

I've followed your instructions step by step. But somehow it won't work with me.
For this story module I used Storyline 360 and Google Chrome as browser.

Could you please help me with this? I've attached the storyline file and a screenshot of how the js is triggered.

Virak Yang
almost 4 years ago05/18/20 at 10:02 am (UTC)

Hi Everyone, Just a quick update based on Tracy Trish instruction via this blog post:

http://www.tracyparish.ca/2015/08/how-to-send-variables-from-storyline-to-google-docs.html

The latest script version to include in the story.html is:

<script src=“// http://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js”></script>

Tracy Parish
almost 4 years ago06/18/20 at 12:08 pm (UTC)
Keng Hwee Wee

I am totally new to html. Can you tell me how to include the latest script version in he story.html?

Thanks

I've been using this method now without fail.  Just this past fall used it.  I can't remember all the details of my own post that is linked above, but Matthew's method works.  Let me know if you have trouble.

https://www.youtube.com/watch?v=5V2pvtFGeyY 

Sherri Sagers
almost 3 years ago06/25/21 at 8:31 pm (UTC)

I got it to work! Here's the first JavaScript that needs to be executed at the beginning of the Storyline file:

var head = document.getElementsByTagName("head")[0];
var script = document.createElement('script');
script.src = 'https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js';
script.type = 'text/javascript';
head.appendChild(script);
Sign In to Reply