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 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
Hi Yoni! Are you getting an error? I do not have any trouble with any of the links that Andrzej posted.
- Hi AndrzeiIt is exactly what i want to achieve but i am not a programmer is it possible to share the javascripts &/or steps with many thanks in advance for your kindness and assistanceRegards
Hi Sam! I'm not sure if Andrzej is subscribed to this thread, so you may need to send him a PM.
That is brilliant. Thanks Andrzej. I am not a programmer either and wondering if we can find similar sample scripts. I am not able to access the second link - goes to a blank page. Will check on a different browser.
Hi Sampath! I just checked the links and I am not having any difficulty.
Must be a browser issue as all I can see is a blue bar at the top and a blank page.
Sampath
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.
Thanks for popping back in to assist Andrzej
Sampath, did you ever get a browser to work? I'm not sure which one you were working in.
It's my pleasure.
Andrzej Rudnik said:
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.
Thanks a lot for your input -- i reached 90% already and shall test ajax command -- hope it works
for me.... Your assistance is appreciated and shall be always rememberedSam
