kungfupanda
Scholar

Repeating Section push data to new rows

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?

0 Kudos
Reply
4 Replies
Garrett
Communicator

Re: Repeating Section push data to new rows

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. 

Garrett_0-1656542858252.png

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...

 

0 Kudos
Reply
kungfupanda
Scholar

Re: Repeating Section push data to new rows

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?

0 Kudos
Reply
Garrett
Communicator

Re: Repeating Section push data to new rows

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

Garrett_0-1656642850826.png

 

Sample Responsive Form

Garrett_1-1656643080593.png

 

0 Kudos
Reply
kungfupanda
Scholar

Re: Repeating Section push data to new rows

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.

0 Kudos
Reply