Hey Rui,

Working on a rebuilding clients process in Forms 10, I have managed to reproduce the same issue Roy is/was having.

Table on Form:

I do use some custom scripting to calculate a subtotal in the 'Amount' column of the table. It simply takes 'Quantity' and multiplies it by the 'Price' and plugs in the result to 'Amount'

Script:

While it does function by populating the 'Amount' column, the built in function tool on the advanced tab does not populate the 'Total' currency field below the table.

Advanced Tab function:

Form with 'Amount' calculated, but no 'Total' calculated.

Only when I click 'Add' does the 'Total' field calculate. Plus, after I do add a row, if I was to delete the row, it does not update the 'Total' field either.

So anyways, with all of that explained and shown, is there a fix to this issue? For updating the total automatically without the need to add a new row, and to update when deleting rows? Or do I have to revert back to the complete custom scripting I was using before (which we are trying to move away from and use more 'out-of-the-box' features)? Plus, will the ability to do across row calculations be added and integrated with column based calculations (for example we need the ability to use =PROD() across a row, and use it with =SUM() down a column)?

Hi Doug,

For the issue that calculation is not updated when add a row, you need to trigger the change event on the total field after you give it value in your custom script.

Update your script like this:

      $(this).find('.total input').val(subtotal);
      $(this).find('.total input').change(); //Add this line
      $(this).find('.total input').attr("readonly", true);

As for the issue that calculation is not updated when delete a row, can you open a support case? We can provide a temporary fix.

And we will add functions to support cross row calculations in next release.