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.
Seems like there is a duplicate question for the same, I gave detailed answer here Show Repeating Section as table in List View
Attaching workflow and form for reference .
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.
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.
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.