You are viewing limited content. For full access, please sign in.

Question

Question

Retrieve Table Rows from Form Table and Insert into MS Access Table - Multi-Value Fields

asked on May 4, 2015

I see that this question has come up before but I cannot get this to work.

I am trying to retrieve data from a table in Forms and, using Workflow, insert each row from the table into separate rows in an MS Access database table.

The Retrieve Forms Content activity of the Workflow is pulling the table fields in to workflow as multi-value fields.  So I am using the For Each Row activity first and then Insert Data to try and get it to parse through each entry of the multi-value fields.

But Workflow is still just taking the data from the first row of the table (i.e. the first values of each of the multi-value fields) and inserting them over and over again in the table.  So I get 10 rows in my database table of the first row of the original form table.

i don't know how to parse out each multi-value field so that it goes into separate rows in my MS Access table.


1 0

Replies

replied on May 4, 2015

That should work. What versions of Forms and Workflow are you using?

0 0
replied on May 5, 2015

Workflow 9.1.1.365

Forms 9.1.0

0 0
replied on May 5, 2015

Interestingly, I did the exact same workflow and connection profile using fields in a Collection instead of in a Table and it worked properly.  So I think I will do that.

0 0
replied on May 5, 2015

Hello Katherine,

 

I am currently trying to reproduce the problem on the same Workflow and Forms versions. What fields and their type did you extract in the Retrieve Laserfiche Forms Content activity?

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.