Execute an action on a row and a previous row

Hello,
In the simplest way possible, I would like to execute an action on a line :
status => on sales

But, at the same time, I would like the previous line to change its value as well:
status => completed

I don't understand how to execute an action on the current line and another line at the same time

Thanks

Solved Solved
0 4 256
1 ACCEPTED SOLUTION

You would use a Grouped Action.  In the group, there would be an action to update the current row.  The second action will need to be an "execute an action on a set of rows" type action that identifies the previous row and then calls, for that row, an action to update it.

View solution in original post

4 REPLIES 4

You would use a Grouped Action.  In the group, there would be an action to update the current row.  The second action will need to be an "execute an action on a set of rows" type action that identifies the previous row and then calls, for that row, an action to update it.

HI,
Ok I will try your idea : a grouped action and "execute an action on a set of rows" type action

The Referenced Table can be the same table of the original action ?

Thanks

 

 


@eric_niedergang wrote:

The Referenced Table can be the same table of the original action ?


Yes, it can be any table actually, even if they don't relate to each other. Execute an action on a set of rows is very flexible and powerful

Yes, it works

Thank you very much

Top Labels in this Space