Category Archives: CalendarScripts

Zapier Webhooks in WatuPRO

The test and survey plugin WatuPRO just got a lot more connected by implementing Zapier Webhooks. (Well, technically, you can send data to any webhook URL – not just Zapier!). Available from version 6.5.7.5.

Here is how this works:

Hooks get notified when a user submits a selected test. You can use them to connect users to mailing lists services, CRM systems, all kind of marketing automation (like SaaS based alternatives of Arigato PRO), and anything else which may consume your contact data. Webhooks are used by all kind of low code / no code services.

You’ll see a new menu link under your WatuPRO menu: Webhooks / Zapier.
Click on it and get to the simple interface for adding a new webhook or editing your existing webhooks.

At the very minimum you need to select which quiz triggers a webhook and enter the endpoint URL. You can choose to notify the hook only if a selected grade / result is achieved on the test. Or fire it for any result.

What Data You Can Send

Let’s have a look at the structure of data WatuPRO can send to your webhook:

Hooks will be sent only if we have at least some data about the user: the very minimum is an email address. If your users are logged in, you’ll always have an email address. The other options is the set the quiz send email to the user when submitting it. In this case they will be asked to provide an email address.

And the third and the most flexible option is to use the “Ask for user contact data” section. You can find it on the Edit quiz -> User and Email tab:

It lets you collect several fields of contact information before the start of the survey of at the end, right before showing the results.

All this data can be sent to any webhooks.

Let’s deconstruct it field by field:

  • Name. You can collect user’s name either this way or from their user profile if they are logged in.
  • Email. As explained above, there are 3 options.
  • Contact phone. Will be available if you have collected it using the above section. You can rename the field and use it for any other data – for example to collect gender or age. We just refer to it as the phone field.
  • Contact company. Same as above.
  • Contact custom field 1 and custom field 2. You can use these to collect any other contact data. Zip, address, interests, a product used, and so on.

All these fields provide dynamic data collected by the user. You don’t need to and can’t set a fixed value that will be sent to the hook.

The name of each variable is defined by you. Since the webhook gets notified with the data in a JSON object, we let you choose what name to have each variable. If the receiving hook has a specific requirement you can use these names to make the JSON data satisfy it.

Then there are 3 custom parameters where you can provide both name and data. They can be useful for sending API keys to the hook or any other static data that does not depend on the specific user and quiz attempt.

Here is an example JSON data sent to a test webhook at Pipedream:

The variable names come from our webhook settings in WatuPRO. The data comes from the quiz taker. We have requested a company at the beginning of the quiz but decided to not include it in the hook request by simply not entering a variable name. So the data came as shown above.

We strongly recommend checking the Zapier Webhooks guide linked at the beginning of this article to understand better the nature of webhooks. They are super simple and super powerful

 

Launching Database Genius for Contact Form 7: Data Tensai

We have just released a small but very powerful add-on for Contact Form 7 – Data Tensai. Unlike most similar plugins, Data Tensai keeps structured and broken down data by every field you have requested from every contact form. This lets you filter, search, sort, run reports and get charts on quantitative fields. Let’s get into more details:

Table of Contents

  1. Installation
  2. Manage contact forms
  3. View and search entries
  4. Disable forms and fields
  5. User registration

Installationtop

This WordPress plugin is an extension for Contact Form 7. The Contact Form 7 plugin must be installed and activated before you can use this extension.

After downloading the zip file go to your Plugins page inside your WordPress administration dashboard. Click on Add New, then Upload. Install and activate.

Once this is done you’ll see a new link “Manage Data” under your contact forms link:

menu item added to contact form 7


Manage contact formstop

manage your contact forms

When you click on the Manage Data link you will see the contact forms that are available. At the beginning you may see no contact forms. This happens when Data Tensai do not have collected anydata yet. Collecting data starts happening after Data Tensai is installed.

There are two ways to make your Contact Form 7 forms appear here:

  • Someone uses the contact form to send an inquiry.
  • You edit / save the form in Contact Form 7.

For each available form you will see how many entries are recorded, whether the form is enabled to save data and whether it is linked to user registration.


View and search entriestop

view entries

