This article will contain a range of troubleshooting tips and tricks.

Problem: My project works when I view the HTML5 version but it does not work when I view the SWF based version.
Answer: There can be a number of reasons for this:

• Check that you have published your Adobe Captivate project to Flash Player 11.
• Check that you don’t have any Knowledge Check questions in your project. The widget will not work with Knowledge Check questions in SWF output.
• Check that you don’t have a pop-up blocker blocking the window that reports to the Google Sheet

Problem: My project doesn’t work at all – nothing is being reported.
Answer: There can be a number of reasons for this:

• Check that you have inserted the widget on the first slide of your project and set it to “Display for rest of project”.
• Ensure that you have at least one (1) quiz question in your project.
• If you are not using the default Adobe Captivate quiz results slide, ensure that you have defined this in the widget properties.
• Go through the guide on setting up the Google sheet again: Setting up a new Google Sheet
• If you are using the PHP files, read through the guide again and ensure you have followed every step: Using the external PHP script

Problem: One or more of my Custom Variables are not being added to the Google Sheet.
Answer: If the variable heading is not being added to the Google Sheet, then you may have forgotten to add the name in the Widget Properties. Also, ensure that the spelling and case of the variable name are 100% correct.  If the heading is added to the Google Sheet, but the value is not being populated, chances are that you have an error in your Adobe Captivate project in regards to assigning a value to the variable.

Problem: My project reports data to Google Sheets, but only the static information is transfered even though I have selected Quiz Data and Custom Variables in the Widget Properties as well.
Answer 1: Chances are that you did not use the “Reset All” option in the “CPGURU” menu in the Google Sheets to begin with. Try and select “Reset All” and test your project again.

Answer 2: In some projects the apostrophe used in word contractions such as “it’s” will break functionality when Google receives the data. The problem seem to be isolated to projects that are updated from earlier versions of Captivate or projects where text have been pasted into the answer options (this problem only occurs with text in answer options). The fix is to write the word again in Captivate as that will change the apostrophe to the proper one.