Color based on Calculated Result

Hello @gerikg

If the calculated field is, for example, the fieldname123, you can use the getField operation to get its object representation. The getField operation requires the number part of the field’s name. The equation would be similar to:

(function(){
    var field = getField(123).jQueryRef().find('input'),
        color = 'Green';
    if(fieldname8*fieldname9*fieldname10*fieldname11==0) color = 'Red';
    else if(fieldname8*fieldname9*fieldname10*fieldname11<9) color = 'Yellow';
   
    field.css('color', color);
    return color;
})()

Best regards.

I appreciate your help. Any thought of adding this to the documentation or blog on your website? I have 7689327 questions and I can’t “Script”

Hello @gerikg

I’ll keep this in mind for a new blog post ??

If you have any other question do not hesitate in contact me again.

Best regards.

OKay I figured that the code says if the answer is X then the font color is X.

After using your code the yellow is unreadable behind a white background.

1. Is this javascript?
2. can yellow be dark yellow? I’m assuming you have to rework everything.

Hello @gerikg

You can use colors code instead of colors names.

(function(){
    var field = getField(123).jQueryRef().find('input'),
        color = 'Green',
        color_code = '#439832';
    if(fieldname8*fieldname9*fieldname10*fieldname11==0)
    {
        color = 'Red';
        color_code = '#983232';
    }
    else if(fieldname8*fieldname9*fieldname10*fieldname11<9) 
    {
        color = 'Yellow';
        color_code = '#bfbd33';
    }   
    field.css('color', color_code);
    return color;
})()

You can use the colors code you prefer.

Best regards.