Javascript for bank transactions

[Troy Bridgewater]

Anyone familiar with javascript? Your help is greatly appreciated.

There three seperate accounts I keep record of transactions. Each entry represents a transaction. On each transaction there are fields that specify the date of the transaction, "Date," and specify which of the three accounts was charged, "Account."

"Intial Balance" - the balance for the account before the transaction was made

"Amount" - the transaction's total amount (sometimes a credit, sometimes a withdrawal)

"Balance" - the difference of the Int. Balance and the amount for the account

I have made two seperate libraries, one for the accounts and one for transactions. I would like a script for "Initial balance" and "Balance". "Amount" should be the only field where the user can input information. The other two fields, I want to be scripted to insure no math errors. 

[Mmm]

Посмотрите результаты поиска "balance" на форуме:

https://groups.google.com/g/mementodatabase/search?q=balance

среда, 13 мая 2026 г. в 21:28:05 UTC+3, troybri...@gmail.com:

[digico Iwate (Digico)]

The solution is described in the following page: https://help.mementodatabase.com/knowledge-base/using-memento-database-for-warehouse-inventory-management-a-beginners-guide/

In my setup, the initial quantity (or initial balance) is also stored as a normal transaction record. After that, all increases and decreases are handled simply as additional transaction records, and Memento Database’s lookup and aggregation features calculate the final total automatically. This approach works reliably without any scripts, since everything is handled by the standard functions.

2026年5月14日木曜日 5:52:21 UTC+9 Mmm: