Highlight smallest value in green and highest value in red

Question

Dear all ,My form has 5 fields (field #1 -  field #5) with numbers (prices). Is there any javascript, with which I can identify the lowest price (automatically highlighted in green color and the highest in red color? Important if one field value is empty = 0, than 0 should be not considered as number.In addition the script should populate the lowest vaue in field #6, the average value in field #7 and the highest field value in field #8.I would be greatfull for any ideas and comments.BRFlorian

ZoPaars · Answer

Very similar to my answer to your other question, but a lot easier because we are working with field values that are straight up numbers, and don't have to first be converted to date objects.

//make an array of date values
var valArray = [[], []];
var total = 0;
for (var i = 1; i < 6; i++) {
    var Nm = "field #" + i, fld = this.getField(Nm);
    fld.textColor = color.black; //reset all the field colours
    if (fld.value && !isNaN(fld.value)) {
        valArray[0].push(fld.value);
        total += fld.value;
        valArray[1].push(Nm);
    }
}
//get the max value
var maxVal = Math.max.apply(null, valArray[0]);
var maxIndex = valArray[0].indexOf(maxVal);
var maxFld = this.getField(valArray[1][maxIndex]);
if (maxFld) maxFld.textColor = color.green;
this.getField("field #8").value = maxVal;
//get the min value
var minVal = Math.min.apply(null, valArray[0]);
var minIndex = valArray[0].indexOf(minVal);
var minFld = this.getField(valArray[1][minIndex]);
if (minFld) minFld.textColor = color.red;
this.getField("field #7").value = minVal;
//get the average value
var avgVal = total / valArray[0].length;
this.getField("field #6").value = avgVal;

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