Please provide a brief description.
Please make a selection.
Please make a selection.
Please provide a description.
@stenciluser
Account
Account
Read data collected onto a Google sheet & fill it back into a Storyline file?
Is it possible to have a widget that allows you to read data collected onto a Google sheet & fill it back into a Storyline file?
Reply
Posted on 3/6/2022
@support
The quickest way to do this is to update the value of stencilsheetstoken and iterate through all records. Basically, whatever row number you have in stencilsheetstoken that's the row number that the SheetsGet() function will read from. I hope this helps.
Reply
Posted on 3/6/2022
@chetankataria1
Unable to read data from google sheet. could you please share the javascript code for storyline with a definer cell number?
Reply
Posted on 3/6/2022
@support
You access Sheets data by column name, not cell.
If the current user hasn't saved anything in the column you're checking, the response will be blank.
Replace column header with the column you wish to read.
Replace variable with the name of a Storyline variable that will receive the data.
If the current user hasn't saved anything in the column you're checking, the response will be blank.
Reply
Posted on 3/6/2022
@chetankataria1
Not working for me...need your help
Reply
Posted on 3/6/2022
@support
Feel free to post a link to the .story file here, I'll take a look.
Reply
Posted on 3/6/2022