Please provide a brief description.
Please make a selection.
Please make a selection.
Please provide a description.
@santiagoaguilar
Account
Account
Problems connecting 2 google sheets.
I connected to google sheets to one storyline, but when i change the clabsSheetsWidgetID to the second sheet the storyline keeps writing the information in the first one. How can i fix that? Basically i need to obtain the information of the first google sheet and then write new information in the second one.
Reply
Posted on 8/1/2024
@support
Hello. Sorry for giving you wrong information in the previous thread. Use this trigger in Storyline to switch to a different sheet (make sure to replace the ID in quotes with your widget ID):
window.clabsSheetsWidgetID = 'MTA4M3w0MDE5fDQxNT';
let player = GetPlayer();
player.SetVar('stencilsheetstoken','');
I tested this with the starter file and it worked.
window.clabsSheetsWidgetID = 'MTA4M3w0MDE5fDQxNT';
let player = GetPlayer();
player.SetVar('stencilsheetstoken','');
I tested this with the starter file and it worked.
Reply
Posted on 8/1/2024
@santiagoaguilar
So, i need to activate in the master slide both of the javascript codes and change de Id whenever i want with that code?
Reply
Posted on 8/2/2024
@support
No, you need only one initiation trigger on the Master. And to switch to a different sheet, you need to execute the JavaScript trigger provided in the previous message.
Reply
Posted on 8/2/2024
@santiagoaguilar
Thanks, that worked for me too!
Reply
Posted on 8/2/2024
@support
Great, don't hesitate to reach out if any other questions come up.
Reply
Posted on 8/2/2024