Forum Discussion

KateRobertson's avatar
KateRobertson
Community Member
10 years ago

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...
storyline 360
SteveFlowers's avatar
SteveFlowers
Community Member

Hi, Michael - 

I stopped using the script-based submission for a variety of reasons awhile ago. Instead, I just use the formResponse target that the normal form uses with an AJAX post. This tends to work every time for me. I use the "Get Prefilled Link" feature to discover the expected form fields.

https://docs.google.com/forms/d/e/1FAIpQLSewmIMASgsR78EKGSEG1Y81TgPHJ2YjaunE2d4F6C5l9v2nrw/viewform?usp=pp_url&entry.1632817179=First&entry.764465594=Second

https://docs.google.com/forms/d/e/1FAIpQLSewmIMASgsR78EKGSEG1Y81TgPHJ2YjaunE2d4F6C5l9v2nrw/formResponse?entry.1632817179=First&entry.764465594=Second

MichaelHinze's avatar
MichaelHinze
Community Member
7 years ago
Steve Flowers

Hi, Michael - 

I stopped using the script-based submission for a variety of reasons awhile ago. Instead, I just use the formResponse target that the normal form uses with an AJAX post. This tends to work every time for me. I use the "Get Prefilled Link" feature to discover the expected form fields.

https://docs.google.com/forms/d/e/1FAIpQLSewmIMASgsR78EKGSEG1Y81TgPHJ2YjaunE2d4F6C5l9v2nrw/viewform?usp=pp_url&entry.1632817179=First&entry.764465594=Second

https://docs.google.com/forms/d/e/1FAIpQLSewmIMASgsR78EKGSEG1Y81TgPHJ2YjaunE2d4F6C5l9v2nrw/formResponse?entry.1632817179=First&entry.764465594=Second

Hi Steve,

thanks for the info. It's funny, I had used fieldIDs for my very first test project. It did work fine but it felt like a hack...having to dig up the IDs, etc. I'll give it a try. Back to the future!

Related Content