My app currently tracks the number of days since we last invoiced our client with a DateDiff function
DateDiff(DataCardValue12.SelectedDate,Today())
I have placed circle icons on my app that I want to change color based on how many days it has been since the invoice has been sent (like a color status update).
A green circle for most recent and red being a very long time.
It seems sooooo easy but I cannot figure it out. Here is my if statement in the fill property of a circle:
If('Number of Days' > 1, Green, LightGray)
*Number of Days is name of the text label where the DateDiff function is found
The error I get is that If statement is expecting a number but I've tried 'Number of Days'.Value and that doesn't work either.
Thanks for the help!
Solved! Go to Solution.
Hi @zalandoe
If(Value('Number of Days'.Text) > 1, Green, LightGray)
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @zalandoe
If(Value('Number of Days'.Text) > 1, Green, LightGray)
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks so much! I thought I had tried that solution at one point and dismissed it completely!
Woah, that is great. Thanks!
haha oops he beat me to it
Hi Reza,
I have same scenario of this problem but i cannot figure it out how to work. Can you also please help?
I have a TextInput box and a rectangle color box, i want to change the color based on the values of the text input.
here is my code. but i cannot work on the between value of between <=0.5 and <=0.9.
If(Value(TextInput2.Text) < 0.5, Red,
If(Value(TextInput2.Text) <=0.5 && Value(TextInput2.Text) <= 0.9, Yellow,
If(Value(TextInput2.Text) >=1, Green,
Black
)))
i need to do color coding in the box based on this formula.
<0.4 | Red |
<= 0.5 and <1 | Yellow |
>=1 | Green |
Thanks in Advance
Echo
User | Count |
---|---|
229 | |
109 | |
94 | |
57 | |
30 |
User | Count |
---|---|
291 | |
126 | |
106 | |
62 | |
57 |