Adobe Captivate 5.x Widget: Variables To Google Form

You are here: Home > Adobe Captivate 5.x Widget: Variables To Google Form
VariablesToGoogleFormCp5.x

Adobe Captivate 5.x Variables To Google Form Widget

From: $80

Clear selection

Product Description

This widget allows you to send any Captivate variable (Quiz, System, or User) to a Google Spreadsheet Form.  No Google sign-in required.  As an alternative to Acrobat.com reporting, you can use Google as a simple LMS to store your quiz results.

 

Possible Use Cases:

1. Send quiz results for LMS functionality

2. Conduct a training effectiveness survey in Captivate and send the results to the spreadsheet

3. Collect customized Information from your Learners

This widget was rebuilt from the ground up using the awesome CpGears platform.  The older Captivate 4 version can be found here.

 

Improvements Over the Captivate 4 Version

  1. Ability to automatically send Learner’s quiz answers
  2. Notification of a successful form submission.  If the data was sent successfully, a user variable of your choosing will equal one.  If not, it will equal zero.  You can create a conditional advanced action based off of this value to branch off in a different direction and/or display your own custom message.
  3. Following #2, another user variable of your choosing will be set to give you more detail if an error occurred.  This will help in troubleshooting and debugging your project.

You can find the Adobe Captivate 6.x version here.

How Does it Work?

Watch the video.

 

Requirements:

  1. Adobe Captivate 5.0 OR 5.5
  2. Publish for Flash Player 10+
February 7, 2013 – v. 5.8 of the widget now works with the new version of Google Forms that was released early February 2013. In order to make the widget work with the new Google Forms, you’ll have to enter the “Pre-filled URL” setting in the widget. The “Pre-filled URL” can be found by going to the form in edit mode. Go to “Responses”, then “Get Pre-filled URL”. A new browser window/tab will open. Do not fill out the form… Just hit the “Submit” button at the bottom and a URL will be produced at the top of the form highlighted in yellow. Copy and paste this URL into the “Pre-filled URL” setting in the widget’s properties. This URL tells the widget the number and order of the form fields. If you add, remove, or rearrange your form fields, you will need to update the Pre-filled URL setting in the widget so they sync up.

Limitations

  1. If you randomize your quiz questions, you will end up scrambling your results on your spreadsheet.  The order of your Captivate questions should match the order on your spreadsheet.
  2. Use of the “skip” button during a quiz could offset the quiz answers in your spreadsheet.  Simply remove the “skip” button on your quiz questions.

Live Demo:

Live Demo

 

Try Before You Buy:

