Please I need help applying color change to a calculated value control. I want the color of the control to change based on the calculated value.
I tried using the rules. the color change appears on the control but does not go beyond the text area.
I tried an alternative method of putting the calculated control in a panel, and then applied the rule to the panel. The result was almost the same.
Solved! Go to Solution.
Hi Frank Mendes!
This is interesting - I ran a test using some simple filler data:
Here's my Calculated Value - just an IF statement looking at the radio buttons I placed above. Is it Red? Cool, display "Red". If not, display "Green".
As you can see, I also extended the "walls" of my Calculated Field well beyond the text. Then, I created a rule on the Calculated Field itself -- "Am I green?", it asks itself. If it is, it formats to have a green backfill.
Now .. my experience isn't matching yours, as you can see. I have a beautiful nuclear green square, fully filled.
So I can only assume we're doing SOMETHING different here. What might it be? Do you see anything?
Thanks for your response Rhia.
I did exactly the same thing. Except that I set the Fill color for the calculated value to yellow in the formatting section at the top panel of nintex. I will check to see if this changes my result.
Hey Rhia Wieclawek,
I just had a look at the described problem by Frank Mendes and found out why it works for you but not for him. The background color of your control still has the default color, but his control is colored yellow.
When I now implement the described rules I get the following result:
The formating rule obviously isn't applied on the column in which the text can be found :-(
For the moment I don't have an idea how to work around this.
Oh man, that's interesting! I think I might play around that when I get home today....
Alright, so, I see what you mean!
Here is the only way I seem to get around it at the moment (without code.. I am very pro-no/low-code...)
This worked out for me, but I'm not sure of your precise needs. Let me know!