What defines the sort order of your items in your list.
Just to know what is your current row and your previous row.
When this must be calculated? On Schedule? After Submit of a new item?
I think we need more info.
When the user creates a new record in the form. The Value "BEFORE" is automatically create with value of previous line.
Balance - the value is calculated automatically consumer value + Before value (5+0)=5
The user place the value of "Consumer" 10
The form automatically calculated Value of "Before" is 5 (field Balance of previous line)
the Balance now is automatically calculated 10+5=15
The user place value of "Consumer" 10
The form automatically calculated value of "Before" is 15 (field Balance of previous line)
The Balance now is 25 calculate automatically
OK i can mock something up for you in workflow later - are you ordering your items by ID? so if you wanted to update item with ID 3 you would need to get the balance from item with ID 2?
Jose Fidalgo, when determining the "Before" balance, is it dependent on the User who created it? In other words would each user who creates a record have their own running "Before" balance. Or is there a single "Before" balance independent of who creates the record? I mocked up the 2 scenarios below. Which one would you be expecting?
Scenario 1: Before Balance Depends on Created By
|3||User 2||5||0||5||New Before balance for User 2|
|4||User 1||5||15||20||Continued Before balance for User 1 from record 2|
Scenario 2: Before Balance Doesn't Depend on Created By