DisplayMode Formula Help

(2) Share

Report

Posted on by Brook0131

I am trying to make DatacardValue22 Disabled when two conditions happen.

1. When Datacardvalue8 is <10,000,000 and Datacardvalue10 equals Commercial or International

When Datacardvalue8 is <100,000,000 and Datacardvalue10 equals US Government

Here is the Code I am using in the DisplayMode or DatacardValue22:

If(Value(DataCardValue8.Text)<10000000 And Value(DataCardValue10.Selected.Value = "Commercial" || "International" Or Value(DataCardValue8.Text)<100000000 And Value(DataCardValue10.Selected.Value = "US Government")),DisplayMode.Disabled)

Any suggestions? It is working for the first condition just not the 2nd one.

All responses (3)

Answers (1)

timl 34,935 Super User 2025 Season 1 on at

Like (1)

Report
Re: DisplayMode Formula Help

Hi @Brook0131

I would try adding extra brackets around the first condition like so:

If( ( Value(DataCardValue8.Text) < 10000000 And ( Value(DataCardValue10.Selected.Value) = "Commercial" || Value(DataCardValue10.Selected.Value) = "International" ) ) Or ( Value(DataCardValue8.Text) < 100000000 And Value(DataCardValue10.Selected.Value) = "US Government" ), DisplayMode.Disabled )
ivan_apps 2,187 Super User 2025 Season 1 on at

Like (1)

Report

Re: DisplayMode Formula Help

If(
Value(DataCardValue8.Text)<10000000
&& ( DataCardValue10.Selected.Value = "Commercial"
|| DataCardValue10.Selected.Value = "International"
|| DataCardValue10.Selected.Value = "US Government"),
DisplayMode.Disabled
)

In either case you are checking for Value < 10000000 so that's a constant check, you only have to add it once.
You also don't have to wrap text comparisons in a Value(), that will try to turn it into a number.
Verified answer

ANB 7,075 Super User 2025 Season 1 on at

Like (2)

Report
Re: DisplayMode Formula Help

HI @Brook0131 Try this:

If( Or( And( Value(DataCardValue8.Text)<10000000 , DataCardValue10.Selected.Value in ["Commercial", "International"] ), And( Value(DataCardValue8.Text)<10000000 , DataCardValue10.Selected.Value = "US Government" ) ), DisplayMode.Disabled )

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB