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, Paul. I've played around with that a bit and had success using the Google "Query Language"
https://developers.google.com/chart/interactive/docs/querylanguage#Setting_the_Query_from_JavaScript
What makes this tricky is that you'll need a unique way of identifying the person taking the course, assuming that there will be multiple rows in your spreadsheet. Otherwise, you might pull back a different person's data.
In this way, Google Sheets start functioning like a database in which you can set/get/edit/delete values.
Erich,
Thanks for this! Good material for my subway rides. My son, a mobile
developer, is also very excited to see how this works.
