Data: Balancing Daily Expenses with Previous Day's Balance

[Raimundo_Ladron_de_G]

I’m building an expense tracking app that shows the user its daily cashflow or balance.

The picture above shows the first version of the app which I made by connecting the app to formulas in a Google Sheet using the Legacy Free Plan.

Now I want to build that same app but in the current Free Plan. Therefore I can only use Glide tables - no connection to Google Sheets or Excel.

My challenge

I haven’t found a way for each day’s balance to come from the previous day’s balance.

Think of it like a waterfall: The balance on March 15th is equal to the previous day’s balance minus the expenses I made on that same day, March 15th.

Does anyone know how I could solve this?

[Darren_Murphy]

You can leverage the Query column. The below video should give you the general idea.

---

If the above video won't play, paste the below URL into a browser:

https://www.loom.com/share/042be3be13004355b0dedec1be67b400

[Raimundo_Ladron_de_G]

You crazy MF!!!

You did it!

That was exactly what I needed. Thank you so much Darren!