Questionnaires
MOLGENIS offers a questionnaire module which can present a questionnaire to users. These questionnaires are defined in our EMX format. Each questionnaire can be filled in once, and generates one row of data in a table used to collect the questionnaires that where submitted.
Minimal example
download simple questionnaire example. Import this xlsx file via the standard import wizard
The above example showcases a very simple questionnaire. It asks for your age, and if you are 18 or older the question "Do you have a drivers license" will appear.
To start creating your own questionnaire, you will need to have few fields specifically defined in your EMX in order for it to work
EMX sheets
'entities' sheet
| name | description | extends | label |
|---|---|---|---|
| questionnaire name | questionnaire description | sys_Questionnaire | questionnaire label |
The questionnaire has to extend the sys_Questionnaire table. This is an indicator for MOLGENIS to show this questionnaire in the list of all questionnaires.
Visible expressions
The cool feature in the questionnaire module is that you can show certain questions based on the answer given on other questions. You do this by using the Javascript Magma syntax to create an expression inside the visible column (See driverslicence in the simple questionnaire example).
Questionnaire timestamp on submit
MOLGENIS will automatically add a submit date for you when you submit a questionnaire. So keep in mind that you do not have to manually add a question relating to submit dates.
Using Questionnaire data
You can access the questionnaire results through the data explorer. Go to the data explorer and look for the (in our case) Simple Questionnaire table.
This table contains the answers for all the users that filled in the questionnaire.
Configure PDF report
After submitting a questionnaire users can download a PDF report of their data. All questions and answers that were provided will be presented nicely formatted in this report.
This PDF report has an optional intro text and logo. To provide these, an extra attribute, with the name "report_header" should be added to the questionnaire. This attribute
should be of datatype "xref" with as refEntity a table that specifies the "intro" and "logo". To have the same logo and intro for each participant, use the defaultValue option to
specify the data row in the config table. Example structure:
Attributes:
| name | entity | dataType | idAttribute | labelAttribute | defaultValue | refEntity | label | partOfAttribute |
|---|---|---|---|---|---|---|---|---|
| id | demo_report_header | string | TRUE | TRUE | ||||
| intro-en | demo_report_header | text | FALSE | FALSE | ||||
| intro-nl | demo_report_header | text | FALSE | FALSE | ||||
| intro-fr | demo_report_header | text | FALSE | FALSE | ||||
| intro-de | demo_report_header | text | FALSE | FALSE | ||||
| intro-es | demo_report_header | text | FALSE | FALSE | ||||
| intro-it | demo_report_header | text | FALSE | FALSE | ||||
| intro-pt | demo_report_header | text | FALSE | FALSE | ||||
| logo | demo_report_header | text | FALSE | FALSE | ||||
| id | demo_questionnaire | string | AUTO | FALSE | ||||
| report_header | demo_questionnaire | xref | FALSE | FALSE | demo_report_header | |||
| questions | demo_questionnaire | compound | FALSE | FALSE | ||||
| question1 | demo_questionnaire | bool | FALSE | FALSE | Do you think this questionnaire is quite small? | questions |
The intro should be some text information about the PDF report. The logo should be a data URL (and therefore is of type text).