I created a Nintex Form that has a repeating section on a SharePoint list with existing records. I noticed that the repeating section always goes missing after I fill in the fields of the repeating section and hit submit. And this problem only occurs to the existing records.
For new entries, the repeating section is visible as it should be even after filling them out.
Hi @rtics
Is your issue similar to this?
https://community.nintex.com/t5/Nintex-for-SharePoint-Forum/Repeating-Section-Lost-Data/td-p/217607
What's the value in the SP column for existing item (don't use the form as once you click submit, you might change the column value) and for newly created items?
Hi, Garrett.
My case is more of a form issue. The repeating section was just recently added to the form as well as the column (where the repeating section is connected to) to the list.
The column is empty for the existing items because it was just created. For the newly created items, values in that column are in xml format. Just wanted to add that when I try to fill in the repeating section of an existing item, I can see that values are stored in the column in xml format as well. So there is definitely no data issue here.
Please note that visible property of the repeating section is set to Yes. So I'm not sure why it becomes hidden for existing records once filled out.
Yes, there should be data in the SP column.
However, what I wanted to check is whether the XML Data Structure is still the same?
You will need to get the XML raw value, use a XML beautifier and compare the XML side-by-side.
Let's say that List ID 1-99 are the existing items. ID 100 and over are for the newly created list.
Your form needs to have 2 Repeating Sections. You need to maintain the "old" Repeating Section for the existing list items. You will create a "new" Repeating Section for new items.
Set a Form Rule that will switch between the "old" and "new" Repeating Section. Only display 1 Repeating Section at a time. You should be able to display the Repeating Data in both the existing items and new items .
Cheers
Hi Garrett, Apologies but I am a little confused. What should be the data of the column for existing records if both repeating section and column did not exist at that time?
I just checked the xml data of both old and new records. And they look pretty much the same...
XML of old record once I filled out the repeating section:
<?xml version="1.0" encoding="UTF-8"?> <RepeaterData> <Version>1.0</Version> <Items> <Item> <_baf086501432fe421e3cc3383af93436 type="System.String">1</_baf086501432fe421e3cc3383af93436> <_9f68db04ac887b4372ce9cbe046a4255 type="System.String">4</_9f68db04ac887b4372ce9cbe046a4255> <_6acaa3186d53a25c802499b3a144d2e4 type="System.Int64">2</_6acaa3186d53a25c802499b3a144d2e4> <_59817a7d3d2e9d844243b48481bacb3a type="System.String" /> <_b853e14613bc5de9cc3f67ec26a12e62 type="System.String" /> <_c0696dd4631d8e37f5a8dd689a9882f5 type="System.String" /> <_11499df2e2a0d06ea8ca39a9414c529e type="System.String">220022303258103</_11499df2e2a0d06ea8ca39a9414c529e> </Item> <Item> <_baf086501432fe421e3cc3383af93436 type="System.String">46</_baf086501432fe421e3cc3383af93436> <_9f68db04ac887b4372ce9cbe046a4255 type="System.String">47</_9f68db04ac887b4372ce9cbe046a4255> <_6acaa3186d53a25c802499b3a144d2e4 type="System.Int64">3</_6acaa3186d53a25c802499b3a144d2e4> <_59817a7d3d2e9d844243b48481bacb3a type="System.String" /> <_b853e14613bc5de9cc3f67ec26a12e62 type="System.String" /> <_c0696dd4631d8e37f5a8dd689a9882f5 type="System.String" /> <_11499df2e2a0d06ea8ca39a9414c529e type="System.String">220022303258146</_11499df2e2a0d06ea8ca39a9414c529e> </Item> </Items> </RepeaterData>
XML of newly created entry:
<?xml version="1.0" encoding="UTF-8"?> <RepeaterData> <Version>1.0</Version> <Items> <Item> <_baf086501432fe421e3cc3383af93436 type="System.String">1</_baf086501432fe421e3cc3383af93436> <_9f68db04ac887b4372ce9cbe046a4255 type="System.String">1</_9f68db04ac887b4372ce9cbe046a4255> <_6acaa3186d53a25c802499b3a144d2e4 type="System.Int64">2</_6acaa3186d53a25c802499b3a144d2e4> <_59817a7d3d2e9d844243b48481bacb3a type="System.String" /> <_b853e14613bc5de9cc3f67ec26a12e62 type="System.String" /> <_c0696dd4631d8e37f5a8dd689a9882f5 type="System.String" /> <_11499df2e2a0d06ea8ca39a9414c529e type="System.String">220055555144200</_11499df2e2a0d06ea8ca39a9414c529e> </Item> <Item> <_baf086501432fe421e3cc3383af93436 type="System.String">21</_baf086501432fe421e3cc3383af93436> <_9f68db04ac887b4372ce9cbe046a4255 type="System.String">21</_9f68db04ac887b4372ce9cbe046a4255> <_6acaa3186d53a25c802499b3a144d2e4 type="System.Int64">3</_6acaa3186d53a25c802499b3a144d2e4> <_59817a7d3d2e9d844243b48481bacb3a type="System.String" /> <_b853e14613bc5de9cc3f67ec26a12e62 type="System.String" /> <_c0696dd4631d8e37f5a8dd689a9882f5 type="System.String" /> <_11499df2e2a0d06ea8ca39a9414c529e type="System.String">220055555144220</_11499df2e2a0d06ea8ca39a9414c529e> </Item> <Item> <_baf086501432fe421e3cc3383af93436 type="System.String">31</_baf086501432fe421e3cc3383af93436> <_9f68db04ac887b4372ce9cbe046a4255 type="System.String">31</_9f68db04ac887b4372ce9cbe046a4255> <_6acaa3186d53a25c802499b3a144d2e4 type="System.Int64">4</_6acaa3186d53a25c802499b3a144d2e4> <_59817a7d3d2e9d844243b48481bacb3a type="System.String" /> <_b853e14613bc5de9cc3f67ec26a12e62 type="System.String" /> <_c0696dd4631d8e37f5a8dd689a9882f5 type="System.String" /> <_11499df2e2a0d06ea8ca39a9414c529e type="System.String">220055555144230</_11499df2e2a0d06ea8ca39a9414c529e> </Item> </Items> </RepeaterData>
PS. Sorry the formatting of xml is lost when I paste it here on the reply box. But yes, the internal IDs are also still matched.
Just trying to figure whether the XML structure is the cause of the missing Repeating Section.
You stated "I noticed that the repeating section always goes missing after I fill in the fields of the repeating section and hit submit" - but there is data in the column, right?
Is the data not being displayed in the form? Is that the issue?
Garrett, sorry for the confusion.
Since the repeating section and the column were just recently added, they have no data in the existing records.
And so initially, the repeating section was still visible. And then when I try to put some data and submit, the data are stored into the column. But when I open again that existing record, that is when the repeating section is gone, either in edit or display mode.
I hope this clears things up.
So my observation is that the disappearance of repeating section is triggered by entering data into it. And I am not sure what is causing this behavior...
Did you figure this one out? I’m experiencing this as well for New Responsive form. Repeating section appears fine when creating a new list item (New form). But after I submit and go back into the form, none of the fields inside the repeating section show. I just see the repeating section’s header.
Now this only happens if I connect the repeating section to my plain text, multi-line column. If I set it to No Connection, it works fine.
Hi
Make sure you have deleted the Multi Lines of text control off of your form.
If you do not, it will clear the information used for the repeating section.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.