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, 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/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!
Steve, I'm very interested in this. My goal is to do the following:
- Pull email address from LMS into Storyline360
- Send email address from Storyline to Google Form -> Google Spreadsheet on course completion trigger
- Use Zapier to collect email address and send an email to the learner.
I've pulled in the email address from the LMS to Storyline. But I can't get it to spit out to the Google Form.
I used the script you posted several years ago. Now I'd like to use your formResponse target but I don't know how to change my javascript.Can you help me figure it out?
The SL course is hosted on ScormCloud
https://cloud.scorm.com/sc/InvitationConfirmEmail?publicInvitationId=91fa6f1b-fd93-4f16-bfe4-fdc71f01b8c4
thanks-Claudine
