I have an app that manages bills and payment. I am attempting to make an action limk that will create a payment (connected record) for the amount that is due, and mark the bill as “paid in full” in a table of ‘bills’
The “total due” is entered manually with the ‘Bill’ data. Payments and credit memos are held in separate databases, and their values are used to calculate the “Current Due”. (total due - payments = current due, essentially)
When I create the action link, and attempt to assign a value to 'payment amount" (payment), I want to do so using the calculated “Current Due” (bill); however, the only value it offers is the initial “total due” (bill). I assume that this is because it is a calculation, and not a ‘number’? Is there a trick or method I can use here, other than just updating the ‘current due’ each time a payment is added?