exporting variables to be read in a Google docs spreadsheet

Hi Chris, 

Where are you testing the content from? On your previous image, it appeared that you were testing the published version that was on your local drive. You'll want to publish the course and then place it within the intended environment to properly test elements such as Javascript. If you're publishing for web, there are a few free options you could consider testing in if you don't want it to be publicly accessible yet. 

• Tempshare: This is a free service provided by Articulate for testing Storyline content. Note: Uploaded files will be deleted after 10 days.
• Amazon S3: Amazon S3 offers free hosting with generous usage limits. If you go over your limit, you'll be charged a graduated fee.
• Dropbox: Place your published output in the Public folder in your Dropbox account to share it with others.
• Google Drive: Change the story.html file to index.html, and set the sharing permissions to Public. Here's how.

Thanks Andrzej! Your solution is very helpul!

Hi Chris,

the solution is simple - download michael's site then open user.js and have a look at lines 31-52. Voilà. I hope I hope that's not top secret, otherwise I'm sorry.

Jacek

Hi Jacek, NOTHING is top secret in web development The code snippet in my sample is very close to Andrzej's earlier post, that's why I didn't bother posting it here. Of course, the URL and entryIDs are specific to my test file and would have to be adapted anyway.

Hi Everyone,

My first post here, but I've been using the product since it was released (and Studio before that).  I've been coming back to this thread again and again, but I just can't get this to work.  I'm simply trying to export variable data into a Google Sheet.

I've read all the documentation on this thread (several times!), tried multiple variations of the script provided above, and even extracted Michael's user.js in effort to adapt his code -- nothing works!  I must be missing something here..  Can someone please take a look at my code and story?  I've opened my sheet for public review/editing, so you should be able to see everything from front-to-back. 

Thanks!

.Story Attached

My form:

https://docs.google.com/forms/d/1AdbAVu3_ER3cL7o6LcDaMSRUfT5Loo6Hlpvc6TuatLc/viewform

Response Sheet:

https://docs.google.com/spreadsheets/d/15S30zAuxVKzDkW2h9f6EZRHhoW8Id-xln2NvoHzNcUM/edit#gid=130666735

Code:

var player = GetPlayer();

var Name = player.GetVar("Name");

var Event = player.GetVar("Event");

                $.ajax({

                    url: "https://docs.google.com/forms/d/1AdbAVu3_ER3cL7o6LcDaMSRUfT5Loo6Hlpvc6TuatLc/formResponse",

                    data: {"entry.495789985": Name, "entry.647210599": Event},

                    type: "POST",

                    dataType: "xml",

                    statusCode: {

                        0: function() {

                            //Success message

                        },

                        200: function() {

                            //Success Message

                        }

                    }

                });

EDIT:

Removed extra line from original script;

Updated attached .STORY;

added 2nd slide with alternate script:

var player = GetPlayer();    

    $.ajax({

url: "https://docs.google.com/forms/d/1AdbAVu3_ER3cL7o6LcDaMSRUfT5Loo6Hlpvc6TuatLc/formResponse",

           type: "POST",

           data: {"entry.495789985" :player.GetVar("Name"), "entry.647210599":player.GetVar("Event")},

           success: function(data)

           {

               alert(data); 

           }

         });

    return false;

EDIT2:

I see some activity in the sheet from an hour ago that I didn't do, so I hope someone has made some progress   Still unable to get it working my end. 

Curious if there's any new information on this process, particularly to Jason Dowd's issue in the above post. Here is my code, but it doesn't send the data to the Google Sheet. Any ideas? 

var player = GetPlayer();

var first = player.GetVar("TextEntry");

var live = player.GetVar("TextEntry1");

$.ajax({

url: "https://docs.google.com/forms/d/1HvAn2xcVBDcvN1stb2e7YIt1dZ-BW3oba7PgZFowCOk/formResponse",

           type: "POST",

           data: {"entry.985481521" : first, "entry.437746786" : live},

           success: function(data)

           {

               alert(data); 

           }

         });

return false; 

Can you show me your project ?

I feel so stupid re this. Would someone be kind enough to check my code. This is literally all I have in the execute javascript area. I have two text input boxes for a name and student id. The trigger is that when the next button is clicked the javascript is executed. I have tested the entry.37118808 numbers in a web page and it works. I also have the jquery part in the story.html file.  I'm just missing something obvious. I think I will be learning javascript :)

I would really appreciate any help, 

p.s. I more or less copied Jedidiah's code, so thanks for that Jedidiah.

thanks,

aine

var player = GetPlayer();

$.ajax({

url: "https://docs.google.com/forms/d/1MjBkCNiANT18g9X-CyXoCoP58KkynJusV47ETBNwAp4/formResponse",

type: "POST",

data: {"entry.239328797" :player.GetVar("StudentName100"), "entry.37118808":player.GetVar("IDNumber100")},

success: function(data)

{

alert(data);

}

});

uploaded whole thing to Google drive, and it worked. only change I made was the version of jquery I linked to.

<script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>

stupidly I had http://ajaz.........

so it was probably a security issue or something.

Hi All - 

I've been toying around with this for the past couple days, and I'm pretty close but I think I need some assistance.

I have two variables at the beginning of the session for the first name and last name, as well as a variable for the quiz results which was created when I made the quiz results slide. 

the name  variable are able to post to google docs with no issue, however I can't get the quiz results to post. I have confirmed it's not an issue with the google docs data element, as tested with creating a variable to manually enter a number and that posted successfully.

Has anyone seen this where the default variables don't post as expected?

the Javascript I have is:

var player = GetPlayer();
$.ajax({
url: "https://docs.google.com/forms/d/1X8rIvOE9F3cSyCGXpvFwUzug_oUNkz6q1kiUZQJ7f5o/formResponse",
type: "POST",
data: {"entry.1159969422" :player.GetVar("FirstName"), "entry.1107543477":player.GetVar("LastName"), "entry.1692446738":player.GetVar("Results.ScorePoints")},
success: function(data)
{
alert(data);
}
});
return false;