Editing of matrix cells

Edit matrix screen look like this:

Changing matrix size

You can at any time increase/descrease number for columns and rows in the matrix.

Moving a cell

You can move position of the cell by one cell. Hold the mouse over the cell a couple of seconds and a little move cell window will appear. Click on the arrow to move the cell. NOTE: cells can be moved only within the same group type. For example you can't move cell of type Radio to a group of Checkboxes.

Changing a cell.

Click on the cell you want to change. A new window will open allowing you to enter the cell details. You can name the cell for better identification in the reports. The cell identifier is optional. You can also set background of the cell and a tooltip. The tooltip can have multiple lines and include html elements. Cells of type text, numeric, dropdown and checkbox can also have data variable names attached to them.

There can be 8 types of matrix cells:

  1. Empty cell Empty cell can be used when the cell does not need to carry any visible element. Most of the cells are empty when you first create a matrix question. Click on the Empty cell-button and set the type from the dialog window that appear. Empty cells do not have an identifier and background color.

  2. Text Cell of type text allows respondents to enter any text in the field. "Field size" is the visible length of the fields, in characters.

    Validation: Validate/check the answer from the respondent. It can be used to demand a specific type or length of answer from the respondent and set the appropriate error message if these requirements are not met.

  3. Numeric Cell of type numeric restricting the answer to a number only. Select this type if you need calculations on the report (type text will only produce a comment listing). Numeric types available are integer or decimal.

    Formula: If a formula is entered for a numeric cell, a calculation will be performed as the respondent enters numeric values in other cells in a matrix question, which can either be the same question, or another matrix question within the survey. The resulting value from the calculation will be placed in the cell containing the formula. The result will also be saved as part of the survey response, as if the respondent typed in the answer for the cell. The cell containing the formula will not be editable by the respondent; it will be a calculation-only field.

    A formula supports basic arithmetic calculations (+, -, * and /), as well as sum() and avg() functions. Sums and averages are written in the form "sum(A4:A7)" and "avg(B2:C24)".

    In a formula, you refer to other cells in a similar manner as spreadsheets (MS Excel, OpenOffice Calc, etc). The values from these cells will be included in the calculation of the formula. A cell is referenced as A1, A2, B1 etc., if it is within the same matrix question where the cell containing the formula lies, or as Q2!A1, Q2!A2, Q2!B1 etc., if it is from another matrix question. If the cell reference is Q2!A1, the cell you are referencing is question 2, column A, row 1. You can also include numbers directly in the formula. The starting and ending cells in the sum() and avg() functions should be from the same question.

    Formula examples:

            A7 + B1 + B2
            Q2!A3 + Q6!B5 * Q8!E7
            Q6!C3 + sum(C4:C10) + avg(Q8!D5:Q8!E10)
            avg(A1:A19) + 50
            C7 + Q2!D20/sum(Q6!F2:Q6!F10) - (20*Q8!G10)

    Circular references are not allowed. For instance, in cell A1, you can not write a formula that includes A1 in it. The circularity is also checked across multiple questions, cells and formulas. Another example, is Q4!A1 contains formula "A2+Q6!B2". Then cell Q6!B2 contains the formula "sum(Q4!A1:Q4!B6)". This is also a circular reference, and is invalid.

    NOTE: Use numeric type only for numbers you want statistic analysis for. For input like telephone numbers, credit cards and country zip codes, text type is recommended.

    Validation: Use this to set restrictions for answers and error messages for invalid numbers, required input, and min/max values.

  4. Dropdown Cell of type dropdown list are exactly the same as the usual dropdown list for the question types, except it can only have a single selection. You can either create a dropdown list directly, or create and load from the bank if you are to use it again later. See dropdown list question for more details.

  5. Checkbox. The checkbox simply inserts a checkbox for your respondents to check. This is a true/false type answer.

  6. Radio button. Radio buttons can only be used/defined if it is grouped with other cells. See Cell groups below.

  7. Label. Text to be displayed in the cell.

  8. Image. Set image to be displayed in the cell. See the section called “Images”