Repeating section doesn't show results in list view

You are correct. I am very new to this - Nintex Forms (been working with it about a month) and repeating sections (just started this week). The article you included is intriguing, but, unfortunately not enough for a beginner. I need the configuration behind the nodes. In simple terms it sounds like we want to tell Nintex to query the repeating section and populate the fields but I haven't used any of the actions in the workflow described in the article to even know where to start.

Thank you so much I really appreciate your help. What is a UDA? Do you happen to have an example I could copy and then ask you specific questions?

Thank you

No problemo, just let us know if you need more help when you're back.

Hello ‌! I can't believe it's been 6 weeks since I've been able to get back to this but some other projects took precedence. My system administrator enabled my profile to be able to create UDAs. I am ready when you are you and really appreciate your help with this.

Thank you ‌

Hello Jennifer!  I was thinking of you yesterday, actually. Unfortunately, my internet is not going to be hooked up until Monday, but I will see if I can attach to some internet during my trip to Kansas City. (Flying tomorrow!)

In the mean time, though, since it's been a while, can you review the previous posts and the tutorials, and let me know which items you're able to work up to?

We will need to determine what makes the most sense for your need, as well - whether it's to create a header item with the individual states, (so if you have 3 states, you'll have 3 rows).

What I'd like to see is the section in your form where users would enter this - from what you've shown above, it doesn't make too much sense to me for the states to be the only repeating section items -- that would usually just be a Multiple Choice control. So i am assuming there is more to it! Am I right?

Basically we need to figure out the end goal. If it's just that you want to see "California; Kentucky; Idaho" there, then you'd just want a Multi Choice. If you wanted to see California alongside all the health plan data for california that was entered in the section, then we'll want to create a workflow that will generate some new rows for us.

Hello ‌! I was able to persuade my leadership to go a direction that is a little easier and out of box than what we are trying to do. I appreciate your willingness to help. We may still want to try this method but it will be way in the future if we do.

Alright - glad to know you've found a way that will work for you!

So, in reply to your doc (if down the road you need it), my understanding is:

Job Request Form

So let's say - for the sake of my lack of knowledge - the job request is "Update to Windows 10"

They'd select that.

And then, in the repeating section, they would select the Health Plan & Cost Center.

In your form, this would then be a 1:many relationship. Ie, "Update to Windows 10" for "Health Plan: 10" & "Cost Center: DC"  AND "Health Plan: 11" & "Cost Center: WA". It's much easier for your user (and for data integrity) to have your user enter in this way.

So our goal would be to create NEW list items (probably in another list) based on this one. So we have a list where our forms are submitted, a processing workflow, and then a 1:1 list.

That way, after processing in the new list, it looks like:

Row 1: Update to Windows 10 - Health Plan 10 - Cost Center: DC

Row 2: Update to Windows 10 - Health Plan 11 - Cost Center: WA

(and of course you copy over whatever other header data you'd need - created by, created date, etc)

====

So how do we get to that point?

Now that you have the UDA installed, you're on your way!

The important thing to know is about FormData.

FormData is within all Nintex Forms and encompasses all of the data on the form, regardless of whether it is in a repeating section or not.

Since your repeating section has a name (you need to name your repeating section, btw! Make sure to select it and call it something that makes sense - ie, RepSecCostCenters)

So let's look at the UDA and understand the fields:

textFormData: Automatically created by the form, you can use "Value" and input the Item Property "Form Data" - as mentioned, it comes pre-made with all Nintex Forms, so it's there for you!

textRepeatingSectionName: Here, we just type in the name of our repeating section. No need to get an item property or anything like that, you can just type it in.

numRepeatingSectionChildren:  For this, create a number variable. I usually call mine "numItems" or "numChildren" but you'll also want to be more specific if you have multiple repeating sections.

textDecodedRepeatingSection: What the UDA does for us is get rid of all the weird code, count the items, and put it into a format that the XML query thing can read. Thanks, UDA! So for this we just need a variable of the multiple lines of text type.

====

What next!? Now we get the data OUT of the XML - which is easier than it sounds, but requires some set-up.

Variables needed:

1) One for each of the pieces of data in your repeating section. For example, txtCostCenter and txtHealthPlan

2) A number variable called "numIndex" and set its' default # to "1" - this is how we tell the workflow which repeating section item we want to pick up.

The workflow:

1) Drop a LOOP into your workflow.

2) For the LOOP LOGIC,

It should look like that. What you're telling it is, "each time you do a loop, make sure that we are going through one of the repeating section items - if we aren't, then, stop!"

3) Query that XML! User the Query XML action, and set it up like this:

INTERMISSION ... I have to go for a walk now and will finish this later.