Skip to main content
JetFixxxer
Known Participant
Sep 3, 2020 1:20 PM UTC
Answered

Having a cell not populate without specific data

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 is closed to new replies. Start a new post to keep the conversation going.
Nesa Nurani
Nesa NuraniCorrect answer
Community Expert
Sep 3, 2020 3:18 PM UTC

Add this to the code:

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

View reply

5 replies

Nesa Nurani
Community Expert
Nesa NuraniCommunity Expert
Community Expert
Sep 3, 2020 2:01 PM UTC

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?

Translate
    JetFixxxerAuthor
    Known Participant
    Sep 3, 2020 2:43 PM UTC

    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.

    Translate
    Asim123
    Inspiring
    Sep 3, 2020 3:13 PM UTC

    And what if value is empty what color then

    Translate
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices