Hi everyone,
I’m trying to confirm if this setup is doable or if I should consider another approach.
Each client/item has 6 fee types, and each fee can be paid gradually through subitems.
Parent item columns include:
-
TypeFee (price)
-
Total Paid (mirrored from subitems)
-
Balance (TypeFee – Total Paid)
-
Status → Completed / In Progress / Not Started
I use Zapier to mark a “Final Calc” column as Paid in Full when all fee types show “Completed.”
But I’ve hit some limits:
-
Formula & mirror columns can’t trigger automations or be updated
-
Subitems can’t trigger Zaps
-
“Get Item by ID” not available
-
Data from “Get Items by Column Value” isn’t dynamic
Has anyone managed something similar or found a workaround for this?
Would appreciate any confirmation or advice — just want to know if it’s possible before spending more time testing.
Thanks in advance!