user
@dean
Only One row of data in Google Sheets
Hi, I can successfully get data into Google sheet for the first use / row of an Articulate project but not for subsequent uses of the course .. what am I doing wrong?
reply
Reply
user
@support
Do you mean different people who access your course all write their data to the same row? Or you mean you want one user to be able to write multiple rows?
reply
Reply
user
@dean
I mean I am only receiving data in the row for the fist time I use the course and then no more new line after that. I have cleared cache to run course again but data is not entering the Google Sheet
reply
Reply
user
@support
So you need to analyze what's different when you revisit the project vs the first time.
Are you skipping over the slide (or master) that has the trigger that loads the widget?
Is there another (unrelated) JavaScript trigger that breaks everything else?
Are you resuming the course (vs restarting) and so the session inherits the original row number for this user?

You can always open the developer console and then refresh the page. As you go, see if there are any errors - it's usually some stray JavaScript that you either didn't know or forgot about that breaks things.

If you can't find anything, feel free to send us the story file via the Custom Development portal, we'll check as well. Note that we don't need your entire project, just those slides that deal with the sheets operations.
reply
Reply
user
@dean
No, query is somewhat simpler than this I Just want A New of Data each time THE course is undertaken So I get A line of Data for each User . at THE moment I get THE first and then THE Project no longer seems To collect Data
reply
Reply
user
@dean
Hi, I have sent you the Articulate project and would be grateful for any help
reply
Reply
user
@support
Maybe I misunderstood. If you clear the variable stencilsheetstoken (assign a blank value), the next call to Google Sheets will go to a new row in the spreadsheet. You can even do this within the same session, and certainly in new sessions as well - just add a trigger that clears the variable, that's it.
reply
Reply
user
@dean
thanks so much I think THE misunderstanding is probably mine but can you tell me exactly how I would do that last step
reply
Reply
user
@support
Tell you exactly how to assign a blank value to a variable? You create a new trigger, select Adjust Variable, select the variable name, select "to value blank." If you add this trigger to whatever slide the people first see when they reenter the course, they will be assigned a new row in the spreadsheet on re-entry.
reply
Reply
user
@dean
Do i set stencilsheetstoken to blank?
reply
Reply