Novice to SharePoint and Nintex. One of the main reasons we purchased Nintex was the ability to be able to create repeating sections on forms. I was able to get our form created with the repeating section then our test group fills in the form and no data in those section are being displayed in the columns in the List View. WHAT? Kind of an important detail.
I did some searching here, but not sure which is the best option and some of the versions are dated and I am not sure if they will work for us.
We are using SharePoint 2016 on premise and we have Nintex for SharePoint 2016.
I found the article on Nintex Repeating Section Data but unfortnately we are unable to deploy unknown wsp files into our SharePoint environment so I have to cross that one of the list. I found another one by Osama Mourad using JSLink, but the article is dated from 2016. Is that the best option for my situation?
So can anyone point a newbie to the best option to display data from repeating sections on a Nintex form on a List view? I am not a developer so it has to be easy for me to deploy and get my project back on track.
Thank you very much!!
Hi, I solved this using Vidim's UDA.
It extracts the data out of a repeating section allowing you to send it via email or update into a single column.
No problem. First off we need to install the UDA. Download it form the link above. This is basically a core workflow with paramaters that once uploaded, becomes available as an 'action' within another workflow. It saves you redoing a complicated section. Install it using the admin section of nintex on your central admin site. Ideally at collection level.
I've attached my workflow that uses the UDA. It simply takes fields from my repeating section, loops through each row in the repeating section, adds them to a collection and then updates another field with the summarized rows.
Actions to configure in the workflow...
Make sure your repeating section has a name in the form and it matches the textrepeatingsectionname as shown below.
Depending on the number of fields in your repeating section, you will need to add an output for each as shown below. Simply replace the highlighted bits below with your field names. Each needs it's own variable.
Here we are putting the fields together for each row. In my example I'm creating a url that you can click on but you could simply have a string of fields. Ie. OutPutVariable1 : OutPutVariable2 : OutPutVariable3.
Now we update a summary field in your list. Simply replace the Linksummary field in my example with your multiple line field on your list. HTML enabled. There is also an email action that also pops out the summarized rows as well.
This is how it looks from the form view....
Into a summarized field for that item...
I hope that gets you close to what you're after.
Also here is a solution for extracting data from a repeating section into excel.
I greatly appreciate you trying to guide me with doing this. Nothing like diving into the deep end. We didn't really get this product for Workflow so I am having to catch up on that piece as well. I managed to get the UDA installed in SharePoint and create a new workflow for my list. When I go to configure the Output Parameters drop downs are empty.
Not sure why?
Instead of using UDA:
Let me know if this works for you.