Not sure about Excel, but you could do it using Google Docs. See here for more info and also read this thread as well (as there were a couple of small errors in the original code which will need to be corrected.)
Yeah, that's correct, it will add a new line to the spreadsheet each time the JavaScript runs. I know it looks complex, but it's pretty easy to set up. Feel free to reach out if you get stuck.
Hi Mark! Glad that Matthew was able to pop in and assist you here. This is not something that Articulate can support, but we have some very helpful community members :)
Yes Mark, absolutely. There is no need to use the results screen at all when implementing this.
You will need to alter part of the code used by the second trigger to have it work with your variables.
In the example shared, Steve is capturing the value of Slider1 (a Storyline variable) and TextEntry (another Storyline variable).
var vRate=player.GetVar("Slider1"); var vSuggestion=player.GetVar("TextEntry");
These two variables (Slider1 and TextEntry) need to exist in Storyline for this to work.
If I was you, I'd build a sample using the example shared as that will give you a bit of an idea how it works.
Then you'll need to rewrite the below code for each of the variables you want to capture and add it to the appropriate place in the second trigger, so for example:
var name=player.GetVar("StudentName");
Would take the value of StudentName (a Storyline variable) and pass it to a JavaScript variable called 'name'.
This is used to copy the value of the JavaScript variable to the appropriate column in the spreadsheet. The document that Steve wrote (linked in my first post above) shows how to find the correct 'entry.#########' for each column.
So if we go back to our StudentName example, you'd need something like this:
data: {"entry.123456789":name},
Hopefully this is making a bit of sense and I haven't confused you too much! Let me know if you get stuck.
It's starting to make sense. I'm trying to get a short one up and running to see if I can get it to work. The logic makes sense, just need to get the steps right. Thank you!!!
I can't use google forms due to security reasons. Is there any code to save the storyline 360 variables in excel sheet which sits on Sharepoint or locally? Please let me know if there are any ideas on this.
Hi Matt, Its been 3 years since this post was created, is it still the same requirements? I am just trying to export students names which they have to enter into a text field, and put them into a google sheet. I haven't managed to get it to work yet so searching all the forums to see whats out there. Thanks
I know this is an older topic, but does anyone know if there is a functional solution using excel and Sharepoint vs. Google Sheet. Has anyone altered that google script to work with Excel. Thanks.
You won't be able to get this Google script working with Excel, as Excel doesn't work in the same way. But in short, yes, it would be possible to get this data into Excel somehow.
For example, you could use this Google Sheets approach, then hook up Zapier and use an Add new Google Sheets rows to Excel trigger to move the data across.
To be clear, I'm not recommending you do this - it's just a possible solution I can summarise in one sentence! It's silly to use both G Sheets and Excel in this way. And if you have lots of data, Zapier will get expensive, but it would work.
If you can give me some more detail on what you are trying to achiecve, I can likely suggest a better solution.
17 Replies
Hi Mark,
Not sure about Excel, but you could do it using Google Docs. See here for more info and also read this thread as well (as there were a couple of small errors in the original code which will need to be corrected.)
Hope that helps!
Ok, I'm reading that. Not sure if it's too advanced for me, but I think I get it. Will give it a shot. Thank you!!!
So, for multiple learners, will it create a new google form for each? or organize the data for all the users within one google form?
Yeah, that's correct, it will add a new line to the spreadsheet each time the JavaScript runs. I know it looks complex, but it's pretty easy to set up. Feel free to reach out if you get stuck.
Hi Mark! Glad that Matthew was able to pop in and assist you here. This is not something that Articulate can support, but we have some very helpful community members :)
Yes, people here are awesome! Matthew, can I forward any variable from the module to the google forms or only one's that end up in the results screen?
Yes Mark, absolutely. There is no need to use the results screen at all when implementing this.
You will need to alter part of the code used by the second trigger to have it work with your variables.
In the example shared, Steve is capturing the value of Slider1 (a Storyline variable) and TextEntry (another Storyline variable).
These two variables (Slider1 and TextEntry) need to exist in Storyline for this to work.
If I was you, I'd build a sample using the example shared as that will give you a bit of an idea how it works.
Then you'll need to rewrite the below code for each of the variables you want to capture and add it to the appropriate place in the second trigger, so for example:
var name=player.GetVar("StudentName");Would take the value of StudentName (a Storyline variable) and pass it to a JavaScript variable called 'name'.
Then you'll need to change this section:
data: {"entry.156531987" :vRate,"entry.1547132205":vSuggestion},This is used to copy the value of the JavaScript variable to the appropriate column in the spreadsheet. The document that Steve wrote (linked in my first post above) shows how to find the correct
'entry.#########'for each column.So if we go back to our StudentName example, you'd need something like this:
data: {"entry.123456789":name},Hopefully this is making a bit of sense and I haven't confused you too much! Let me know if you get stuck.
Glad you are liking the community Mark and looks like you are continuing to get the assistance that you need.
It's starting to make sense. I'm trying to get a short one up and running to see if I can get it to work. The logic makes sense, just need to get the steps right. Thank you!!!
Sound great Mark.
Hi,
I can't use google forms due to security reasons. Is there any code to save the storyline 360 variables in excel sheet which sits on Sharepoint or locally? Please let me know if there are any ideas on this.
Thanks!
Hi Matt, Its been 3 years since this post was created, is it still the same requirements? I am just trying to export students names which they have to enter into a text field, and put them into a google sheet. I haven't managed to get it to work yet so searching all the forums to see whats out there. Thanks
Hi Lesley,
Yes, I believe this approach still works the same... although it has been a while since I've used it. Yell out if you run into any issues.
Looking for some more help on this too please
I know this is an older topic, but does anyone know if there is a functional solution using excel and Sharepoint vs. Google Sheet. Has anyone altered that google script to work with Excel. Thanks.
You won't be able to get this Google script working with Excel, as Excel doesn't work in the same way. But in short, yes, it would be possible to get this data into Excel somehow.
For example, you could use this Google Sheets approach, then hook up Zapier and use an Add new Google Sheets rows to Excel trigger to move the data across.
To be clear, I'm not recommending you do this - it's just a possible solution I can summarise in one sentence! It's silly to use both G Sheets and Excel in this way. And if you have lots of data, Zapier will get expensive, but it would work.
If you can give me some more detail on what you are trying to achiecve, I can likely suggest a better solution.
Iam looking for support for exporting storyline variables to excel or google spreadsheet. Any other help is appreciated.