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

Question

Question

Workflow inserting save row on dynamic table

asked on January 31, 2017 Show version history

Good morning,

 

I'm new to Workflow and I'm just testing around with small processes. Right now I have an LF-form with only one Table and the table has only one field.

 

At the Workflow level I have the following: "Retrieve Business Process VAriables-->For Each Row(Insert Data)".

 

 

When I submit the form, the form submits fine, but when I see the database I see the expected number of rows inserted. If I added 2 rows dynamically in the form, then the database table shows two added rows, however, the value of the fields in the database is the same. For example, if I add in my form 2 rows and in the first field I type "A" and in the second field I type "B", when I look at the database I see two rows added with the value "A" and "A". 

 

I was wondering if anyone could point me into the right direction to solve this. This would be my first step into debugging a similar table/form/process with lots of columns that are not receiving any data :(

 

Thanks.

0 0

Answer

SELECTED ANSWER
replied on January 31, 2017

Hi Raul,

When you are setting the values to insert are you using the tokens that are for each row iteration or are you using the Business Process variable such as  ( %(RetrieveBusinessProcessVariables_Table\Column_1).

Your insert rows should use the each row token such as %(ForEachRow_Column_1)

0 0
replied on January 31, 2017

Thanks Andrew, you beat me to it. I'm kind of a "Trial-and-error" guy at this point and figured it out somehow; but I'm glad you posted the solution with screenshot for other newbies like me to take advantage of.

 

Now let me tackle the bigger form, although I have the feeling it might have something to do with your solution as well.

Thanks again Andrew.

0 0

Replies

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

Sign in to reply to this post.