Thanks Andrew, that worked like a charm.

Hey, here is a related question; I have an LF Table, that allows us to add rows dynamically of course. We are using Lookup Rules to populate the values back to the table from our database for updating. As of now, if I want to update a form that had, say, 2 records added dynamically, belonging to the same form, I can individually update each of those rows with different values using the Update Data activity. 

However, if I want to add a new row, the two existing rows are updated as expected, but the new non'-existing row isn't added.

I guess the short instruction is: Find this row, and update it with this value where the Unique ID is this (which works).

But since the newly added row doesn't exist, it's not inserted. Is there anyway to do this within the same Update Data activity or do I have to play around with other activities to check if the row exists first, and if it doesn't do go via the "Insert Data" activity route?

I'm attaching a file to see if I can make more sense of what I'm saying :)

Thanks again Andrew

You are on the right track!    You will need to use the insert activity to add a new row.   Update will only work on existing rows.    Just use a conditional decision to determine if it is an existing row or not and branch to either an update or insert activity.

It can also be helpful to wrap your updates or inserts in a 'Try-Catch' activity just in case the database update/insert does not work for some reason.  You can then deal with the error or end the workflow with an email about the problem.

Andrew, thanks for pointing me to the right direction. I gotta tell you, I was trying something similar (I thought), but wasn't able to make it work. I had to come back to your post and re-read it; and finally was able to come up with a solution.

I'm attaching a screenshot of a simplified version just to share what I have so far.

Pending will be the ability to delete records from the form and update (remove the rows) from the database table.

Thanks again, this is working for now.