Forum Discussion
Articulate Storyline: Export to Google Drive
PREVIEW | SOURCE
On the Articulate user days in Utrecht (2015), we held a session about exporting Articulate Storyline variables to Google Drive (Spreadsheet). This export is achieved via...
Hi there.
I can't get this to work. A couple of years ago it was working, but I've followed the steps exactly and it's no longer working. I've tried with both my own spreadsheet and the template and also tried the above suggestion about putting the JavaScript triggers on a separate slide after the variables have been set. Any ideas? Have Google changed something that means it no longer works?
Hi. Not sure if it helps, but make sure to select "setup" before clicking Run in Apps Script. Last time I messed up at this step.
Hi. Yes that was done correctly. I've just done all the steps again, and it's still not working. Nothing is being published to the spreadsheet.
I've attached my test Storyline file I'm trying it on, and here's the link to the spreadsheet: https://docs.google.com/spreadsheets/d/1mNF6jhNByamBKG1pcdIqeTNzY4iOdiOgBhs8pXJC6VA/edit#gid=0
Fixed it for you.
Here you can test it...
https://360.articulate.com/review/content/0193b4a4-afd6-40a0-bb55-3d38d210e687/review
Basically what was wrong with your NewTest is that the jQuery library never got loaded. I am no programmer either, but if you want this kind of thing working you need to learn something about HTML and how things work. You donot need to be a programmer...im neither, but you do need to know how to test and debug your projects so you can figure out whats wrong... and solve it. Or hire someone who knows.
To load external stuff you can either rely on some CDN or online setup or use WebObjects to load it into Storyline. I prefer WebObjects, because when setup properly it always works. Independent of changing URLS or downtime of servers.
In the zip added is the Storyline fixed and ready and a folder the WebObject points too. If you want to use this in another Storyline you need to copy the scene 2 'Javascript Libraries' to your project... and get the first 2 triggers on the startSlide. Also you need to be aware of the way WebObjects work. When publishing the first time ( as Web ) you need to open up your local folder and go into the WebObjects folder to get the name/number of it...
As seen here...Copying the name of that folder... then you go to the first Javascript where the libraries will be loaded... and change the number in that script to match that folder. As seen here...
Adding a zip with both the Storyline and the folder...
Excellent. Thank you very much for that!
