Please provide a brief description.
Please make a selection.
Please make a selection.
Please provide a description.
@isharas
Account
Account
My Sheets widget is connecting but not storing the data on the Google Sheet.
I have an interaction created in Articulate Storyline 360 that outputs multiple variables to the Sheets widget. I have set up the widget properly, following all the guidelines, and confirmed the sheet as well.
Here is the JavaScript code I am using to output my data to the Sheets widget:
var player = GetPlayer();
SheetsSet('Date', player.GetVar('UserLocalDateTime'));
SheetsSet('User ID', player.GetVar('UserID'));
SheetsSet('Slot 1 - Question', player.GetVar('Slot1Q'));
SheetsSet('Slot 1 - Correct', player.GetVar('Slot1A'));
SheetsSet('Slot 2 - Question', player.GetVar('Slot2Q'));
SheetsSet('Slot 2 - Correct', player.GetVar('Slot2A'));
SheetsSet('Slot 3 - Question', player.GetVar('Slot3Q'));
SheetsSet('Slot 3 - Correct', player.GetVar('Slot3A'));
SheetsSet('Slot 4 - Question', player.GetVar('Slot4Q'));
SheetsSet('Slot 4 - Correct', player.GetVar('Slot4A'));
SheetsSet('Slot 5 - Question', player.GetVar('Slot5Q'));
SheetsSet('Slot 5 - Correct', player.GetVar('Slot5A'));
SheetsSet('Bonus Points', player.GetVar('BonusPoints'));
SheetsSet('Total Points', player.GetVar('TotalScore'));
I can see from the Usage Statistics for the widget that it is connecting each time I run the SCORM, and it shows more and more transfers. However, the Google Sheet remains empty.
What could be the problem here? I appreciate any help!
Here is the JavaScript code I am using to output my data to the Sheets widget:
var player = GetPlayer();
SheetsSet('Date', player.GetVar('UserLocalDateTime'));
SheetsSet('User ID', player.GetVar('UserID'));
SheetsSet('Slot 1 - Question', player.GetVar('Slot1Q'));
SheetsSet('Slot 1 - Correct', player.GetVar('Slot1A'));
SheetsSet('Slot 2 - Question', player.GetVar('Slot2Q'));
SheetsSet('Slot 2 - Correct', player.GetVar('Slot2A'));
SheetsSet('Slot 3 - Question', player.GetVar('Slot3Q'));
SheetsSet('Slot 3 - Correct', player.GetVar('Slot3A'));
SheetsSet('Slot 4 - Question', player.GetVar('Slot4Q'));
SheetsSet('Slot 4 - Correct', player.GetVar('Slot4A'));
SheetsSet('Slot 5 - Question', player.GetVar('Slot5Q'));
SheetsSet('Slot 5 - Correct', player.GetVar('Slot5A'));
SheetsSet('Bonus Points', player.GetVar('BonusPoints'));
SheetsSet('Total Points', player.GetVar('TotalScore'));
I can see from the Usage Statistics for the widget that it is connecting each time I run the SCORM, and it shows more and more transfers. However, the Google Sheet remains empty.
What could be the problem here? I appreciate any help!
Reply
Posted on 7/23/2024
@demo
Hi. Please post a link to your .story file, we'll check what's happening. Thank you!
Reply
Posted on 7/23/2024
@isharas
Thank you for your support!
Link >>> [URL]
Link >>> [URL]
Reply
Posted on 7/23/2024
@support
Looks like the data was there, you just couldn't see it because it was below the fold and you needed to scroll to get to it. The widget always takes the first available empty row at the bottom of the document. Maybe you had some text or even a space character somewhere in a cell down in the document, so all new data would go below that line. I deleted the empty lines at the top, so your data is at the top of the document now. Everything should work well.
I also reset your usage count.
There's one issue that you need to consider. Google makes its Sheets API very slow by the Internet standards with every transaction taking a few seconds. So even if it takes only 2 seconds per transaction, 14 of them will need 28 seconds to complete. Are your users staying in the course for at least 28 seconds after you execute that trigger? If the answer is yes, then you're good to go.
If the answer is no, however, they will exit before all data is sent. There are two possible solutions:
- Instead of using one trigger to send all data, have individual triggers on each slide that can update the document right away.
OR
- Use Data Cloud instead of Sheets. It works exactly the same, but is significantly faster than Sheets.
I also reset your usage count.
There's one issue that you need to consider. Google makes its Sheets API very slow by the Internet standards with every transaction taking a few seconds. So even if it takes only 2 seconds per transaction, 14 of them will need 28 seconds to complete. Are your users staying in the course for at least 28 seconds after you execute that trigger? If the answer is yes, then you're good to go.
If the answer is no, however, they will exit before all data is sent. There are two possible solutions:
- Instead of using one trigger to send all data, have individual triggers on each slide that can update the document right away.
OR
- Use Data Cloud instead of Sheets. It works exactly the same, but is significantly faster than Sheets.
Reply
Posted on 7/23/2024
@support
Here's your file from yesterday, but with Data Cloud instead of Sheets: https://www.dropbox.com/scl/fi/v3x8zvh3mndxq81mvaowo/Gamification-Test.story?rlkey=2sjgiu2hzum5ks2t0e3ypr3da&dl=0
If you need to create a URL to see the data in the spreadsheet without logging in, use the New Sharing Link button in the Sharing tab:
If you need to create a URL to see the data in the spreadsheet without logging in, use the New Sharing Link button in the Sharing tab:
Reply
Posted on 7/24/2024