Trigger subform subtotal field calculation

追蹤

Andreas Blersch

• 2019年10月25日 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

  • 2019年10月25日 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

  評論操作 永久連結
• 

  Andreas Blersch

  • 2019年10月25日 14:44

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

  0

  評論操作 永久連結
• 

  sysberry GmbH

  • 2019年10月25日 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

  評論操作 永久連結
• 

  Andreas Blersch

  • 2019年10月28日 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

  評論操作 永久連結
• 

  sysberry GmbH

  • 2019年10月28日 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

  評論操作 永久連結
• 

  Andreas Blersch

  • 2019年10月28日 14:51

  ok got it

   

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

  0

  評論操作 永久連結

請登入寫評論。