Skip to main content

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?

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-processing-parameter/td-p/219094



 


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?


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





 


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.


Reply