Forum Discussion
Hi Martin,
Great to hear it worked.
The problem was caused by the order of the triggers. See screenshot below:
You will have to move the selected trigger one position up. So you will first set the variable and then go to the next page.
Normally we place this trigger on the "Success" and "Fail" layer. And then with the setting "When Time-line starts".
Best regards,
Bastiaan
Hi Bastiaan,
Thanks again! You really helped get my project back on course - I'll remember about the order of things in the triggers. Sometimes I forget that the order in the list makes a big difference. I'll be sure to remember that from now on.
All the best!
-Martin
- BastiaanTimmer9 years agoPartner
Thanks Martin, You're welcome!
- MartinLemieux9 years agoCommunity Member
Hi Bastiaan,
I've got one more question - I'm not sure if I'm searching for the right thing in the forums, so I haven't really seen this specific challenge come up yet.
I've got a single spreadsheet in google drive with multiple sub-sheets within it (1 for each course).
Is there a way to have the variables export to a particular sub-sheet?
The URL key used in the steps for the variable export does not change, no matter which sub-sheet you are in. All that changes is an ID number that is appended to the end of it.
There is only a single script editor page for the entire sheet, not separate ones for each sub-sheet.
So, I'm wondering what would have to change in the google sheet's script editor or in the javascript in Articulate that would point the data to that sub-sheet? How are multiple sub-sheets handled when there is only a single script editor for the entire sheet?
Any and all help would be welcome!
Thanks!
-Martin