Skip to main content
Known Participant
Aug 15, 2020 1:17 PM UTC
Answered

Change text color using javascript

I tried everything I can think of and just can't get this to work.In my "field1" validate tab I use this custom code

if(event.value > 0){event.target.textColor = color.blue;
}else if(event.value < 0){event.target.textColor = color.red;
}else if(event.value == 0){event.target.textColor = color.white;
}

field1 get it's value from another field. I want it to show if 0= white, if bigger then 0=blue, if lower then 0=red but the colors are mixed up,for example if number is 5 it should be blue but is white, 0 is red and -2 is blue but in field properties it shows correct color ( example in the field1 value is 5 it show white color but in properties it's blue) .If I enter value manually it doesn't change colors at all.

This topic is closed to new replies. Start a new post to keep the conversation going.
try67
try67Correct answer
Community Expert
Aug 15, 2020 3:07 PM UTC

I try and it didn't change anything.


Try this code:

 

var v = Number(this.getField("fieldname").valueAsString);
if (v > 0){
	event.target.textColor = color.blue;
} else if (v < 0){
	event.target.textColor = color.red;
} else if (v == 0){
	event.target.textColor = color.white;
}
event.value = v;

 

If it doesn't work check the JS Console for error messages.

6 replies

Bernd Alheit
Community Expert
Community Expert
Aug 15, 2020 1:23 PM UTC

How does get field1 the value from the other field?

Translate
MarietaaAuthor
Known Participant
Aug 15, 2020 1:41 PM UTC

With custom calculation script 

event.value = this.getField("fieldname").value;

Translate
Bernd Alheit
Community Expert
Community Expert
Aug 15, 2020 2:52 PM UTC

Use your other script also there.

 

Translate