Question & Answer > View Question

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

Confluence User - 10 Mar, 2022

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

spreadsheet;form-grid

1

Confluence User •

17 Mar, 2022 •

confluenceUser •

•

confluenceUser •

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.

1

CSV | Excel | XML | PDF

Your answer

Print

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

1

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

1.builder-style-9b7c2859-e6a2-428e-881d-3ae3ab4135f8{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-6d84ce68-c494-4aa9-a467-ed9c9f2b9c00{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

1

Your answer