General information about the Reporting Widget
The Reporting Widget is an HTML5 based widget that allows you to send data from Adobe Captivate to Google Sheets and/or send data by email. The Reporting Widget also offers the ability to send emails via a PHP script that you must upload to your own web server.
The Reporting Widget also currently supports projects published to SWF (Flash based output) although there are some minor differences between the HTML5 output and the SWF based output. The SWF based version will need to display a pop-up window to the user in order to transfer the data to Google Sheets – this is not needed with the HTML5 output.
Test project demonstration the widget capabilities
To see how the widget works and see a demonstration of its capabilities, please try the Solar System Quiz test project.
Note that you will need to answer 5 of the 7 questions correct in order for the widget to send the data!
You can see the data collected by the widget by opening this link to Google Sheet.
Functionality using Google services:
The Reporting Widget allows you to transfer data directly to Google Sheets and use Google mail service to send an email to an email address of your choosing. The widget will transfer the following data by default:
- Users name (picked up from the Captivate variable cpQuizInfoStudentName)
- Course name (picked up from the Project Name in File – Project info)
- Date completed
- Time completed
- Time spent (shows the amount of time the user spent in your course)
- Quiz Passed (True / False)
- Quiz max points
- Points scored
- Quiz percentage
- Quiz attempts
In addition to the information above you can also transfer Question Data, which will add each question in your quiz to the sheet along with the users’ answer and an indication of if it was answered correctly or not.
Finally, the Reporting Widget gives you the option of transferring any custom variables (or system variables) that you like:
You also have the option of having an email sent to you (or any other email address you specify) whenever a new result is registered.
The email sent by Google can be easily customized and extended by using “merge vars”.
Functionality using the external PHP script:
If for some reason you do not want to use Google Services to store or send your data, you can use the PHP script that is supplied with the widget. This PHP script must be uploaded to your own webserver and the widget will use this to send an email to the email address you specify.
The PHP script uses the standard PHP sendmail functionality which is enabled on most web servers today. You also have the option of using a regular SMTP server to send the email if you like. By using an SMTP server you will greatly reduce the chance of the email ending up in the users’ junk/spam folder.
If you use the PHP script you will receive an email that looks something like this:
Requirements:
Adobe Captivate 7, Adobe Captivate 8, Adobe Captivate 9 or Adobe Captivate 10 (2017) or Adobe Captivate 2019.
A project that contains a minimum of one (1) standard Adobe Captivate quiz question.
If you publish to SWF based output, you must publish to Flash Player 11
Limitations:
If you are using Google Services with the widget, this is subject to the rules, regulations, and limitations of the service as defined by Google. Current quotas for Google Services can be found here: https://developers.google.com/apps-script/guides/services/quotas
Currently, the free consumer version of a Google account, allows you to send up to 100 email messages per day. If you need to send more than 100 emails per day, you can either opt to use the PHP script in the widget and send the emails through your own PHP / SMTP server, or upgrade your free Google Account to a G Suite Basic, G Suite Business, G Suite for Education, G Suite for Nonprofits, or Google Apps for Government account.
If you use the widget in a project that contains Knowledge Check questions AND publish to SWF/Flash, the widget will not work with the SWF based output. It will still work with the HTML5 based output just fine.
Additional information:
If you want to know more about the widget, I recommend that you take a look at the online help documentation found in the knowledge-base.
Buy the widget:
The Reporting Widget costs $85 which gives you the right to use it for one Adobe Captivate Developer in your company. Click the green button below to purchase a license.
If you have multiple developers who will be using the Widget then select the number of developers in the dropdown below and click the “Add to Cart” button.
11 Comments
Pingback: Email Reporting Widget for Adobe Captivate | CP Guru - Adobe Captivate Widgets
Do you have to use the email feature? Ideally I want to use this in a project to bypass purchasing a full LMS system.
Hi Steve,
No you do not need to use the email feature. You can make it update the Google Sheet without sending an email if you like.
Sincerely,
Michael
Is there any option to use variables (Name, Date of Completion etc.) and create PDF certificate sent with the reporting? Creating manual certificate using the reported variable is time consuming. Any ideas?
Will this work for the 2019 version?
Will this work for Adobe Captivate 11?
Hi Micheal,
Does this widget work in Captivate 2019?
Thanks.
Paul
Is this compatible with Captivate 2019?
Sorry for the late answer.. Yes it is compatible with Adobe Captivate 2019
Can this be adapted to use with an Office/Excel 365 spreadsheet online in Sharepoint, Teams, OneDrive or other O365 cloud location?
In theory yes. The widget can send all data in JSON format to an external script file that can handle any processing you like. The widget comes with a PHP script that can send email, but it can be adapted to do anything you like if you have the coding skills required.