Known Participant

Answered

Having a cell not populate without specific data

Forum|Forum|5 years ago
September 3, 2020
1 reply
1135 views

I have a total field for a simple calculation from data from two other fields. What I'm trying to do is have the total field not populate if one of the two data fields doesn't have data. I would like also for the total field to be greyed when total = 0 or less.

This topic has been closed for replies.

Correct answer Nesa Nurani

Add this to the code:

event.target.fillColor = event.value <= 0 || event.value == "" ? ["G",.7 ] : color.white;

Community Expert

Community Expert

For calculation you can use this:

var a = this.getField("Text1").value;
var b = this.getField("Text2").value;
if(a == "" || b == ""){
event.value = "";}
else event.value = a+b;

For grey out , you want border and fill color (or just fill color) to be grey if value <= 0? And what color should it normaly be?

JetFixxxerAuthor

Known Participant

Thank you, much apprieciated.

I would like it to be just fill color. It's normally white and would like it to be grey when not populated.

Inspiring

And what if value is empty what color then