Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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','');


}