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

Last updated