Adding an Input To a repeating group, then using the input of one row to calculate outcome for next row Input field

[posting]

So I have this Repeating Group where the last column is generated currently by data saved in DB. But ideally I would like it not to be saved in DB (due to WU & other concerns). Here is how I want it to be populated on the front end and not take anything from DB.

As you can see, it is a ledger and last column is the customer’s running balance. So every row needs to see what was the previous running balance and then detect that Invoice / Payment amount from it and so on.

I’m looking for any suggestions for how is it possible.

[mitchbaylis]

if you’re going to build a ledger you need to build a ledger…

a ledger has a start, end, change value for each row

start 1000
change +200
end 1200

the data is written per row and calculated when it is created not when it is shown on the page

[posting]

I am already doing it that way. Was just thinking if like an Excel sheet where next cell can take input from the previous row’s cell, the table element of repeating group might work and I don’t need to save this running balance in the DB