How do you create a Questionnaire that a user can input answers to within Qlik?

[RWilliams92]

I'm wanting to create a questionnaire, made up of 8 questions that is sent out to around 80 people, within Qlik. All of these are simple 'Yes or No' questions. I need to have these users select their answers, submit them and then I can gather their responses to report on in a table.

I understand I need to create variables for each of these in order to be able to store the answers? Something like the below as a start point (ScenarioDate being the timestamp):

'$(vNowNum)' as ScenarioDate,
'$(vQuestion1)' as Question1,
'$(vQuestion2)' as Question2,
'$(vQuestion3)' as Question3,
'$(vQuestion4)' as Question4,
'$(vQuestion5)' as Question5,
'$(vQuestion6)' as Question6,
'$(vQuestion7)' as Question7,
'$(vQuestion8)' as Question8
AutoGenerate(10);

How would I go about building this within the data loader? Thanks in advance

Ryan

[JordyWegman]

Hi Ryan,

What you should do:

1. Create a widget with an iFrame
2. Set in this iFrame a Google Form
3. Get the Google Doc connector to connect https://www.youtube.com/watch?v=RalaPTmYBCM
4. Get a script where you load your Google Doc excel file every minute

Jordy

Climber