user
@jcarpenter1986
I'm struggling to get Storyline to record data in sheets
Hi guys! I'm struggling to get Storyline to record data to my sheets. I've followed the steps in the tutorial, and at first, data was going through, but upon publishing again the data is no longer being collected. Is there any way you guys can help me out? I'll attach the javascript text file and an HTML version of the storyline course.

[URL]
reply
Reply
user
@support
Hello. Of course. Please send a link to your story file and we'll take a look.
reply
Reply
user
@jcarpenter1986
Thank you! here's the link to the storyline course,

[LINK]

there's a number of your javascripts on here, but the one that I'm looking at right now is the google sheets version. The 3rd slide on is where the google sheets script starts
reply
Reply
user
@support
This link is asking to request access. Please either make it public or share with app@cluelabs.com.
reply
Reply
user
@jcarpenter1986
Sorry about that! its fixed now
reply
Reply
user
@support
Ok, multiple issues:

1. On the Thank You slide in scene 8 there was a trigger with the text "Send the data to the Google Apps Script Web App..." - that's not ours and it contained a typo which broke all javascript in the project. So even if everything else was fine, javascript still wouldn't work because of this.

2. The javascript trigger on slide 3 that was sending the data was set to "when timeline ends" with the timeline being only 5 seconds long. So your issue was that you weren't typing fast enough to have any data to send at the 5 second mark. I added a button and linked the trigger to that button instead to demonstrate that the trigger works when used properly.

3. Each data point was saving to a new row because the project was missing a variable stencilsheetstoken. When you save your widget, you can see the complete list of triggers and explanations of how to set up the widget. I added this variable, it's fine now.

4. There are two Sheets initialization triggers on the master. While the second one doesn't break anything, it may cause confusion later if you try to update the triggers. So I deleted the second one.

Here's your update file: https://www.dropbox.com/s/5tbjjgn5qrodu4k/African%20Climate%20Change.story?dl=0
reply
Reply
user
@jcarpenter1986
oh my gosh, thank you so much for helping me! I never would have guessed that there was a javascript breaking everything else in the project. I should be able to handle things from here. You guys are so helpful, thank you so much!
reply
Reply