Print Field Calculation Order in JavaScript Console?

Question

I have an enormous amount of calculated fields, and am trying to audit them to make sure everything is as it should be. It would be easiest for me if I could copy and paste the list into excel to better plan the hierarchy of the fields. Is there a way to print the field calculation order in the javascript console?

try67 · Accepted Answer

As an apology, I wrote the code that does it for you:

var fields = [];
for (var i=0; i<this.numFields; i++) {
    var f = this.getField(this.getNthFieldName(i));
    if (f==null) continue;
    if (f.calcOrderIndex>=0) {
        fields.push(f);
    }
}
fields.sort(sortByCalcOrderIndex);
for (var i=0; i<fields.length; i++) {
    console.println(fields.name);
}
function sortByCalcOrderIndex(a,b) {
    return a.calcOrderIndex-b.calcOrderIndex;
}

Joel Geraci · Answer

Yes it is.You can loop through the fields adding each Field with a calcOrderIndex property greater than -1 to an array. Then use the Field Object calcOrderIndex to sort the fields based on the calcOrderIndex property, then print their names to the console.If the calcOrderIndex = -1, it's not a calculated field.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded