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
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
June 18, 2021, 9:02 am
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.
June 18, 2021, 9:20 am
Not working for me...need your help
June 18, 2021, 9:24 am
Feel free to post a link to the .story file here, I'll take a look.
June 18, 2021, 9:52 am