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

Question

Question

How to update a SQL DB table, with data from forms.

asked on January 5, 2017 Show version history

I need to insert and update data from this form 

All the fields needs to be in the DB table.

With the first fields I have no problem, but with the fields in the table, I can find a way to insert those,  What I do is create a DB in SQL with the follow desing for the data on the forms table:

I

 

Each column for one entry in the table (3 entries by form).

And create this workflow to populated

With the configuracion of the branch as follow

 

 

And every brach update the same row where initialy I insert the first fields, and partially works

The problem is that only insert the first line of the form table in all the 3 DB columns, for example:

 

 

instead of

 

 

What could be doing wrong.

 

0 0

Answer

SELECTED ANSWER
replied on January 5, 2017

That's not really showing the names of the tokens used. You need to use the Current Value tokens from For Each Row. Otherwise, you're always inserting the first value from the table.

0 0

Replies

replied on January 5, 2017

What are the update data activities set to?

0 0
replied on January 5, 2017

Each of the 3 update activities are as follow:

Brach 1

 

Of course, every data update in every interation are ponting to a diferent column in the DB branch 1 to "empresa1", branch 2 to "empresa2" and so for.

 

 

0 0
SELECTED ANSWER
replied on January 5, 2017

That's not really showing the names of the tokens used. You need to use the Current Value tokens from For Each Row. Otherwise, you're always inserting the first value from the table.

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

Sign in to reply to this post.