I am new to glide and I am trying to create an expense tracker for my personal use, just to get off the ground with a real project. I have the following columns: date, amount,balance, category. When I enter the amount, I want the balance to be updated by taking the previous balance (from the prev…

I’d probably write the previous balance when creating each row, then use a math column to figure out the new balance based on the credit or debit. You could get that previous balance before creating a new row by using a Single Value column or a Rollup column. Either way you should have a balance v…

How to auto-calculate one of the 2 fields - amount and balance - to update based on the value in another

Ask for Help

Eric_Penn March 30, 2023, 8:03pm 8

Some ideas discussed here.

Topic		Replies	Views
math formula Ask for Help	12	2351	March 11, 2021
Formula to cumulatively add and subtract two columns Ask for Help	5	642	February 22, 2023
Help w/ Form/User Entry Ask for Help	5	315	January 27, 2024
How would I add up all the balances and display that in the app? Ask for Help	6	386	November 11, 2021
Simple balance sheet not working Ask for Help	10	416	August 24, 2021

How to auto-calculate one of the 2 fields - amount and balance - to update based on the value in another

Related topics