Running Balance Question

[JoennAquilino]

RE: 

 

I've got a question. I used the code and have a bit of an issue. What if there's more than 1 page? It will not calculate the balance since it's a new page and the last balance is not recorded on anyway so the it will not run. Does anyone have any ideas how it can be done? Thank you!

[Ba2sai]

Hi JoennAquilinio,

Here's how I created my running balance form and report.  One Submit Form with pass parameter based on JS calculation to update Single Record Update Form2.

Update Form
https://c3cmr752.caspio.com/dp.asp?AppKey=1870500049f88ce789144b34b4c1

 

Report View
https://c3cmr752.caspio.com/dp.asp?AppKey=1870500050225f0ac5394288a3f1

 

[NailDyanC]

Hi just to update this post and to add in the previous comment above, you may also consider checking this post:

 

[ParkLoey]

Hi! Just wanted to share this as well. Caspio released an article about running balance. It might help with ideas

https://howto.caspio.com/tech-tips-and-articles/calculate-a-running-total-in-your-report/