Exporting the variable values to a CSV/XLS file

[Anonymous]

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?

[Gysbert_Wassenaar]

Perhaps this blog post helps: Loading Data into Input Boxes

[prashantbaste]

Hello Kaushik

Please find attached QVW, might be helpful for you.

Let me know if it is useful for you.

--

Regards,

Prashant P Baste

[#4]

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