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

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.

Hi everyone, My solutions for this is here. Helpful link to do this solve in Storyline is here. You will find there solution to send date from html form to google spreadsheet. To implemnt this in Storyline you will need this link. I hope it's helpful.

oh noo :( I'm really sorry that I did not respond earlier but I had no access to the Internet - long duration holidays. I don't know if I can do it but I have saved this page for all of you to pdf. There is note who is author of this article. Function in Storyline can look like this (you can put it on Click event or timline starts): var player = GetPlayer(); $.ajax({ url: "https://docs.google.com/forms/d/XXXXXXXXXXXXXXXXXXX/formResponse", type: "POST", data: {"entry.yyyyy" :player.GetVar("your_verible1"), "entry.zzzzz":player.GetVar("your_verible2")}, success: function(data) { alert(data); } }); return false; XXXXXXXXXXXXXXXXXXX - must be replaced by the form key (for more details chceck pdf file) yyyyy, zzzzz - must be replaced by number from your's google form. You can find it with firebug (for more details chceck pdf file) your_verible1, your_verible1 - veribles from Storyline If you want to check how it is work you have to put content on server.

Here is my take on using GoogleDocs with Storyline variables: http://dev.keypointlearn.com/xcl71_SL/Soccer/story.html

I just posted, what I hope, is a step-by-step guide for making this work. I based it on the posts here and what I learned from them gathering them together. There were a few of us that needed steps from the beginning and others that needed them only part way through. Hope this helps anyone new to this particular forum. http://www.tracyparish.ca/2015/08/how-to-send-variables-from-storyline-to-google-docs.html

exporting variables to be read in a Google docs spreadsheet

MattLynch
Community Member
9 years ago
I am having trouble finding the entry code for each input section.

When I inspect the google forms code I get this...

<input type="text" class="quantumWizTextinputPaperinputInput exportInput" jsname="YPqjbf" autocomplete="off" tabindex="0" aria-label="Full Name" aria-describedby="i.desc.2101111227 i.err.2101111227" name="Sydney Collective Fire Training User data" value="" required="" dir="auto" data-initial-dir="auto" data-initial-value="">

There doesn't seem to have the entry code in there at all.

Any ideas? Has google changed the code for forms?
SteveFlowers
Community Member
9 years ago
Hi, Matt -

On your form, while editing, try to generate a pre-filled link:

It will provide you with a URL like this:

https://docs.google.com/a/forms/d/18rlUiMXHUfebyWeOKJSXGeGJHNnrLW6iFF_v2Xdg9Iw/viewform?entry.1813808438=Option+1&entry.1973654167=Option+1&entry.1879837238=Option+1
MattLynch
Community Member
9 years ago
I seem to get the link with just

*****/forms/d/1i5jMBrIJq-vDE9svSB1datDrDfvKvKjb245T5H2-uVA/prefill

Not sure why I don't get the entry. Do you have part of it selected before getting the pre-filled link?
SteveFlowers
Community Member
9 years ago
Yes. You need to fill each pre-fill element that you want to return in the string.
SteveFlowers
Community Member
9 years ago
Fill and submit the pre-fill form. It should show you a link to copy.
MattLynch
Community Member
9 years ago
I edit the form and pre-fill the responses, but the link is still the same. I cannot get the entry and option to appear after the link. all I get is /prefill after it.

I must be doing something wrong
JasonNagels
Community Member
9 years ago
Hi All -

I'm not sure how many people monitor this post anymore, but I thought I would give it a shot.

I had this working a few years ago, and unfortunatly I had my hard drive fail and lost my source files that worked. Now I'm trying to recreate the ability to post to a google form with not a lot of success.

I have created a test training:http://nagelsconsulting.com/Lockout/story.html
The idea is to have the firstname, lastname and score output to the google form.

I can see now that after completing the course the timestamp is entered, but none of the values are passing to the google form. Here is my spreadsheet results:
https://docs.google.com/spreadsheets/d/1MTo41Vb8Vkfd6jaCPRzkdGg0LSHLUxk7GtRvBBrhvso/edit#gid=361735704

The javascript I have entered is as follows:

var player = GetPlayer();
$.ajax({
url: "https://docs.google.com/forms/d/1eshntCAnj-xod2Ql-R2VBUx0lnMCQ-wrd_y9DfaMZok/formResponse",
type: "POST",
dataType: "jsonp",
data: {"entry.1307427408":player.GetVar("FirstName"), "entry.1400570972":player.GetVar("LastName"), "entry.1439160339":player.GetVar("Score")},
success: function (data) {
alert(data);
}
});
return false;

----

I have also made sure to edit the published story.html with the following code:

<script
src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.1/jquery.min.js"></script>

any help that can be provided would be very much appreciated!

just in case anyone wants to take a look at the source file, I have attached the storyline test file.
Lockout.story313 KB
AshleyT-Pollard
Staff
9 years ago
Thanks Jason - it's always good to have more and newer examples so I appreciate you sharing.
LeslieMcKerchie
Staff
8 years ago
Hey John - This thread is a bit dated and if you do not hear back from Kevin soon, you are welcome to reach out to him directly via the 'Contact Me' option on his user profile.
BENOITGUILLO
Community Member
8 years ago
Hello, thank you for your work and generosity Michael and Andrzej. Your tips, tricks and codes are so usefull !