Forum Discussion
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
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