A Matrix Question allows you to effectively ask respondents more than one question in a single, compact field, allowing you to keep similar questions together instead of spreading out across multiple, distinct fields or pages.

It's just as easy to get started with our matrix question as it is any of our other questions.

Setting it up

Using slash commands

1. From the form editor, select a blank line outside any questions or question groups.
2. Type /matrix and click the entry for the "Matrix" question.

Without using slash commands

1. From the form editor, select a blank line outside any questions or question groups.
2. Click "Add Question" in the options that appear to the left of the line.
3. Click the type (default is text) and change it to matrix.

Configuration

In either case, navigate to the Question Panel and customize the column and row names to your liking.

Optionally, you may allow more than one response per row, changing the radio buttons into checkboxes.

Example use cases

Likert scale grid

Availability

Splitting Results on Google Sheets

When using Matrix field results for reporting capabilities, our Google Sheets Direct Integration is typically utilized for this purpose. To display your Matrix results in their own columns, we can utilize the Google Sheets SPLIT() function in the following example.

Please Note: References to key must be replaced with valid pre-filling keys on your form for the example formula to work correctly.

=SPLIT("{{ key.rows.1 }}, {{ key.rows.2 }}, {{ key.rows.3 }}", ",")

This example should be placed within your Google Sheets Direct Integration like so:

These are just a couple of possibilities. Play around with it, realize your use cases, and engage with your respondents more efficiently.

If you ever need any help or have any feedback, let us know at support@paperform.co.