Old Items - extract form data

  • 22 January 2019
  • 1 reply
  • 3 views

Badge +3

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?


1 reply

Userlevel 5
Badge +14

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.

Reply