When you follow the link with the number of entries from the Manage Data page you will land on a page with the entries saved from that contact form. As you can see above all the fields (except disabled ones) are visible as table columns. You can sort on each of these columns and see the full details of each message.

filter by any field

A powerful search / filter feature is available for every field. The CSV export button will export a comma delimited file from all entries. If you have applied filters, they will also be applied to the exported data.


Disable forms and fieldstop

disable selected fields

For each form and for each field in each form there is an option to be disabled and not store data. You may use it in case you are not interested in this information, to save DB space, for privacy reasons, and so on.

User Registrationtop

For each contact form you can enable user registration so the contact gets added into your WordPress users database.


Go To Table of Contents

Charts In WatuPRO Reporting Module: Types and Shortcodes

From version 6.5.6 there are 3 new charts in the Reporting module of the quiz and survey plugin WatuPRO.

Quick links: Basic performance chart | Question performance chart |Cumulative poll chart |Charts per question category |All respondents performance | Pie Chart from Correct / Wrong / UnansweredCharts in My Quiz Reports pages

Basic Performance Chart

This is a simple chart showing your points collected vs. the maximum points that you could achieve in a single quiz attempt.  The chart can be used in the quiz final screen but for logged in users you can also use it elsewhere as long as you pass the attribute quiz_id as documented later below.

Chart shortcode: [watupror-performance-chart]

Attributes (all optional):

  • type – “bar” or “pie”. Defaults to bar (and generates a barchart)
  • mode – “js” (default) or “gd”. Used only if type is “pie”. Normally the chart is generated via the gRaphael javascript charting library. However if you plan to include it in email contents or allow PDF download of the final screen (using our PDF bridge), then you should set mode to “gd”. This will use the PHP GD library which must be installed on your server.
  • taking_id – use it if you want to show a chart for a specific quiz attempt. Usually you will display the chart on the final screen so taking_id is based on the current attempt. In this case the attribute should not be passed.
  • quiz_id  – used in case you want to show chart for the latest attempt of the currently logged in user on a specific quiz. Normally (showing chart on the final screen) you will skip this attribute.
  • your_color – the color of the bar or pie slice which displays the points you have collected. Pass a valid hex value like #FF0000 (no short syntax).
  • max_color – the color of the bar or pie slice which displays the maximum points that could be collected on that attempt. Pass a valid hex value like #FF0000 (no short syntax).
  • your_text – the text shown under your points bar or pie slice. Has default value for both chart types.
  • max_text – the text shown under the maximum points bar or pie slice. Has default value for both chart types.
  • bar_width – the width of each bar in pixels. Defaults to 100. Used only if type = “bar”.
  • height – the height of the highest bar in pixels. Defaults to 300. Used only if type = “bar”.
  • radius – the radius of the pie in pixels. Defaults to 100. Used only if type=”pie”.

Let’s see a couple of example usages so you get a better idea of this chart:

barchart without parameters

Shortcode used: [watupror-performance-chart] (all defaults, no parameters)

bar chart with parameters

Shortcode used: [watupror-performance-chart your_color="#f57e42" max_color="#038a05" height="250" bar_width="150" your_text="You got %d points" max_text="From %d max."]
Above is an example of the barchart with custom colors, text, and sizes.

Pie performance chart

Shortcode used: [watupror-performance-chart your_color="#2d5ba6" max_color="#a1a3ad" type="pie" radius=150]

Note that the pie chart is slightly different. The whole 360° represent the maximum points on the quiz. That’s why the two colors actually show points collected and points missed which is made clear by the default texts.

Questions Performance Chart

Similar to the above chart, this one shows your points as a percentage of the maximum points but for every question answered in the quiz.

It’s currently available only as a horizontal bar chart.

Chart shortcode: [watupror-questions-performance-chart]

Attributes (all optional):

  • taking_id – use it if you want to show a chart for a specific quiz attempt. Usually you will display the chart on the final screen so taking_id is based on the current attempt. In this case the attribute should not be passed.
  • quiz_id  – used in case you want to show chart for the latest attempt of the currently logged in user on a specific quiz. Normally (showing chart on the final screen) you will skip this attribute.
  • color – the color of the bars.
  • bar_width – the width of each bar in pixels. Defaults to 30. Note that because the chart is horizontal the “width” of the bar actually means it’s size vertically.
  • height – the height of the highest bar in pixels. Defaults to 300. Note that because the chart is horizontal this actually means the size of the bar horizontally.

