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?

May 5, 2021, 7:50 am

Click for thumbs down.0Click for thumbs up.0#1

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.

May 5, 2021, 7:56 am

Click for thumbs down.0Click for thumbs up.0#2

Unable to read data from google sheet. could you please share the javascript code for storyline with a definer cell number?

June 18, 2021, 9:02 am

Click for thumbs down.0Click for thumbs up.0#3

You access Sheets data by column name, not cell.

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.

June 18, 2021, 9:20 am

Click for thumbs down.0Click for thumbs up.0#4

Not working for me...need your help

June 18, 2021, 9:24 am

Click for thumbs down.0Click for thumbs up.0#5

Feel free to post a link to the .story file here, I'll take a look.

June 18, 2021, 9:52 am

Click for thumbs down.0Click for thumbs up.0#6