Forum Discussion
exporting variables to be read in a Google docs spreadsheet
I've seen Tom's helpful screencast on how to embed a Google docs form into a Storyline project. However, what I want to do is a little different. I'd like to be able to export the values of about...
Mucho props for Tracy. She helped me get this up and running.
I wanted to add something here. Tracy mentioned that she is using IE8. So am I, but here is how I got it working. I added a dataType: "jsonp" to the script. It now works for me in IE8.
============================
var player = GetPlayer();
$.ajax({
url: "https://docs.google.com/forms/d/1ebGN0lrq2_DU24UtsQqpD9Zf64TZiPAFNDN9gu8MjlE/formResponse",
type: "POST",
dataType: "jsonp",
data: {"entry.340255159" :player.GetVar("FirstName"),
Thank Mike. I'll add that to my post.
Brilliant! Mike, you just solved this issue for me.
This was a posting I found for why this works....I have no idea what he is talking about, I'm just glad it does what I need it to.
"It returns your JSON data wrapped in a function name. jQuery handles the function name behind the scenes and passes the data into your success handler. The data is loaded by dynamically creating a script element with the src attribute pointing to the service being called and then attached to the browser's DOM. Then the browser makes a request to the resource and the web service responds with the callback function and data."
