cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Workflow Hero

Value of column of the previous row

I have a list with the following columns: consumer, before, balance.

The balance column is equal to the sum of the column consumer and the column before, so far so good.
But the value of the column before the current row should be the value of the balance column of the previous row.
How can I do this?
0 Kudos
Reply
10 Replies
Workflow Hero

Re: Value of column of the previous row

Are you planning on doing this with workflow? 

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Value of column of the previous row

It's indifferent as long as it works.

I already tried doing Nintext Forms and Workflow but I could not.

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Value of column of the previous row

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

Accept as Solution Reply
Workflow Hero

Re: Value of column of the previous row

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

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Value of column of the previous row

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?

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Value of column of the previous row

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

IDCreated ByConsumerBeforeBalanceNotes
1User 1505
2User 110515
3User 2505New Before balance for User 2
4User 151520Continued Before balance for User 1 from record 2

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

IDCreated ByConsumerBeforeBalance
1User 1505
2User 110515
3User 251520
4User 152025
Accept as Solution Reply
Workflow Hero

Re: Value of column of the previous row

What I want is the second cenário.

Tks

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Value of column of the previous row

Correct

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Value of column of the previous row

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

0 Kudos
Accept as Solution Reply