Forum Discussion
KateRobertson
10 years agoCommunity Member
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...
SteveFlowers
9 years agoCommunity Member
Hey, all -
(1/2) I've stopped using the script method awhile ago. The less complicated way to tackle this uses a Google Form paired with a Google Spreadsheet.
- Create a Google Form. Pair it with a Spreadsheet.
- Use the prefilled form option in Google Forms to grab your name/value pair variable names. You'll get something that looks like this. I add the names I want to reference into the fields before submitting.
https://docs.google.com/forms/d/e/1FAIpQLSeL2Z8hvyxK_EipeC7Fc8NDncE3VtVsMMsQZIOkCfkOPSLKgQ/viewform?entry.1518353193=NAMEFIELD&entry.1403774106=COLORFIELD&entry.1433875917=NUMBERFIELD - You'll set your AJAX function to target the form response address. It's the same address as your form except it ends with formResponse instead of viewForm. https://docs.google.com/forms/d/e/1FAIpQLSeL2Z8hvyxK_EipeC7Fc8NDncE3VtVsMMsQZIOkCfkOPSLKgQ/formResponse