llyehock
Scholar

How to transfer repeating values to MS word format tabular format

Jump to solution

I like to find out the easiest way to populate the risk matrix in MS word format from a repeating groups within Nintex form as shown below

20220617_153129.jpg

Into this risk matrix in ms word format as shown below

Screenshot_20220617-152609_Drive.jpg

0 Kudos
Reply
3 Replies
Garrett
Contributor

Re: How to transfer repeating values to MS word format tabular format

Jump to solution

Hi @llyehock 

 

Let confirm this.

1.  The Nintex Form image is the all the data fields in a Repeating Row. Yes (from the image)

2.  One row in the Word Doc has all the 3 sections - Hazard Identification, Risk Evaluation and Risk control. Yes (from Word image)

3. Can I assume you know the basics of Document Generation (DocGen)? Creating Template, Using Nintex Document Tagger. Yes?

Read up on DocGen action - https://help.nintex.com/en-US/nwc/Content/Designer/Actions/GenerateDocument.htm (I believe the Tagging portion is still the same) 

 

a. First add a XML Query action to query the Repeating section and save the values into a collection variable.

b. Add a DocGen action. Open the Table Data. Set Repeating Format as ROW. Set the Table Columns source (which is the collection variable)

c. Tag the Word Template using the Nintex Document Tagger. You will need to have the Word Template and the Document Tagger side-by-side.

d. At the start of the Row use the <<COLLECTION_Start>>

e. Place the other data fields. One data field into one column. Refer to image below. Save the Word template.

f. Run and Test it out. You need to verify that all the data is in the right place.

Garrett_0-1655476157247.png

Note: I abbreviated the fieldnames. 

 

This is just a general guide. If you are facing any issues, just post them here.

 

Reply
llyehock
Scholar

Re: How to transfer repeating values to MS word format tabular format

Jump to solution

Hi @Garrett , 

our platform do not have internet access so I do not have Generate Doc functionalities. I noted that version Nitex form 7.3 has landscape option, so I am hoping to rearrange the form to landscape mode to mirror the Word format, assume this is the easiest option. Or is there any latest version that can better support landscape mode?

0 Kudos
Reply
Garrett
Contributor

Re: How to transfer repeating values to MS word format tabular format

Jump to solution

Hi @llyehock 

 

Not certain of I can be of assistance on this matter..

 

 

0 Kudos
Reply