Question

Processing Table Rows into a SQL Database

Forms Version 9 Workflow

Updated June 4, 2014

asked on June 4, 2014

I am working on a Form that will gather information from a teacher about student academics. It will contain a table that teacher will be able to use to enter student information. When I pass that information into a Workflow, how would I go about parsing that data row by row to insert into a SQL database table?

1 0

Answer

SELECTED ANSWER

replied on June 4, 2014

Hi Blake,

Use a For Each Row activity in workflow, which allows you to select the Form table from which to retrieve the rows.

Regards,

Kyle

2 0

replied on June 4, 2014

This is correct. To be clear on the difference between my response and Kyle's, a For Each Row activity would be used to parse the whole Table field (all columns) while the For Each Value would be pointed to an individual column from the Table.

2 0

Replies

replied on June 4, 2014

In short, a For Each Value activity in Workflow can be used to parse the columns from a field within a Table in forms. You can then use the database activities in Workflow (Insert Data, Update Data, etc.) to place that information into a SQL table.

Let me know if you have more specific questions about this process.

1 0

replied on June 4, 2014

I need to know which values came from which row so when I insert them into the SQL database table it keeps them together. Will the For Each Value activity do that?

1 0

replied on June 4, 2014

If you want to parse the whole table all together I would go with For Each Row as Kyle mentioned above. It'll give you all the columns from the current row as tokens.

2 0

You are not allowed to follow up in this post.

Question

Question

Processing Table Rows into a SQL Database

Answer

Replies

Sign in to reply to this post.