+7I have a list with the following columns: consumer, before, balance.
+7It'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
+7When 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
| ID | Created By | Consumer | Before | Balance | Notes |
|---|---|---|---|---|---|
| 1 | User 1 | 5 | 0 | 5 | |
| 2 | User 1 | 10 | 5 | 15 | |
| 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
| ID | Created By | Consumer | Before | Balance |
|---|---|---|---|---|
| 1 | User 1 | 5 | 0 | 5 |
| 2 | User 1 | 10 | 5 | 15 |
| 3 | User 2 | 5 | 15 | 20 |
| 4 | User 1 | 5 | 20 | 25 |
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
