Thu, 24 Sep 2026
Login

Not auto-calculated spreadsheet columns

Confluence User - 17 Oct, 2018
Hallo experts,
I need to auto-calculated several columns in my spreadsheet form but never succeed.  I tried put this script in Custom Settings (JSON) to trigger one column (i have 20 calculated columns ) but nothing happened : 
{
    "afterInit" : function() {
        var ht = this;
        var rows = ht.countRows();
        if (rows > 0) {
            var changes =  [];
            for (var i = 0; i < rows; i++) {
                changes[i] = [i, "calculated_column", "", ""];
            }
            //prepare changes to trigger the calculation
            ht.runHooks("afterChange", changes, "edit");
        }
    }
}
Any other solution ?
forms;spreadsheet

1

Confluence User •
26 Oct, 2018 •
confluenceUser •
•
confluenceUser •

Hi, do you need custom code to do calculations? In the Spreadsheet page you can just use functions to perform calculations.

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Error storing data
How to generate unique ID using Textfield?
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print