I have a list with the following columns: consumer, before, balance.
Are you planning on doing this with workflow?
It's indifferent as long as it works.
I already tried doing Nintext Forms and Workflow but I could not.
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?
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
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
Scenario 2: Before Balance Doesn't Depend on Created By
can you give us please solution of scenario 2?
What I want is the second cenário.
Hi , i have the same problem any solution was find?
Retrieving data ...