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

ClaudineCaro's avatar
ClaudineCaro
Community Member
7 years ago

Steve, I'm very interested in this. My goal is to do the following:

  1. Pull email address from LMS into Storyline360
  2. Send email address from Storyline to Google Form -> Google Spreadsheet on course completion trigger
  3. 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

Related Content