I have form variable that use a LOOKUP calculation that collects all the "amount" from the list by filtering an "ID number". + I use a SUM calculation to sum them up and get the total, so far so good.
My issue is that the reviewer should be able to modify the "amount", and the form variable should re-calculate the SUM with the modified amount.
I need to prompt the user if the amount is over the "Limit" immediately so he cant save the item until the amount is decreased. That's why I cant use a workflow, but need to do this in the form.
Can somebody help how to trigger the recalculation when the amount is changed?