Adobe Captivate 5.x Variables To Google Form Widget
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 here.platform. The older Captivate 4 version can be found
Improvements Over the Captivate 4 Version
- Ability to automatically send Learner’s quiz answers
- 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.
- 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.
- Adobe Captivate 5.0 OR 5.5
- Publish for Flash Player 10+
- 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.
- 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
- 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.
Have a pre purchase question or need assistance? You can contact me directly using the contact form or drop a comment on this post.
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!