how to setup an amount remaining field using payments table?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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.
Photo of Ryan

Ryan

  • 940 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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.  Then you can use that in a formula to calculate the balance due.
Photo of Ryan

Ryan

  • 940 Points 500 badge 2x thumb
thanks, guys, helped me solve it! awesome! 
Photo of Ryan

Ryan

  • 940 Points 500 badge 2x thumb
any help on a magic button that can auto fill payment amount and check a check box?
That's a pretty big step to go from setting up a Summary/Lookup field to building an API button...
Photo of Ryan

Ryan

  • 940 Points 500 badge 2x thumb
i learn from failure