Examples to dynamically calculate mounts between two Spreadsheets or between one Spreadsheet and one grid

 
1
0
-1

Hi Experts¡ 

I´m needing an example, to sum a series of selected cells in a spreadsheet in another spreadsheet or in a grid in the same form.

In this example, I´m trying to describe the requirement.


Spreadsheet configurations


    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi, for these kind of complex calculations you would need to use some custom JavaScript. First you can obtain the values from the fields using Javascript API#getValue(fieldId). Perform the calculations, and then set the values in the target fields, by getting a reference to the field using Javascript API#getField(fieldId). For a spreadsheet, you may need to get a reference to the instance using the example in Spreadsheet Deep Customizations.

        CommentAdd your comment...