Hi all. I built a simple app for my kids allowances. For each task/chore they do, they get paid. However weโre trying to teach them about taxes, so we also have a tax โaccountโ where we plan on carving off a small percentage of their allowances towards family things (voted on). Net-Net, Iโm trying to see if thereโs a way of submitting their payment, but on the backend splitting it into two records (Google Sheet), part of it towards the Tax account and the other part towards their account (4 kids, checking/savings โaccountsโ). Doesnโt seem like this is possible? Right now I basically put in 2 records and do the math myself (ex: 25 cents their account, 8 cents Tax account).
Another related question is transfers between โaccountsโ. We also trying to teach them savings accounts and the benefits of it. While interest rate is on the todo list (), today it requires two entries against the โLedgerโ sheet that records all transactions (ex: -5 savings, 5 checkingโฆ the ledger sheet has simple timestamp, account holder, account, amount, and memo). Would love to have a similar โsingle entry = 2 backend recordsโ to maintain the ledger (preventing fat fingering on my part).
For now Iโve got workarounds, but would love to add some more functionality to Bank of Dad.
Thanks. I saw those, but they donโt seem to support my specific usecase. Basically in the UI (form) I want to add one payment, and then do a man in the middle attack against that value, to do one of two things:
Either way, the value I put into the text field, I donโt want it to just pass in as-is to the backend Sheet. Hopefully that makes sense.
There is no way to accept input and not write it to the data store. Youโll have to work around that constraint.
Appreciate the quick response. Thanks!
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |