cancel
Showing results for 
Search instead for 
Did you mean: 
daniel
Nintex Newbie

Producing a text document containing Repeating Data Table inputted from a Nintex Form item

Hi,

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.

Any ideas?

Thanks,

Daniel

Labels: (2)
0 Kudos
Reply
2 Replies
sojanm
Nintex Newbie

Re: Producing a text document containing Repeating Data Table inputted from a Nintex Form item

Hi Daneil,

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.

OR 

You can export the list data having the xml to excel and use =FILTERXML(xml,xpath) to extract the data.

0 Kudos
Reply
daniel
Nintex Newbie

Re: Producing a text document containing Repeating Data Table inputted from a Nintex Form item

That's right.

Although the part of which i'm dealing with is how to copy/write the child data into a Word document template.

Thanks anyway

Reply