Skip to main content
kathleenl19432913
Participant
May 8, 2018
Question

Javascript code - change text box fill

  • May 8, 2018
  • 2 replies
  • 425 views

I have 2 boxes - 1) Is a running total 2) Cash Avail.  I want to write code that will change the Running Total fill to red if the amount is above the Cash Avail

Here is what I have

var RT = this.getField("Run_Total");

var CA = this.getField("CashAvail");

if(RT.value > CA.value){

event.RT.fillColor = color.red;

}else {

event.RT.fillColor = color.transparent;

}

I also tried

var RT = this.getField("Run_Total").value;

var CA = this.getField("CashAvail").value;

if(RT> CA){

event.fillColor = color.red;

}else {

event.fillColor = color.transparent;

}

But nothing happens.  I am sure I am missing something.very simple

This topic has been closed for replies.

2 replies

Inspiring
May 9, 2018

It should not.  Are you sur RT is empty.  Because anything, including a SPACEBAR will be evaluated as something bigger than nothing.

Inspiring
May 9, 2018

The second option is the good one.  You can put the script in the calculate event of "Run_Total".

var RT = event.value;

var CA = this.getField("CashAvail").value;

if(RT > CA){

event.target.fillColor = color.red;

}else {

event.target.fillColor = color.transparent;

}

Remember that if you have the option to enable the highligthing of fillable fields, they always appear blue (kind of a darkerish blue when not transparent).

kathleenl19432913
Participant
May 9, 2018

THANK YOU MatLac!  That seemed to work.  But now when the page is blank (initial load) that field is filled red - even when I clear all fields.   Should I add something that would make is transparent on load?