how to setup an amount remaining field using payments table?

Question

I'm looking to add a Remaining Balance/Amount Remaining field to my payments table/form. Basically, the customer can choose the # of payments they'd like to make and we have set payment schedule. However, I have no remaining balance tally that shows or warns me how much is left on the total bill.

mcfneil · Answer

When you set up the relationships so each 'item; has many 'payments' you can then set up a summary field that will count the total paid. &nbsp;Then you can use that in a formula to calculate the balance due.

ryanryan2 · Answer

can you show me in steps?

archiveuser · Answer

http://help.quickbase.com/user-assistance/adding_a_relationship_field.html

ryanryan2 · Answer

thanks, guys, helped me solve it! awesome!&nbsp;

ryanryan2 · Answer

any help on a magic button that can auto fill payment amount&nbsp;and check a check box?

Forum Discussion

how to setup an amount remaining field using payments table?

7 Replies

Related Content

Updating $$ amounts

online payment option

QUICKBOOKS BILL PAYMENTS PARSING

how to count the remaining # of payments?

Running total - PTO Days remaining