You can download a trial version to test in your own projects.  It will display the CaptivateDev.com logo and a red “Trial Version“ in your project, and will only run from inside of Captivate (F4 or F12 preview), or your local web server (http://localhost/ or http://127.0.0.1/).

Download Trial

 

Change Log:

  • v. 5.6 (February, 15th 2012) - Widget now supports quiz retakes.  Hot Spot questions now report 0 for correct and -1 for incorrect.
  • v. 5.7  (December 10, 2012) – fixed errors HTTP 503, Error 2032, Error 0 – all related to the Amazon web service that has been discontinued.  Results were not being submitted to the spreadsheet because of this.  Please update and republish your projects using the new 5.7 release that corrects this issue.
  • v. 5.8 (February 7, 2013) – Now works with the new version of Google Forms that was released early February 2013.  In order to make the widget work with the new Google Forms, you’ll have to enter the “Pre-filled URL” setting in the widget.  The “Pre-filled URL” can be found by going to the form in edit mode.  Go to “Responses”, then “Get Pre-filled URL”.  A new browser window/tab will open.  Do not fill out the form… Just hit the “Submit” button at the bottom and a URL will be produced at the top of the form highlighted in yellow.  Copy and paste this URL into the “Pre-filled URL” setting in the widget’s properties.  This URL tells the widget the number and order of the form fields.  If you add, remove, or rearrange your form fields, you will need to update the Pre-filled URL setting in the widget so they sync up.

Support:

Have a pre purchase question or need assistance?  You can contact me directly using the contact form or drop a comment on this post.

 

FAQ:

Q:  It seems from the demo that the student can click a button to view all the answers from all the other students. Is there a way of preventing the student from seeing the results that are submitted?

A:  Only the demo contains a button to view the final results in the Google spreadsheet.  If you want to include a button like that, it’s up to you.  The widget does not do that automatically.

 

Q: Is the email text entry box in the demo being used as way of identifying the student?  If so would it be possible to use a variable that has already been recorded elsewhere in the project eg the student id?

A:  Yes.  The email Text Entry Box is not part of the widget and it is simply my way of identifying the learner in the demo.  You could use your own studentID variable just as well.

 

Q:  Could you password protect the spreadsheet containing the answers so that only a person, such as a teacher could ever get access to the results?

A:  Yes.  By default, the Google Form must be shared in order for it to work.  However, the spreadsheet behind the form does not.  So the spreadsheet containing the form submissions (quiz results) can be password protected.

 

Q:  Does the widget have to be placed on the Quiz report screen or can you place it anywhere within the presentation?

A:  The widget can be placed anywhere in your project.  I’d avoid placing it on quiz question slides or the quiz score slide simply because some variables are not set until after the score slide.

 

Q:  What happens if a user closes down the project before completing a quiz, and then subsequently resumes? For example what happens to the answers given to the first five questions in the following scenario:  A quiz has 10 questions spread throughout the presentation. The student attempts five questions on day one. The student then stops, closes down the captivate presentation. The next day the student reopens the presentation and takes the remaining  five questions.

A:  Resume or suspend data is handled by your LMS.  If you are allowing Learners to resume a course where they left off, then all of their quiz answers should be saved when they return.  The widget does not handle any suspend or resume data.  It simply submits the quiz data when you, the Captivate Author, decide that the time is right.  The live demo places the widget after the quiz score slide.  Once the learner reaches that point in the presentation, the data is sent to the spreadsheet.  In your example, the data would be sent to the Google spreadsheet once the quiz is completed.  For that student, it would mean the next day when they resumed the course.

 

Q:  I’m in the process of creating my Google Form and when I test it, the results are one-off or some are just skipped.

A:  Chances are, you’ve added, removed, or rearranged form fields and the Google spreadsheet that’s linked to the form no longer reflects the order you need your data.  The fix is to link the form to a new spreadsheet.  With the form in edit mode, you can choose the “Choose response destination” menu.  Then select “New Spreadsheet”.  You’ll create a new spreadsheet and all of your old data will also be moved to this new sheet.  How cool is that!

Posted on March 7, 2011 by in All Widgets, Captivate 5.x, Premium Widgets

About Jim Leichliter

View all posts by Jim Leichliter →
  • John M. Arispe

     I cant get the google form to give me the line code with the “…true” response. I keep ending up with https://spreadsheets……../formResponse?hl=en&formkey=dE9sTU1HZzViQVB4YzAxaDJjbUxGeFE6MQ&ifq

    • Anonymous

      @google-a1ef6b9fc679b391cc9955ac5fece102:disqus 

      Use the embed code that google spits out.  If you can’t seem to find it, you can reconstruct the URL based on my example above.  The two main items are the form key and the embedded=true. 

  • Fab

    Hi… very interesting.

    Is the number of user variables limited ?

    Is it possible to use the widget without using the quiz slides ?
    (and just send user variables ?)

    Best regards.

    Fab

    • JimLeichliter

      @0724c85e8f132fffc9dd45f115f4a68c:disqus :   Great Questions!  There is a limitation on how many columns you can add to a Google Form… which would be 256… Then count 1 column for the time stamp and you have a limit of 255 questions.
      Yes… it is possible to use the widget just for user variables.  

  • Colleen

    Hi Jim — Can this widget be used to write to a spreadsheet on a local server?  Just need a very simple recording / reporting tool, and if I can write to a csv or excel file, it would be great.  Thanks, Colleen

    • Jim Leichliter

      @Colleen:  You would need some kind of server side technology (ASP, ASP.NET, PHP, JSP, ColdFusion) to store results on a local server.  Does your company support any of these technologies?  If so, you can customize the .htm wrapper to send the results to the server and create a spreadsheet or .csv file.

  • Steve

    Hi Jim,

    Great blog – can you use this to record individual answers to questions using the Report ID for the question?

    Cheers,

    Steve

    • http://twitter.com/CaptivatePro CaptivateDev.com

      @Steve:  The ReportID is a SCORM implementation.  However, you could label your Google form questions with the corresponding ReportID.  This would be a manual process, but entirely possible.

  • Joel Renner

    Jim,

    I am having a problem getting all of the variables I need to flow into the Google form.  After I had some problems with my quiz results I tried using your example and sending it to a form of my own and it still will not send all of the data.  Same setup as your example with a different form and the only fields flowing over are: Email, Course Name, True/False, Fill-in, Pass/Fail, total number of points in quiz.  Let me know if you have any suggestions.
    Best, Joel

    • Anonymous

      @google-86d48cd9f7390470ffae7bcd5445fc95:disqus  I’d be happy to look at your project.  There is no need to set anything in the quiz preferences.  Most people get hung up on the Google form linkage between the Form and the back-end spreadsheet.  If you modify the spreadsheet at all (re-arrange columns, insert columns, delete…) it will break the linkage between the two.  Best practice is to re-create your Goog form from scratch if you need to rearrange things.  Also, make sure that you’re publishing for Flash Player 10 or above.  And make sure that the variable names you entered in the widget properties are spelled correctly and character case counts.  varUserName is not the same as varUsername.  Go ahead and send over an abbreviated version of your project and I’ll be more than happy to take a look.  Also, make me an editor/owner of the Google form/spreadsheet.Thanks,Jim

  • Marek

    Is it possible that I also get results of the time spent on a course through this widget? We need to use this criteria in quiz as well. 

    • http://JimLeichliter.com Jim Leichliter

      @Marek: If you can store it in a variable or already a variable, it can be sent to the Google Form. Take a look at the system variable: cpInfoElapsedTimeMS

  • Mglassic

    Hi Jim,
    I have a quiz that contains 50 questions, following the quiz the “uploading results” seems to tale forever.  I have upload question data unchecked, what could be causing the long upload process?

    Thanks

    • Anonymous

      @Mglassic:  Could be any number of factors.  Your internet speed, Memory on your PC, memory taken up by your browser process.  I have many people using this widget at hospitals, universities and corporations… I don’t think it’s the widget, but I’d be happy to look at your project if you want to send it over.  Jim AT Captivate Dev dot com.

  • Rui Hu

    Hi Jim, I followed your video tutorial and set up my test project. I am able to transfer some of my variables from the Captivate project to the Google form, such as the course name, pass/fail, total score. However, I can’t get the email address to be passed to the google form, and all quiz responses can’t get passed to the google form too. I am able to display the value of email on my Captivate screen and it shows that the variable has been assigned to whatever the user types into the text entry area. However, the last letter of the email address that I entered was missing.

    The error message returned for the variable of returnMsg is “0Error: variabl” — again, it doesn’t show the entire word of “variable”. I thought that was because the text caption I used to display the returnMsg and I resized the text box. However, it still shows the same.

    In the actual Google spreadsheet, for the column of “email”, it shows nothing. For the columns of coursename, pass/fail, total score, it shows the right data. For the first quiz item, which is a multiple-choice question, it shows “Variable  Not Found or no default value set.” For all rest columns which are the other quiz items, there are nothing.

    Would appreciate a lot if you could help me to figure out why this happens.
    Thanks.

    • Anonymous

      @Rui Hu:  Add the returnMsg variable to a caption, BUT make sure you allow more than 15 characters for the length.  This way, you’ll get more info on what’s causing the issue.  The linkage between the Google Form and backend spreadsheet is delicate.  The key is to make sure you don’t re-order questions or columns between the two.  If you do, you can one-off the spreadsheet.  If you have to move things around, the best thing is to re-create your form and spreadsheet from scratch making sure you add your fields sequentially in the desired order.  

      • Rui Hu

        Hi Jim, thanks for your fast response. I just tried to change the length of the variable and here is the error message I got: “0Error: variable not found. Check that is defined and has a default
        value. Check spelling and case in the widget properties. Success”.
        I did notice that you said not to change the order of questions and I re-did a new form just to make sure everything is right. But I still got the same error.
        Then I realized if could be because I have been using the project preview option of “In Web Browser” instead of publishing them. So I published my project and then view it in my browser (I am using Captivate 5.5 and Mac OS. 10.6). This time I didn’t get any error msg, but both the variables returned 0 and I didn’t get any variables transferred to my google form…
        Do you think it is because I didn’t set up the web server on my computer? I don’t know how to set up the localhost webserver on Mac though.

        • Anonymous

          @Rui Hu:  After looking at your project, it looks like you had an extra comma at the end of the “Variables To Send” section of the widget properties.  There shouldn’t be any leading comma at the end.

  • Rui Hu

    Hi Jim, this is such a brilliant widget and thanks for your help, now I moved the widget after the question report page and it works fine with the web preview. However, I just tested my course with the LMS we use here (it is a LMS developed by independently here) and the data won’t be passed to the Google form. Can you please advice on what could be the reason for this to happen and how I may be able to fix it?
    Thank you very much.

  • Rexrothbeat

    So, I want to make sure I have this correct. Do you create both a form and a spreadsheet in Google? If so, I’m assuming I create the same elements in the Google form as the form variables I’ve created in my Captivate form. Correct?

    • Anonymous

      @ddb0b7ca25e472b7b4d7919c6fba249f:disqus :  When you create a Google Form, a spreadsheet is automatically created to capture the backend results.  Make sure you watch the video.  You basically create a Google Form text question for each variable you’re sending over.

      • Rexrothbeat

        I watched the video twice before I posted (good video, thanks!), but the third time it became clear–along with your reply above–that it doesn’t matter what sorts of forms you build in Captivate, it’s the variables that are important. You have to have a Google form field for each variable you want to appear in your spreadsheet. Looks like a widget I could really use. Thanks.

  • Erin Dalzell

    How do I link the question in my quiz to the column in the Google Doc? I’m new to Captivate and I’ve never used Variables before

    • Anonymous

      @d8a57d4fc8b54dd4f82c1896b450c204:disqus :  I’d suggest watching the video above.  If you want to learn more about variables, you can do so here:http://adobe.ly/myUcdV

  • Evan

    I’m going to purchase this widget as soon as I can work out a bug. I downloaded the trial version and everything works fine except 2 variables are not populating the Google spreadsheet: the user’s phone number, and the user’s ID #. I checked to make sure the variables in the widget were defined correctly and matched those in my Captivate project. They do. But the two don’t populate and everything  bumps up 2 columns in the spreadsheet, meaning some wind up under the wrong heading. Any suggestions?

    • Evan

      Never mind, Jim. I rebuilt the form, the spreadsheet, and repopulated the widget. It’s all working great now. Time to buy!

  • Gwenpond

    I have a branch learning game that was built with the newest version of Captivate and it consist of 5 projects, and each project has it’s own set of questions. Each participant has to go through the first project and then they have three paths/projects they can choose to go down (after choosing the path, they will not go through the other two paths) but all are required to go through the final path. I have a post results page at the end of the final path, but the problem I’m running into is that it only post information gathered from the final path. Will your widget be able to collect the information/answers from each path/project and then report?

    If not, do you have any suggestions?

    • Anonymous

      @87d2223df957c8bce9b2896537e83404:disqus :  There is one-to-one correlation between the .ctpx project and the Google Spreadsheet Form.  Each project would have to have it’s own Google Form for reporting.  Scoring for individual projects are not aggregated through the widget, but you may be able to do that through functions on the Backend spreadsheet.

  • http://thedalzells.org Erin Dalzell

    it only works in preview mode. How do I get it to work when I publish. Do I need to include the plugin.swf somewhere special?

    • http://twitter.com/CaptivatePro CaptivateDev.com

      @edalzell:disqus :  You are experiencing a limitation of the trial as described in the post.  If you want to publish to your own server, you need to purchase the full version.

      • http://thedalzells.org Erin Dalzell

        No, I have the paid version. When I publish it doesn’t seem to work. If I publish an executable file it works fine, so that’s what I’ve done for now.

        Thanks

        • http://twitter.com/CaptivatePro CaptivateDev.com

          @edalzell:disqus Go ahead and send me your .cptx file and the link to the google spreadsheet.  You can send it to Jim At Captivate Dev dot com.  Would it be possible to give me editor access to your form?  My Google account is Jim Leichliter At gmail dot com.  I’ll troubleshoot this and get back to you via email.

        • http://twitter.com/CaptivatePro CaptivateDev.com

          @edalzell:disqus :  Also, the published project needs to be run from either:
          1.  A web server
          2.  A TRUSTED flash location

          Captivate has a bad habit of asking you if you want to view your newly published project.  It’s a “Yes” or “No” dialog.  I always choose “No” because nine times out of ten, you’ve published to a location on your hard drive that is NOT trusted by flash and the widget will not function.  I usually say “No” to this dialog and publish to either my local web server or my server at CaptivateDev.com for testing.  Try publishing to a web server to see if that works.

          • http://thedalzells.org Erin Dalzell

            Ah, this is not something we want to publish to the world so we run it on our own machines. I used the Executable method to make it all work. Thanks.

  • Rexrothbeat

    I’ve built a spreadsheet that retrieves variables, then clicked the Send Quiz Answers. I’ve added a spreadsheet column for each quiz and poll answer.But the results in the spread sheet are all over the place. Do you do something different than what I’m doing? Do I somehow add quiz and poll information to the Variables To Send field?

    • http://twitter.com/CaptivatePro CaptivateDev.com

      @ddb0b7ca25e472b7b4d7919c6fba249f:disqus :  
      Most people get hung up on the Google form linkage between the Form and the back-end spreadsheet.  If you modify the spreadsheet at all (re-arrange columns, insert columns, delete…) it will break the linkage between the two and one-off your form.  Best practice is to re-create your Goog form from scratch if you need to rearrange things.  Also, make sure that you’re publishing for Flash Player 10 or above.  And make sure that the variable names you entered in the widget properties are spelled correctly and character case counts.  varUserName is not the same as varUsername.  

  • Laurie Lyons

    Great useful app!  I’m testing the trial version and it works in IE but not Firefox. Has anyone else had this issue?  Is it because of the g_intAPIType issue in Captivate?  Or could it be something else?  I’m interested in purchasing the app, but not if there are browser issues. I can’t test the g_intAPIType issue without publishing, which won’t work with the trial version. 

    Thanks!

    • http://twitter.com/CaptivatePro CaptivateDev.com

      @google-ae0b90688542e3df7579bab932dd8a58:disqus :  I’m not aware of any g_intAPIType issue in Captivate.  Can you expound a bit?  I just tested the live demo in FireFox and it worked flawlessly.  The solution is browser agnostic since all the work is done in AS3 and Flash.  You can contact me at Jim At Captivate Dev Dot Com.

      • Laurie Lyons

        Thanks for your quick reply!  I’m sorry, it must have been my spreadsheet set-up or something, but yesterday it wouldn’t record data when I tried FF at first. Now it is working. 

        The g_intAPIType issue I was referring to was one that we’ve had in an LMS we’ve used for some projects: 

        I thought maybe they were related because of my FF issue, but now I realize the SCORM behavior has nothing to do with the widget. 

        But I do have another question about the widget:  How do you work with “branched” questions. My project has a few multiple choice questions that go to a text-field slide only if the person answers “Other.”  If they don’t answer other it skips that slide. It looks like I have some alignment issues in the spreadsheet because of this. Any suggestions?

        Thanks! 

        • http://twitter.com/CaptivatePro CaptivateDev.com

          Thanks for the info Laurie.  One option for your “other” type questions is to set a default value for the variable used to store the entry in the corresponding Text Entry Box.  That way, something will be recorded and keep all your rows in tact.

          • Laurie Lyons

            Thanks for the suggestion. Could I ask how you would set default values for short answer question slides? Or does it have to be a text entry box on a regular non-question slide?

          • http://twitter.com/CaptivatePro CaptivateDev.com

            @google-ae0b90688542e3df7579bab932dd8a58:disqus :  It would be a regular TEB on a non-question slide.  However, since the TEB is an interactive object, you can still report it and add it to the quiz as if it was a regular quiz slide.

          • Laurie Lyons

            Many thanks!

  • Sean Dechellis

    I purchased your widget and am having trouble getting it to work on multiple quizzes. The way my project is setup; I have a TableofContents.swf that has 13 sections in total linking from it, each of which are separate captivate projects. I placed your widget within the first section, everything works fine, that particular slide pauses correctly and everything loads fine to the google spreadsheet. Once the first section was working fine, I then placed it within the second section. Everything worked fine when I tested it on my local drive, but when I loaded it to my server it seems like when it gets to the slide with the widget on it, it isn’t recognizing the widget and immediately goes to the next slide. What is the deal here? I will need a refund if you widget is unable to work with multiple quizzes. Thank you.

    • Sean Dechellis

       It seems I have located an answer for this. I was unaware when I purchased this widget that each individual quiz will require its own “unique” google form. I will give that a try.

      • Sean Dechellis

         Well this solution didn’t work either….. frustrated.

    • http://twitter.com/CaptivatePro CaptivateDev.com

      @97c231cbc9996c73d65718c5f4336dc4:disqus :  Sean, if you watched the videos and downloaded the demo file, then you know that there are two slots in the widget properties for captivate user variables that you can use for debugging.  Are you getting any error messages?  What are the user variables reporting?  When you talk about “sections”, I assume this is a separate captivate file?  So each widget is in a separate captivate file?  That should pose no problem at all.  If you’d like to send over your .cptx projects via dropbox.com, I’d be happy to take a look.  You can email me at Jim At Captivate Dev dot com.  

    • http://twitter.com/CaptivatePro CaptivateDev.com

      @97c231cbc9996c73d65718c5f4336dc4:disqus :  We’ve already corresponded, but for those reading this blog.  Sean had a pass/fail quiz action set up in the quiz properties to “Open URL or File” and he was navigating away from the course before the Google Forms widget had a chance to do it’s work.  Just be sure to perform those kind of actions after the widget has done it’s duty and you should be good to go.

  • Robert

    Awesome! Works fine, even with new Google Drive!

    Thanks a lot Jim!

  • Sarah Iddrisu

    Hi Jim, I’ve had this working once but I’d moved the columns around and gotten confused.  I’ve recreated the form/spreadsheet and added the link in again to your widget.  I know the link is working but I’m having problems getting anything else to enter.  I’ve tried stripping out the variables to send, to see if it would just send results but I still get nothing.  I’m not sure how to create the returnMsg you mention in other messages – is this a text field?  If so how do I get your widget to talk to it?

    Thanks
    sarah

    • http://twitter.com/CaptivatePro CaptivateDev.com

      @Sarah Iddrisu:  I’d be more than happy to look at your project if you want to send it over:  Jim AT Captivate Dev dot com.  The return message is just a Cp user variable displayed in a text caption.  I’d double check the “submit action” url inside the widget.  If you copy and paste that URL into a new browser tab, it should produce a blank entry in your spreadsheet.

  • Steve Blumey

    Does this work with Captivate 6.0?  

    • JimLeichliter

      @facebook-31703113:disqus : Not yet, but it will be released very very very soon.

  • http://twitter.com/CaptivatePro CaptivateDev.com

    The Captivate 6 version of the Variables to Google Form widget can be found here:
    http://captivatedev.com/2012/07/19/adobe-captivate-6-x-widget-google-lms-with-email-reporting/

    Now dubbed “Google LMS with Email Reporting”

  • Ermina Waters

    Hi Jim

    I’ve just bought the Google LMS Widget.

    How do I download it??

    • http://twitter.com/CaptivatePro CaptivateDev.com

      You should have received an email at your gmail address with the download details. If not, please let me know: Jim AT Captivate Dev dot com

  • kp
    • http://twitter.com/CaptivatePro CaptivateDev.com

      Works for me using Chrome, IE, FF. What browser are you using?

  • Joe McCahill, M.Ed.

    Hi, I put this in a course and it worked fine until last week, when it has stopped working….I’m now getting the errors “HTTP Status: 0″ followed by “Error #2048″ …. I’ve rebuilt the widget and the google form from scratch with no luck! What happened???

    • http://twitter.com/CaptivatePro CaptivateDev.com

      @ Joe McCahill: Please refer to the change log on this post regarding v. 5.7. You will need to most recent release of this widget. To download, please visit http://CaptivateDev.com/Downloads . Shoot me an email if you do not have your code. You should have received your code via email when you purchased the widget.

  • rachelle

    Hi Jim, I’m using the trial version of the 5.5 widget. I dont want to use quiz questions but I have FirstName, Surname, Company, reason for Visit, then yes no answers and some text entry boxes all in all 13 columns on the google form but its only populating 8. Is this a trial limitation? I want to purchase but I need to know that I can use the widget to populate multiple text entry boxes.

    • http://twitter.com/CaptivatePro CaptivateDev.com

      @rachelle: Double check the spelling of your Cp vars against what’s inside the widget properties. Try deleting the Spreadsheet TAB, then make another submission. This will “reset” the Form to Spreadsheet connection and possibly re-link everything properly. If not, you may need to redo your Google Form. If you’d like, I can look at your .cptx file if you want to send it over. Jim AT Captivate Dev dot com.

  • Chromehunger

    As of 6 Dec 2012 the widget stopped sending data to the Googe Spreadsheet (Google Docs now Google Drive). If this is fixed in v5.7, how do I get v5.7? If not, what else could be going on? the CPT stack is unchanged since Oct 2012 but the Google spreadsheet is not receiving data after 6 Dec 2012. Thank you.

    • http://twitter.com/CaptivatePro CaptivateDev.com

      @ Chromehunger: I’ll send you your download info shortly…

  • Lynn Gravel

    Where can I find the 5.8 version ot the widget (variables to google form)?