Exporting Variables into a Google Spreadsheet

The Google Form itself should be shared with everyone.

However, there are a few things that can stop up the works. Watching the Javascript console is helpful in tracking down where things might be wrong. Here are a list of potential gotchas:

• The JQuery dependency isn't loaded before the ajax call. This means on the same slide on the base layer with your ajax call in another layer or in another slide that's sure to be hit. Loading everything at once, it'll likely fail as there's quite a bit that happens to force the load. 
• There's another script error somewhere. Invalid script, a missing variable, an LMS call tested outside of an LMS. Lots of stuff can put a stop to script execution before you reach the ajax call.
• Using the wrong form address. In my example above, the link provided was for my organization. It includes the org address. If you use this same string, it'll fail unless your part of my org:)
  fTarget="https://docs.google.com/a/nara.gov/forms/d/YOURFORMID/formResponse";