Thanks, Michael!  

Do you have an example of how to set that up in Workflow?

You're welcome, Connie,

Yes, you use the Retrieve Business Process Variables tool and then use a stored procedure within a Custom Query tool. We use this in several processes and their associated workflows.

Okay, I have this so far.  I have the RBPV activity set to bring in the data on the collection field's table rows, but can't seem to get the custom query to see where to connect with that data.

I have made it (1) a business process, (2) started by LF Forms.

What do you have listed under the Data Source dropdown? It looks like it's your custom query activity. What I do is configure a data source within the Workflow Admin Console. 

You should also be able to configure it within the Data Source drop down by clicking on the Manage Data Sources option. 

Please see this reference for additional information regarding configuring those. https://www.laserfiche.com/support/webhelp/Laserfiche/10/en-US/administration/Default.htm#../Subsystems/LFWorkflow/Content/Resources/Configuration/External%20Objects/Data%20Source%20Administrator.htm?Highlight=data%20source

Getting closer, but how do I get it set up so the

• applicant name is sent to the SQL,
• the BP Instance # goes in as the SQL "Order Number" and then
• the Rows populated with the quantity and Item numbers kept together,
• with some additional options recorded on the spreadsheet, as well? 

I think I've got the data source figured out; it accepted my choices.  

You'll also need to configure a stored procedure (to call from Workflow) on the SQL side of your database.

Getting closer! I can add the Instance ID as the Order ID here, the applicant's names, etc...

(I'm sorry, I'm very visual, so I need to see it; and like to offer my views to help anyone else trying the same thing.)

are you getting an error?

Frank, I can't even publish my workflow because I can't find how to tell it which form or which table the data is to be pulled from, yet I am able to tell it what "retrieved fields" data to send to the SQL tables.

You choose the form to pull from via the properties panel on the right. First choose your Forms server, and then the process you want to pull the data from. If you're able to tell it what "retrieved fields" data to send to the SQL tables, then it sounds like you already have the referenced section completed.

Hi Michael!  Yes, I would have thought so also!  The RBPV was configured fine and I was able to pick the fields that are on the form.  Yet, the Custom Query could not be configured to find the table.  It could find the RBPVariables (the fields I'm pulling off the table).

I don't know how to build the Query, that's part of it, but also the For Each Row variable could not match up to anything.  Now that I'm looking at it again today, I'm wondering if the For Each Row just needs the "Get Rows From" the Custom Query, however, that doesn't make sense to me as I know it needs to get the rows from the table in the form.

So, when you say table, are you referring to the SQL table, or are the values on the form you're pulling from in an actual table on the form?

Well, there's the table in the form, from which I want to send to the SQL tables/database/column fields.

The table on the form is in a collection, so there might be two rows on one order submission and ten rows on another order submission.

You'd definitely need to use the "for each row" for that, so you're on the right track. I notice above that you're using the "Update Data" tool. I think you need to be using the Custom Query tool in conjunction with a stored procedure in order to update your SQL tables. 

Yes, I've tried both the Custom Query and the Update Data tools.  Another post with a similar situation suggested the he Custom Query was the one to use.  Still, I cannot publish my workflow.  I need to see an example of someone who has done this and be able to pick apart his/her configurations until I can piece mine together in the same way.  I can't find an example similar enough and detailed enough.

Did you click on the Custom Query link in my last post? It takes you to the admin guide for that tool. It's what I used to configure ours. You'll need your stored procedure in place to call it from your workflow. You'll also need to configure the data source as I'd mentioned yesterday. There's a link for that section as well. Once you've built your stored procedure in your SQL table, and configured the data source, you should then be able to enter the necessary information in the Custom Query Editor and publish your workflow. Here's an example of what that looks like from one of ours. (Note: I've blurred our SP and variable names.)