I'm having an issue with a task form which was modified to look exactly like the list item form.
The list item form has a repeating section that includes a date, few number fields and text fields. I've noticed that the number and text fields show the associated data in the task form. But the date field has been inconsistent with keeping the date in the task form. sometimes it displays one of two dates on two rows of the repeating section, sometimes it doesn't display any. I've checked the version of the form, and the users do submit the dates as they are required fields. The only pattern I can see is that those dates gets lost when the task is assigned to the manager to approve. when they open the task form (that looks like the original form) it may have some missing dates - and they are read only, and they are able to approve. then when the form goes back to the final approval, those dates were lost and asks the user to re-enter, while they were already there in the first version, when the item was created.
Note that: The repeating section columns are not linked. Same for the number/text fields which do come across on the task form with no issues.
Any idea what's happening?!
what's the environment where this happen in?
do managers approve from desktop or from nintex mobile?
recently nintex mobile had a bug that cleared/reset all the dates on form to 1.1.1970
If you connect and store the original repeating section data in a List column, you can connect the task form repeating section to the same List column and reference the original repeating section data. You just need to name the fields the same as you named the original form fields . This should ensure that any original data is presented to the Approver.
and do you lose data when they do approve from both?
for an item for which data are missing in form, can you go to list view and grab and examine repeating section's XML whether missing data are there or not?
Thanks Mark. Do you connect the repeating section itself, or each column within the repeating section? how does the data gets saved with multiple dates? do you connect them with the same type of list column or a multiple line of text?! I'm also trying to extract the data from that repeating section for some integration points...
it is not possible to connect single repeating section controls to list fields.
you have to (should) connect repeating section as a whole connect to list field.
list field has to be of type multiline plain text.
As Marian has indicated, the whole repeating section needs to be connected to a multiline plain text column. From there you can then connect the column to any task forms that require the contained data - as long as you get the individual repeating section control names correct. You can also extract any specific data out of those controls using the Query XML and even update the data using the Update XML.
Using Query XML, you define the input as the new repeating section column (you can also use the Form Data reference always available from the Item properties) and using your choice of XPATH or XSLT, define the data that you want to extract. Example below pulls out several field inside a loop using an index number aligned with the row count of the repeating section. it can be a bit tricky, but if you paste some sample data into the XML field instead of the reference you can test the outcomes using the "Run Now" feature - very handy. Of course you can't do a straight update of any other columns in your list as the repeating section can have multiple rows - so you need to be aware of that.