molgenis
Search…
Questionnaires

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 creating 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).