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.
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
