I have requirement where i have fixed set of questionnaire created using Nintex form. What i need is to export the complete dump once user submits the form. Number of questions is fixed to 100.
Please note: I am not looking to connect each and every field in Nintex form to a SharePoint list > and export it to excel. This will require large number of list columns and will complicate the things.
My form format is something like below:
|Question||Select Yes / No||Comment|
|Sample question 1||Choose Yes/No||Enter your comment|
|Sample question 2||Choose Yes/No||Enter your comment|
Once form is submitted with all 100 questions answered, i wish to save the form data into excel or csv like:
Sample question 1,Yes,Comment 1
Sample question 2,No,Comment 2
Please suggest an appropriate solution if i am not thinking in the right direction.
Thank you in advance.
Solved! Go to Solution.
You have to options for this.
1. You can use a Nintex site workflow to query the list, pull the information into a few collections and design an excel output using Nintex DocGen. This is clean and allows you control over the layout and design.
2. You can simply export the SharePoint list to excel which is a standard for SharePoint and do whatever you want with the data and format from there.
I have a form with ~ 30 fields. I have all the fields on the form connected to a field. When I export to excel I do not get all the information i have input in each field. I made sure all the columns are selected to show. I have noticed that even though I "apply" show all columns the next time I go back in they are no longer selected. How can i get all of my data to come out in excel export ?