In short , I am building a Personal Finance app - everything is great. I have a ledger table & a separate “Bills” table. I can’t figure out how to mark Bills Paid as “TRUE”. I open the form on the ledgers table and select which Bill that transaction references but nothing happens when I add the transaction. Context I’ve tried playing all kinds of Tasks/Action/Bot combinations. I’m pretty much throwing everything at the wall hoping something sticks lol .
confirmame, respondeme con un si o un
TL;DR: You can’t update the referenced Bills row with a formula. Create an action on Bills to set [IsPaid]=TRUE, then trigger it from Ledger (on form save / Bot) using LIST([BillRef]) so the selected Bill gets marked paid automatically.
(This is the standard parent/child update pattern in AppSheet.)
1 Like
Hi @Carl_Fox
Let’s say you have two tables : “Bill” and “Ledger”.
- table structure
On your “Bill” table, you may have a column “Ledger”.
Assuming you have it, set it with type Ref, source table “Ledger”.
Now, when you add a transaction in the “Bill” table, you need to select the ledger it is relating to.
- the virtual column
In the “Ledger” table, create a virtual column named “paid”.
Set its formula as:
ISNOTBLANK([Related Bills])
it will automatically switch to TRUE when you attach a bill to it.
Let us know if that doesn’t work for you
3 Likes