Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this survey in my dashboard.
When the user selects Yes/No for a question and clicks Submit, the corresponding variables I created (For Example v1Yes and v1No for the 1st question) changes from 0 to 1. I also created a variable for calculating how many Yes/No will be recorded for each question.
Now, everytime a response is recorded, I need to export the response to an external file (CSV/XLS)
Now the survey has been done twice by two different users. The file should record responses something like this
Question | Yes | No |
---|---|---|
Do you think this tool is useful? | 0 | 1 |
Are you comfortable working on this tool? | 1 | 0 |
Do you think this tool is useful? | 1 | 0 |
Are you comfortable working on this tool? | 1 | 0 |
Is there a way to export the variables values like this?
Perhaps this blog post helps: Loading Data into Input Boxes
Hello Kaushik
Please find attached QVW, might be helpful for you.
Let me know if it is useful for you.
--
Regards,
Prashant P Baste
This is great Prashant!
Do you think there is a way were if the same user submit the survey twice, the second submission overwrites the first submission? I am taking the field 'User' to be the key field of the table, and thus has to be unqiue within that table.
Thanks again for this excellent QVW example