Dean, what is your question?

Hi John,

I am struggling to get it all working ... if I sent my file could you add one or two variables to it so they add to my Google sheets?

We can try. Feel free to post a link to your file in the response below.

Can I share privately?

Are you there?
Here's my file .... can you set up Postcode to be collected to sheets as an example?

You should post just one slide you're having an issue with. I really have no need to see your entire project.

Here is a short version .. can you help as soon as possible .. I have been trying for weeks to get it working.

https://we.tl/t-fe5bxZ2XBF

Dean, what is it that you're trying to do? Save the post code to Google Sheets?

Yes, I have many other questions to capture but If you can help me with one I can get the others going

I can share my sheet also if you need?

Thanks so much for the help...

Would you like to share an email address so I can share the sheet I have set up?

Ok, you need to add the following trigger to execute when the variable Postcode changes:

var player = GetPlayer();

SheetsSet('Postcode',player.GetVar('Postcode'));

I have added that on screen 1.2 ... did I do it correctly?

I can see data in the sheet :)

Oh, I see your trigger now, on the Next button, correct? Yes, it looks good. I would just double-check the order of the triggers. Currently, jump to next slide is placed before the SheetsSet trigger. The latter will never execute because you're leaving the slide before it gets to that trigger.

What would be the best trigger?

The way you have them is fine, just change the order so that jump to next slide occurs after the other two.

OK ... let me test

THis may be a silly question but do I need to host the file or will they work if I leave them local?

That would probably depend on your network, firewall, organizational policy, etc. For me, it worked from the computer locally.

So it worked without any change to the file I sent?

There was one change - reorder the triggers as described in the earlier messages.

Could you send the file back to me?

Got it working! Hey can you capture Likert scale responses with this method?

Here's the file: https://www.dropbox.com/s/qkjlf72srqg16ek/MIA%20Learning%20Module%204%20-%20V6%20-%20GoogleSheets%20Sample%20-%20SL2%20Backup.story?dl=0

If you can attach the triggers to the individual responses, then you can. Or maybe consider building your own likert scale instead of using Storyline's default one.

Thanks!!

Hi John, Can you help with another issue?