How to track partial payments

[gokul_krishnan]

I’m struggling to come up with a way to account for partial payments for each order. The sales people make multiple partial collections for some orders, is there some way i can subtract from the total bill amount and keep track of all the timestamps, type of partial payment(cash or cheque or e - transfer) and the partial payment amounts.

[Rifad]

You can create a child table linked with this table ID as REF. You can add payments and create an action to update the parent table when the child table is updated.

In Total column, you can use this SUM() | AppSheet Help Center

[gokul_krishnan]

Thank you! The related rows work fine. But I cant seem to get my sum formula to work. It just returns 0.

SUM ( SELECT (Order Item[Amount], [Order ID] = [_THISROW].[ID]))
Order Table

Order Item Table

[Rifad]

You have to setup an action as mentioned above and should be attached to form on save event.

[Gokulakrishnan_]

Thank you! I’ll give it a try!

[Rifad · Accepted solution]

You can have a look at this

Quick Update System - How to update records in your app with a push of a button Tips & Tricks 💡

“How can I update a parent record when a child record is changed?” “How can I mark all the line items in an invoice as paid when I mark the invoice as paid?” “If I have App Formulas inside a physical column, how can I get those to update like a virtual column?” “How can I recalculate formulas with a push of a button?” All of these situations can be solved by implementing a Quick Update System inside your app. What is the Quick Update System? A way to update app formulas and recalculate v…

Or you can make total column as virtual column.

[Gokulakrishnan_]

Do i use the sum(select()… formula in the reference rows bar?

[Rifad]

SUM(SELECT()…) Should be used on total column in parent table

[Gokulakrishnan_]

I’m really confused, what formula do i use where?
The screen shot below is the Action I’m suppose to like to the form and the order columns.

[Rifad]

Did you have a look at the post and the video description I have shared previously ? It’s clearly mentioned and I hope it can be implemented exactly same like that in your app.

[Gokulakrishnan_]

I finally made it work!!Thank you!!!