How to do an auto calculation of grid 2 based on values from grid 1 ?

 
1
0
-1

How to do an auto calculation of grid2 based on values from grid 1? Also, I need this grid 2 as editable.Can anyone help to solve my situation?

    CommentAdd your comment...

    3 answers

    1.  
      2
      1
      0

      Hi,

      This is an interesting question. I tried and make a sample app with advanced grid with some custom javascript. It looks like it is working as you requested. Please refer to my sample app. APP_gridCalc-1-20171010115825.jwa.

      note: I am using v6 beta3. But I believe you can use in v5 as well.

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Thank you, Anders, for your input. 

        I thank Owen Ong to do this sample for me. It works as expected. 

          CommentAdd your comment...
        1.  
          1
          0
          -1

          Hi, you should be able to make use of custom JavaScript to perform such calculations. Found a similar question and answers at Make calculations and update in real time fields

            CommentAdd your comment...