I have a view where I can see a client's Total Cost, Deposit they paid and their Remaining Balance (I have Balance set with the formula Total Cost - Deposit.) When a client wants to make a partial payment, how can I do that and have the Remaining Balance calculate that?
Anonymous shared this idea · Aug 24, 2016
There are multiple ways to approach this, and some of your options may be more effective than others based on your current workflow and table design. I will do my best to describe a few options here, but please feel free to contact our Support Team directly at 800-673-3302 or firstname.lastname@example.org if you would like further assistance.
One option would be to create a new field called Partial Payment, the edit the formula in your Balance field to also subtract this new field (Total Cost - (Deposit + Partial Payment)). If a Partial Payment is made, you input the number into your Partial Payment field and the Balance will update automatically. If they do not make a partial payment, you can leave this field blank and the Balance calculation will be unaffected.
if you are attempting to track these partial payments, you could instead a new child table called Partial Payments. These partial payment records could then be added together on the parent table using a sum function, and this total could then by subtracted from the Total Cost in the same manner as the example above.
I hope this is helpful. Please don't hesitate to reach out if you have any additional questions,
Please sign in to leave a comment.