Forum Discussion
Exporting Variables into a Google Spreadsheet
Having read this post on how to export variables to be read in a google spreadsheet, I set about trying to get this working in my project, I soon ran into problems, I just could not get it to work a...
HI Kate,
I followed all the steps you mentioned but still not working. I have uploaded the published file on the server but still no response. I think there is something wrong I am doing that's why the data is not appearing in Google sheet. Kindly find the files attached.
Google drive link: https://docs.google.com/spreadsheets/d/1L1YtRjp0Kd94XQx-1AjH8cEh-sctGmRPL7VXCRCzdNk/edit?usp=sharing
Published version uploaded: http://blendtolearn.com/articulate/exportgooglesheet/story.html
I look forward to hearing from you.
Hi Mohammad, I have sent you a reply via email but for anyone else, here are the changes I made:
1. You need to call the spreadsheet ‘DATA’ – the name at the bottom, not at the top
2. You need to put column headers in that match the variable names
3. I edited the variable names in your articulate project
4. I edited the javascript to match the variables and took out the ones you didn’t need.
5. I added in a second javascript that stops you needing to do any post-publish surgery
Thanks for this, too, Kate. I haven't been successful at this yet and hope implementing these changes will work for me.
Thanks Kate. you are the best.
