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.

Hi,

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.

Regards,

Christophe

When the user creates a new record in the form. The Value "BEFORE" is automatically create with value of previous line.

Example:

1st Registration.

Consumer 5

Before 0

Balance - the value is calculated automatically consumer value + Before value (5+0)=5

2st registration

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

3st registration

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

Best Regards

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

Scenario 2: Before Balance Doesn't Depend on Created By

What I want is the second cenário.

Tks

Correct

Hi , i have the same problem any solution was find?

Hello!

can you give us please solution of scenario 2?

Brgds!