Trigger subform subtotal field calculation

Follow

Andreas Blersch

• October 25, 2019 10:04

Hi 

in a subform I multiplicate two field values with a fomula field. On the formula field I have a rule to transfer the result to the subtotal field "Plankosten".

But the total on the subform buttom is not updated. I think the change event is missing because I set the value with a rule!? How can I trigger the calculation to get my sum of all rows.

 

0

• 

  sysberry GmbH

  • October 25, 2019 11:17

  Hi Andreas,

  the problem can be indeed in the change event. After adding new row there will be a load event on the new row. Perhaps you should manually trigger the formulas with JS.

  P.S. are you from germany? Would be nice to speak more over LinkedIn or XING.

  Regards,
  Alexey

  0

  Comment actions Permalink
• 

  Andreas Blersch

  • October 25, 2019 14:44

  The formula calculation is working, but not the sum of the subtotal field from the subform.

  0

  Comment actions Permalink
• 

  sysberry GmbH

  • October 25, 2019 15:26

  If you set the valie with a rule, then the change event is not triggered, correct. For that you will need to write small JS to trigger the change event, or to calculate fields.

  Regards,
  Alexey

  0

  Comment actions Permalink
• 

  Andreas Blersch

  • October 28, 2019 07:45

  In the rules of the formula field i add following svript to fire the onchange event after the data are set to "curPlankosten" (last field in the image)

   

  $('#curPlankosten').change();

  But it is not working.

   

  0

  Comment actions Permalink
• 

  sysberry GmbH

  • October 28, 2019 08:34

  Hi Andreas,

   

  Plankosten are inside the subform. If you inspect the field in preview mode, you will see, that because of the subform there is a guid after the id, so only "#curPlankosten" will not work. You will need to find the right id, or for example give an additional css class to the field and then search on class name. 

  Regards,

  Alexey

  0

  Comment actions Permalink
• 

  Andreas Blersch

  • October 28, 2019 14:51

  ok got it

   

  function GetSubFormControlAndFireChange(ctrl) {
    var control = $(ctrl).parents(".subFormContentRowChildWrapper").find("[id^='curPlankosten']");
    control.change();
  }

  0

  Comment actions Permalink

Please sign in to leave a comment.