In this article we will explain how you should prepare an Excel file before importing it.
In the annex at bottom of this article, you will find a sample file that you can use to make your own questionnaire. Start by downloading the file to your computer and then opening the file.
Name and description of the survey
In cell A4 & A5, respectively, you can enter the title and description of the questionnaire. Enter an appropriate name and description here. The description can be as long as you want, as long as all the text is in cell A5.
Once in Cubigo the title and description will be formatted as follows:
Starting at row 9 in the Excel file, every line is one question in the questionnaire. By filling in this line from left to right, all the options that apply to the questions will appear automatically. A green cell should be completed. A red cell may be ignored as it does not apply to that question. Yellow fields are not mandatory and are not necessarily shown.
First question types: "Simple question"
If you select cell A9 a pop-up window will appear. Select "Simple":
In the next cell (B9) you can specify whether the question is mandatory or not.
Then in the next cell (C9) you need to fill in the description of the question. In Cubigo it would look as follows:
(cell D9) can contain an optional explanation to your question. However, this will only be visible as long as you don't select the option IsSingleLine in cell (M9).
The question is as follows:
Second question type: "Boolean"
Boolean means "yes or no". That means, the question can only be answered with "Yes" or "No".
Again, the same options for the description and remarks apply as in the "Simple question."
In field (H10) however, the option HasFreeText will be shown. By choosing yes here, a free text field will appear below the yes/no question where you can ask for additional information.
In the fields (I10) and (J10) you can respectively enter the "note" or "suggestion". In Cubigo it would look as follows:
Third question type "single selection"
The third question type is an extension of a simple "after" or "No" question. "Single selection" question allows the user to make one choice out of a predetermined list. For this, in cell (A11), select "single selection":
Columns B, C, D & E have been explained previously.
In cell (F11) we need to define the values to be selected. The values are separated by the ";" sign. In the example file this is shown as [One;two;three;four;five]. In Cubigo it would look as follows:
As with the "Boolean" question a prompt appears in field (H11) with the option HasFreeText. By filling in yes here, there will appear a free text field below the yes/no question that may be used to ask for additional information.
By setting the value IsDropdown field (N11) to yes, the list with choices is displayed as a so-called drop-down menu. In Cubigo it would look as follows:
4th question type: "Multi selection"
The fourth question type is a variant like the previous one.
The difference is that there are multiple answers possible in this case. For this reason, the "dropdown menu" playback is not possible. It is possible to limit the maximum number of selected options by filling cell (L12) with an amount of MaxChoices . In Cubigo it would look as follows:
Fifth question type "Valuation"
This question type allows you to assign a queue to ask a series of predetermined values.
In the Options cell (F13), you need to select the range of values. In this example, this is One;two;three;four;five In the cell next to it, SubQuestions (G13) you can specify the questions. The values are separated by the ";" sign. In Cubigo it would look as follows:
The sixth question type "Persona"
This type of question is designed to easily ask for Name, Address & Location.
Again, the same options for the description and explanation are considered in previously defined questions. There are no standard options. In Cubigo this question is as follows:
Seventh question type: "Spacer"
This is the most basic question of all, because it's not even a question. The "Spacer" is intended as a visual tool to insert something between an explanation or create a break between series of questions. The only values that can be filled are cell (D15) and (E15) for the description and explanation. In Cubigo this question is shown as follows:
Eight question type "TwoDimensionalText"
This question is similar to the "Valuation" question in the sense that it is a matrix of questions. The distinction is that, in this case, the user can enter a value in every "cel". The other options are similar to the "Valuation" question.
In Cubigo this question is as follows:
How to proceed?
When you have completed all your questions, refer to the article How do I add a Questionnaire? where we explain how to import the file.
Before you share the questionnaire with other users, you can preview the questionnaire yourself by pressing the Start button.
If the questionnaire contains imperfections, you can always delete and re-import it. However, once it is sent you can no longer change anything.
I hope this guide has proved to be useful. We are always looking for ways to improve our product or the way you experience it. If you have any questions or suggestions, do not hesitate to contact us via the cube Questions