Gird calculation based on SelectBox.

 
1
0
-1

Hi friends,

I am new to joget and i am facing an issue and require your help.

I have a select box[Drop Down] and a Grid.

Calculation of Calculation result column of this grid is based on Select Box.

I have attached the preview page screenshot below.

Anybody please help.

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi, I do not think that you can use calculation field for this as it does not support dynamic operator for formula. But, you can use javascript to get the operator and calculate the result yourself using javascript.

      for example, if your grid is form grid element, you can use the following script in your inner form to get the operator from parent form.

      $("[name$='operator']",parent.document).val()

      Best regards.

        CommentAdd your comment...