Re: Update multiple rows in DB table from rows in Table object

Home Forum General Update multiple rows in DB table from rows in Table object Re: Update multiple rows in DB table from rows in Table object

#5828

Anonymous

Had an issue with the same thing. Connecting with “all rows” doesnt work – you have to use a behavior that moves through the table and connects/updates each time you have a record on a given row.

There are a few actions within the behavior you will need to get it moving:

* Set table row

* Simple branch

* connect

You will need to create a sort of “if statement” loop where you first set the table row to “move to first row”, connect and update the record (for the current row), set table row to next row, do a simple branch with an advance formula “last behavior was successful” – if true, the connector should go back to the connection/update action. If false, close, submit or whatever you need it to do.