On retake of assessment override the user responses of each questions in same row of google sheet not to create new row with data.
I am new to using ClueLabs and am recording storyline assessment data for the first time. I'm encountering an issue with properly displaying the data in Google Sheets columns. Specifically, I want to ensure that each question's data is overridden in the Google Sheet when a user retakes the assessment. Below are the variables we use to track the storyline data and send it to Google Sheets:
SheetsSet('Category of Questions ', 'Category 01'); SheetsSet('Questions Descriptions', 'Questions text'); SheetsSet('Response', 'correct'); SheetsSet('Score', IndividualScore); SheetsSet('Total score of Assessment', totalScore);
We have 12 questions in our assessment and each questions of assessment has five parameter want to record the data in google sheet like that
But Questions Descriptions , response leaving one blank row in google sheet. Is there any logic or code please provide us not create new row on retake of Assessment it jus override the questions, and its parameter in google sheet.
Reply
Posted on 9/4/2024
Please type your reply.
@support
Hello. You are seeing one entry per line because you are missing the variable stencilsheetstoken in your project. Once you create this variable (leave it blank), all of the user's responses will be saved to the same line and overwritten on retry.
Reply
Posted on 9/4/2024
@jitenderverma
Hi,
Thanks for your quick reply. It’s working.
We have 14-15 questions in our assessment, but the data capture in Google Slides is very slow. We have to refresh the browser repeatedly to display the data in the sheet.
We've also observed that if we close the Storyline-published file in the browser, the data is no longer recorded in the sheet, even if we've completed all the questions. It only records part of the quiz data.
Please suggest
Regards, Bipin
Reply
Posted on 9/6/2024
@support
Yes, Google Sheets API is very slow, there's nothing that you can do about it. As a solution, I would recommend saving data incrementally as each question is answered instead of waiting until the end to save everything at once.
Another option is to use the Data Cloud widget instead of Sheets. It works exactly the same, but saves data to an online table instead of Google Sheets, and is much faster.