Here is an example of this chart using a custom color:

performance per question in a single test attempt

Cumulative Poll Chart

cumulative poll chart, horizontal bars

This is a cumulative chart from everyone’s answers on a single question. By default it loads “correct/incorrect” chart on all question types except on “single answer” and “multiple answer” questions where it loads one bar per each answer.

You can force it to always show correct / incorrect by adding parameter to the shortcode: [watupro-poll question_id="X" mode="correct"].

You can also control the colors used in the chart like this: [watupror-poll question_id="X" correct_color="green" wrong_color="#FF0000"].

The optional parameter user_choice lets you show which is the current user answer when the shortcode is used in the “Final page”. You can pass any text or even HTML code (when using HTML make sure the rich text editor is in Text mode) and it will be shown next to the corresponding answer(s) or correct / incorrect stats. If you pass “CHECK” to the attribute we will generate a checkmark.
Example: [watupror-poll question_id=”X” user_choice=”CHECK”]

By default the shrotcode produces a horizontal bar chart. You can use the parameter “orientation” to make it a vertical one.
Example: [watupror-poll question_id="X" orientation="vertical"]

poll chart, vertical bars

Performance Per Categories

The chart showing user’s performance per question category in a single quiz attempt has several variations – a bar chart, a pie chart, multiple pie charts based on % correct  / % wrong answers in each question category.

Here is a basic example:

pie chart from user's performance per question category

You definitely need to read the whole article about this chart to find all the variations and possibilities it gives.

This same chart can show performance per question categories of a logged in user on all tests. To switch to this mode pass the attribute taking_id=”ALL” to the shortcode.

Everyone’s Performance Per Question Category

Bar chart showing everyone's performance per question category on a quiz

This chart works similar to user’s performance per question category but shows everyone’s. The chart can be used on a random post or page (does not need to be on the quiz final screen).

The shortcode accepts exactly the same parameters as the user category chart but requires the parameter quiz_id. Note that drawing the chart for a quiz that has been completed by tens of thousands of users may require a lot of server memory.
The parameter sum_subcategories=1 will sum up the subcategory performance into the parent categories and will not generate pies for the subcategories.

Here’s example shortcode usage:

[watupror-quiz-cat-chart quiz_id=X from="percent_max_points" colors="green, blue, yellow, black, orange"]

Your vs. Everyone’s Performance Per Question Category

Use the same shortcode as above but pass the parameter “compare=1”. It will produce two bars for each question category – one for you (current taking or passed parameter taking_id) and one for everyone’s performance.

Your vs everyone's result per category

With this shortcode you need to pass only two colors in the “colors” parameter. The color of your bar and the color of everyone’s bar.

Here is the shortcode that produced the above chart:

[watupror-quiz-cat-chart quiz_id=X from="percent_max_points" colors="crimson, blue" compare="1" width="30" orientation="horizontal"]

Available from WatuPRO 6.5.8.6.

Pie Chart from Correct / Wrong / Unanswered

This is a simple chart based on a single quiz attempt. It shares the same watupror-pie-chart shortcode which generates the performance per category chart above but with parrameter from=”questions”.

Example usage: [watupror-pie-chart from="questions" radius="160"]

Pie chart based on correct / wrong / unanswered questions

Charts Inside “My Quiz Reports” Page

Additionally the Reporting module provides several pages that contain detailed reports for each  registered test taker. Each user can see it’s own performance reports and charts. The admin can see everyone’s (see how).

These pages contain a couple of charts too:

charts from the user overview page

These charts are showing all time overview of taken tests per test category and questions answered per question category.

Skills / categories chart

The above simple bar chart shows proficiency per skill / question category from the Skills report page. It can be horizontal and limited further per test and filtered for desired proficiency level.

history of taken tests bar chart

The history bar chart shows the number of quizzes attempted in total for each month of the current year.