smccnn
Apprentice

Old Items - extract form data

We have a request from business to extract the repeating section from our form. The form goes back two years and is used daily. The form was not setup to push the repeating section data into another column so we could parse it, and only newer items from a certain date have this configured.

Is there a way to run through the older items and extract the repeating section data into another column so it can be parsed?

0 Kudos
Reply
1 Reply
emha
Collaborator

Re: Old Items - extract form data

if a repeating section is not connected to dedicated list field, it stores its data in a hiden list field named FormData.

so you may set up a workflow that reads out repeating section content out of there.

 

or you may open&save old items in a new form (which stores repeating section into a dedicated field) and the content gets rewritten to the dedicated field.

0 Kudos
Reply