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
If I remember correctly, you need to store the value of Results.ScorePoints in a custom variable, e.g. MyScore and then pass this variable into your JavaScript.
Thanks for the quick response... I'm going to give this a shot..
I'm fairly new to storyline and I've played around with this suggestion,
but I'm not sure how to store the value of one variable
(Results.ScorePoints) to another custom built Variable....
I'm only familar with how to have a user manually enter a value for a
variable.You could use a trigger like tis:
Thank you Aine!. Did you add something else to make it work on Google Chrome?
If anybody is able to make it work on an iPad please let me know.
no, but i can send you my code. i will be testing it on ipad1 next week if
thats any good to you, or you could test my wonky test version yourself,
and put in your real name as student name, and i will check the google
form, then you will know if your name appears that the code works on ipad, and you can then copy my
code.
here is link;
http://library.itsligo.ie/screens/ilo/ilo
thanks!, but please check that link you sent me because is not working, not even on PC
Aine,
I still get the same message when I try to open your link:
404 Not Found
The requested URL was not found on this server.
it was only putting in part of the url. Its not working for me now, in either ie or chrome, because I uploaded a new version today. im tearing my hair out. http://library.itsligo.ie/screens/ilo/ilo_output/story.html
uhh :(. Let me know if works for you again
i can zip the orig and dropbox it to you if you send me your e-mail address
Hello Aine,
Sorry for the late response. I don't think I got your email when you replied. .. What I did at the end was that I turned off the option to launch it with Articulate mobile player. That's how I got it to work. Now it exports the variables from the ipad without eny problem
Thanks to everyone in this thread - I've been asked to do this for a client and got it working eventually following those who have gone before me. Anyone wanting my 'steps' and script please direct message me and I'll happily share :) Great to say it tested on FF, Chrome, Safari, IE and mobile safari too.
Hello Nigel,
Great work. Are you using Articulate mobile player?
No, I use HTML5 and turn off the options for the mobile player (not a fan actually and prefer the web version). I understand it won't work with the mobile player anyway...
Thanks Nigel for offering to help others here and I'm glad you figured out a way to make it work!
Hi everyone. I got this to work, the problem I had was that I was actually trying to export quiz results, which from reading around appears to be a protected field in Articulate. Can anyone collaborate that. So I spent days trying to figure it out, and it turned out I was not doing anything wrong, it was just the field I was trying to export as a variable. There was a work around somewhere that I found online but that didn't work either.
Hi Everyone,
I'm having a heck of a time finding the X, Y, and Z information as indicated in the steps outlined below:
"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)"
I tried following the directions on the link (https://articulate-heroes.s3.amazonaws.com/uploads/attachment/attachment_url/4238/page.pdf?dl=true) that was shared but I can't find the form key or the y and z numbers.
Could anyone help? I'm hoping to get this working soon.
Thanks,
Mark
After quite a bit of fiddling around and a dash of close reading, I was able to get it to work. Thanks so much to all of the previous posters. I couldn't have done it (at all!) without your help.
