I have a form built in Nintex Forms 2013 for managing Orders.
The form contains regular fields along with Repeating Tables.
The requiement needed is to be able to produce a kind of "Report" as a text document - Word or Excel Form (using MS office capabilities), containing all the Order's data (including the repeating tables).
Input: The form is filled completely by the user and saved to the Orders list (through Nintex Forms).
Output needed: Word document (or Excel form) with the Order's data copied automatically from a form-item in the Orders list.
One idea i have is using the Quick Parts in Word to create a document template with all the data fields (copied from the Order's item). The problem is with creating the repeating data table.
What other ways are there for implementing an automatic solution for the output?
Can be using code (Macro/VB), XML, a third-party tool that can interface to Nintex Forms items etc.
You can create a workflow to insert the child data (repeating table) to a list when it is submitted. You can store the repeating table data to a multiine column in the list. It is saved as XML . You can extract all the data from this xml using the workflow control Query XML.
You can export the list data having the xml to excel and use =FILTERXML(xml,xpath) to extract the data.
Although the part of which i'm dealing with is how to copy/write the child data into a Word document template.