SQL SmartObject Editable List View update another SQL table

HI braddo,

I have provided you with two links that would help with editable list view,please view the link sbelow .

http://help.k2.com/onlinehelp/k2five/userguide/5.1/default.htm#Create/Views/EditingAView.htm%3FTocPath%3DCreate%7CSmartForms%7CViews%7C_____3

http://help.k2.com/onlinehelp/k2five/userguide/5.1/default.htm#Create/Views/EditableListViews.htm%3FTocPath%3DCreate%7CSmartForms%7CViews%7CList%2520Views%7C_____3

Hopefully the content will remedy your issue, or direct you you to the right path of  solving it.

NOTE: K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member.

Hi Braddo,

You will have to change your SAVE button rules to save all the entries to a new SmartObject.

e.g.

I created 2 SmartObject (Emp1 & Emp2) and generated an Editable List View from Emp1 (This SMO also contains some data):

I edited the following rule: When Save Toolbar Button is clicked

I disabled the 3 actions and added the following condition & method on the rule:

for ALL rows

     then on [SMO2] SmartObject, execute its Create method

Runtime:

The first View opens and i can make changes as i want:

Click SAVE and look at the data in the Second SmartObject in the Database.

HTH

-Jean

I had discovered this method - does this make sense to you?

on the editable list i make changes

Rule

when the view executed list item changed

apply the changes made to the row on the editable list

then i have a submit button on the form

and then the rule

On the view, using Smartobject, execute the create method for all the items that have been changed