cancel
Showing results for
Did you mean:
Helper V

How to use And/Or

How can I perform an And/or check behind a button

This one works fine

If(Value(Blood1.Text) >= 120 && Value(Blood1.Text) <=129  && Value(Blood2.Text) < 80 ,Set(colorset,"#ffff1a");Set(txtval,"ELEVATED"));

But what if I want to check two text box values using an and/or calculation?
If textbox1 > 80 and/Or  textbox2 > 120

Thanks
1 ACCEPTED SOLUTION

Accepted Solutions
Super User III

I know what the issue is... I needed to invert the order displayed on the chart when coding it, lol.

``````If(
Value(Blood1.Text) > 180 Or Value(Blood2.Text) > 120,
Red,
Value(Blood1.Text) >=140 Or Value(Blood2.Text) >= 90,
RedOrange,
(Value(Blood1.Text) >= 130 Value(Blood1.Text) <= 139) And (Value(Blood2.Text) >= 80 Value(Blood2.Text) <= 89),
Orange,
(Value(Blood1.Text) >= 120 Value(Blood1.Text) <= 129) And Value(Blood2.Text) < 80,
Yellow,
Value(Blood1.Text) < 120 And Value(Blood2.Text) < 80,
Green
)``````

13 REPLIES 13
Super User III

If(Value(Blood1.Text) >= 120 Or Value(Textbox2.Text) > 120&& Value(Blood1.Text) <=129  && Value(Blood2.Text) < 80 Or Value(Textbox1.Text) > 80,Set(colorset,"#ffff1a");Set(txtval,"ELEVATED"));

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Super User III

@sienna28
Can you please clarify what you want to do with this code?  I don't understand having both the AND and the OR.

If textbox1 > 80 and/Or  textbox2 > 120

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Helper V

It just needs to work for these values

If textbox1 > 80 and/Or  textbox2 > 120

Super User III
@sienna28
I guess what i am asking here is do you want the condition to be AND or OR for your code above: it cannot be both.
Helper V

If you notice the second value is where the And/Or is done

Super User II

In your example, the And is irrelevant.  If either value is outside of the range, the result will be flagged. I would just go with the Or condition.

Super User III

``````If(
Value(Blood1.Text) >= 180 Or Value(Blood2.Text) >= 120,
Set(colorset,"#ffff1a"),
Set(txtval,"ELEVATED")
)``````

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Helper V

Hi

That looks like it could be it, but I am not sure how it reads.

Could you please explain that logic to me....does the 180 value come into it?

Many thanks

Helper V

I've attached a better graphic which shows what I am trying to do.

Using the Or condition only in the last option triggers the one above it.

Announcements

Welcome to the User Group Public Preview

Check out how to claim yours today!

Test your skills now with the Cloud Skill Challenge.

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!