Field Styles - Comparing two decimal values on a record

Jamsta1912 · ‎12-30-2018

Hello all,

I'm having some trouble with field styles.
I have two fields on a table, both of type 'Decimal'. I would like 'u_my_field1' to have a light green background on the form if it has a value less than or equal to that in 'u_my_field2'.

I've created a field style with this condition (value):

javascript: parseFloat(current.getValue('u_my_field1')) <= parseFloat(current.getValue('u_my_field2'))

I'm looking at an example record where 'u_my_field1' = 2.2, and 'u_my_field2' = 15.78, but the value is not being returned as TRUE (or at least, the field style is not showing). If I remove the condition (value) from the Field Style completely, the field style does show on the field on the form (ie the background is light green). Any thoughts on this?

Alikutty A · ‎12-31-2018

On Form, the field styles dont work. They are for the list views. You need to write an onLoad or onChange client script to make this possible.

OOB, SN has used an onChange client script to highlight a caller as VIP on the Form. This is implemented by a client script named "Highlight VIP Caller".

Here is its link

https://instance_name.service-now.com/nav_to.do?uri=sys_script_client.do?sys_id=8f0b3ee00a0a0b5700e75f4aaabe4953

Replace instance_name with yours.

You need to create a similar client script for your logic. Sample script i have added here for your case, it may need modifications according to your styles and requirement.

function onLoad(){

//Replace field_name at where you need to display this icon
var Label = $('label.incident.field_name').down('label');  
var Field = $('sys_display.incident.field_name');
if (!Label || !Field)
  return;
}

if(parseFloat(g_form.getValue("u_my_field1")) <= parseFloat(g_form.getValue("u_my_field2")){

 var bgPosition = "95% 55%";
 if (document.documentElement.getAttribute('data-doctype') == 'true')
  bgPosition = "5% 45%";

//Apply your required CSS here - This is a sample one
 Label.setStyle({backgroundImage: "url(images/icons/vip.gif)", backgroundRepeat: "no-repeat", backgroundPosition: bgPosition, paddingLeft: '30px' });
 Field.setStyle({color: "red"});
} else {
//Reset CSS if condition fails
 Label.setStyle({backgroundImage: ""});
 Field.setStyle({color: ""});
}
}

View solution in original post

Jace Benson · ‎12-30-2018

This works for me.

End Result:

Code to copy;

javascript: parseFloat(current.getValue('u_number_1')) <= parseFloat(current.getValue('u_number_2'))

Styling;

background-color: green

With all that being said.

I'd check the field names are in fact what you think they are.

Luke Van Epen · ‎12-30-2018

If you run the same script in a background script via GlideRecord does the condition evaluate to true? If so, it may be a platform defect to raise through HI

Example script

var recordGR = new GlideRecord('your_table');

recordGR.get('record_sys_id');

var val1 = recordGR.getValue('u_my_field1');

var val2 = recordGR.getValue('u_my_field2');

gs.info(var1 <= var2); // should return true

gs.info(parseFloat(var1) <= parseFloat(var2)); // should return true

Alikutty A · ‎12-30-2018

Hello,

Can you try this as Value and check if it works?

javascript: parseFloat(current.u_my_field1) <= parseFloat(current.u_my_field2)

Thanks!

Jamsta1912 · ‎12-30-2018

Hi guys,

Thanks for the responses. When I run the expression in a background script, I do get the values I expect. I tried Alikutty's syntax but I still get the same result. My field names are correct. So I'm a little mystified, and perhaps it is a genuine bug.

Jamie