Script on variable to ensure figure is divisible by 3

ebaileyybs
Tera Expert

Hi,

I am currently working on a HR on-boarding solution - one of the requirements is to have a script on a variable to check that the salary figure is divisible by 3.

Is anyone aware of a way to do this?

Thanks in anticipation!

Emma

1 ACCEPTED SOLUTION

HI Emma,



I've reproduced this on demo instance below. Please refer this for reference.


https://demo007.service-now.com/login.do


Username : admin


Password : admin


Record producer : Create incident.


Here is the final script with screenshots too.


function onChange(control, oldValue, newValue, isLoading) {


  if (isLoading || newValue == '') {


  return;


  }


  //Replace u_short with the column name of your variable.


  var sal = newValue%3;


  if(sal != 0)


  {


  alert('should be divisible by 3');


  g_form.setValue('salary',''); //Replace salary with the name of the variable you have created


  }


  //Type appropriate comment here, and begin script below



}


Screen Shot 2015-09-07 at 8.21.56 PM.JPG


View solution in original post

16 REPLIES 16

HI Emma,



I've reproduced this on demo instance below. Please refer this for reference.


https://demo007.service-now.com/login.do


Username : admin


Password : admin


Record producer : Create incident.


Here is the final script with screenshots too.


function onChange(control, oldValue, newValue, isLoading) {


  if (isLoading || newValue == '') {


  return;


  }


  //Replace u_short with the column name of your variable.


  var sal = newValue%3;


  if(sal != 0)


  {


  alert('should be divisible by 3');


  g_form.setValue('salary',''); //Replace salary with the name of the variable you have created


  }


  //Type appropriate comment here, and begin script below



}


Screen Shot 2015-09-07 at 8.21.56 PM.JPG


Kalaiarasan Pus
Giga Sage

Add a onchange script for the variable as


if(newValue%3 != 0)


{


g_form.setValue('variablename','');


}