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	2323	March 11, 2021
How to calculate Running Total as of a certain date Ask for Help	4	470	November 27, 2023
How to make column 2 - column 3 = column 4 Ask for Help	9	39	August 25, 2024
Data: Balancing Daily Expenses with Previous Day's Balance Ask for Help	3	76	April 17, 2024
Help w/ Form/User Entry Ask for Help	5	311	January 27, 2024

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

Related topics