Repeating Section push data to new rows

[kungfupanda]

We are on SharePoint 2013 OnPrem.

We have a user asking if it's possible for a Nintex Form to have a repeating section, which each repeating section would insert into a new list row.

For example, if they fill out a Nintex form and have 3 repeating sections, 3 new rows get created in this list. Is this possible?

[Garrett]

Hi @kungfupanda 

Yes, it should be possible but not practical to create new list items in the same list.

Perhaps you meant to create new list items but in another list?

Why not Practical?

1. Data Structure Storage inefficiency - Ask your DB Admin or google 1NF, 2NF, 3NF 

The light yellow cell are empty spaces. 

2. Do you trigger a workflow to run when a new item is created in the list?

So when you add a new item, you will trigger a workflow to run. You may need to put in place additional conditions when you run a workflow. (Run when TITLE contains "Invoice")

What you need to do?

1. You need to Query the Repeating Data XML.

2. Extract each row, Process the row to extract the fields and save the value to the list (recommend to save to another list) 

How to extract data from repeating section - Refer here https://community.nintex.com/t5/Nintex-for-Office-365-Forum/Query-XML-An-exception-occurred-while-pr...

[kungfupanda]

Hi!

We want to keep all the information in the same list.

The idea is to allow users to do a submittal for 1 item or bulk submittal (the need for repeating section) as all fields could be different/unique.

Per invoice example below:

• Invoice 1 may contain 1 item
• Invoice 2 may contain 2 items
• Invoice 3 could be 1 item
• Invoice 4 could be 5 items

Embracing the Datasheet view would be better option?

[Garrett]

Hi

Using the invoice example below:

• Invoice 1 may contain 1 item
• Invoice 2 may contain 2 items
• Invoice 3 could be 1 item
• Invoice 4 could be 5 items

Your SharePoint List has 4 items - Invoice 1-4.

Each Invoice form can have a Repeating Section to store the item(s) details.

Users can add or remove item(s) on the form

Sample Classic Form

Sample Responsive Form

[kungfupanda]

Thank you for the reply.

We'll need to verify with the customer if they plan on entering more than 1 invoice per form or if it's acceptable to enter a single invoice number on each submittal.