If I have columns that calculate information based on the balance in another table. Which subsequently gets paid down. Will those columns automatically update reflecting the new information, or is there a way to freeze them so that it retains the information collected at the time it was created in o…

Thanks, but from what I can tell, those formulas aren’t available at this time. Someone was just making a suggestion. That looks like about what I need though.

Yes those formulas don’t exist yet though it’s definitely on our list to add them. Feel free to upvote that post! In the mean time, there are a few ways you could do this. A ledger model - in that case, you store every update to the “balance” at it’s own row (like a ledger). Then you get the cur…

Thank you. The workaround I have right now is to use an automation to calculate balances and modify the row with that data and update status to Paid In Full. I am assuming that since that is only triggered when I trigger that automation, those values should stay static unless I re-trigger it for tha…

Sorry Bianca, I should have double checked as I intented to refer to the 2nd point in Shishir’s post. Kind regards, //JP

No problem, happy for any help.

Can you create rows that retain the information pulled in at the time of creation?

Superhuman Ask the Community

Jean_Pierre_Traets March 10, 2019, 10:52am 2

Dear @Bianca_Adams,

If I am understanding your question well, the below post might contain the solution:

Row Modification History

Best regards,
Jean Pierre

Topic		Replies	Views
Sometimes you don't want to update a value but cannot avoid the automatic updating behavior Ask the Community	10	567	November 22, 2023
Freeze past row values Ask the Community	11	1659	December 7, 2019
Loan Payment Table Ask the Community	6	566	May 19, 2021
Capture `History` of changes / Create Log of changes to important value of record Tips and Hacks	2	4698	July 2, 2019
Lock calculation result Showcase & Tips	2	563	August 5, 2021

Can you create rows that retain the information pulled in at the time of creation?

Related topics