Skip to main content
Known Participant
December 4, 2025
Answered

Calculation order

  • December 4, 2025
  • 1 reply
  • 115 views

I have a lot of calculations fields, is there a way to export calculation order field names to text editor so I can create right order more easily and keep track?

Correct answer Nesa Nurani

Run this in console, then you can copy list:

var numFields = this.numFields;
var calculatedFields = [];

for (var i=0; i<numFields; i++) {
 var fieldName = this.getNthFieldName(i);
 var f = this.getField(fieldName);
  if (f != null && f.calcOrderIndex >= 0) {
   calculatedFields.push({ name: f.name, index: f.calcOrderIndex });}}

calculatedFields.sort(function(a, b) {
 return a.index - b.index;});

for (var j=0; j < calculatedFields.length; j++) {
 console.println((j + 1) + ". " + calculatedFields[j].name + " (calcOrderIndex: " + calculatedFields[j].index + ")");}

1 reply

Nesa Nurani
Community Expert
Nesa NuraniCommunity ExpertCorrect answer
Community Expert
December 4, 2025

Run this in console, then you can copy list:

var numFields = this.numFields;
var calculatedFields = [];

for (var i=0; i<numFields; i++) {
 var fieldName = this.getNthFieldName(i);
 var f = this.getField(fieldName);
  if (f != null && f.calcOrderIndex >= 0) {
   calculatedFields.push({ name: f.name, index: f.calcOrderIndex });}}

calculatedFields.sort(function(a, b) {
 return a.index - b.index;});

for (var j=0; j < calculatedFields.length; j++) {
 console.println((j + 1) + ". " + calculatedFields[j].name + " (calcOrderIndex: " + calculatedFields[j].index + ")");}