Complicated conditions to disable Text Input Field

[Dorinda]

@RandyHayes @mdevaney ,

I have formulas like this one

If(

    If(

        Value(label_year.Text) < Value(CurrentYear.Text),

        false,

        Value(CurrentMonth.Text) <= ThisItem.Month Or Value(label_year.Text) > Value(CurrentYear.Text)

    ),

    DisplayMode.Disabled,

    DisplayMode.Edit

)

Basically if the current year and current month are in the past they should be set to Disabled, otherwise they should be set to Edit.  As you can see 2019 and 2020 in blue both are editable.

The other issue with this is now in 2022 or any later year that fields that should be open to enter information is greyed out and the open ones in blue when you type anything immediately grey out even if you are not finished.  This is what is in that Original field If(IsBlank(TextInput2_6), DisplayMode.Edit, DisplayMode.Disabled)

 

 I am stumped why this is not working

Any help would be appreciated.

[gabibalaban]

Hi @Dorinda ,

Try a different approach to avoid the "complicated condition". 😊. What about ...

If(
Value(label_year.Text)*12+ThisItem.Month < Value(CurrentYear.Text)*12+Value(CurrentMonth.Text),
    DisplayMode.Disabled,
    DisplayMode.Edit
)

Hope it helps !

[WarrenBelz]

H @Dorinda ,

This should work

If(
   Value(label_year.Text) > Value(CurrentYear.Text) ||
   (
      Value(CurrentMonth.Text)>= ThisItem.Month &&
      Value(label_year.Text) = Value(CurrentYear.Text)
   ),
   DisplayMode.Edit,
   DisplayMode.Disabled
)

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.

[RandyHayes · Accepted solution]

@Dorinda 

The formula that seemed to do the trick was:

If((IsBlank(ThisItem.RevForeCast) && (Date(ThisItem.Year, ThisItem.Month, 1) > Date(Year(Now()), Month(Now()), 1))) || 
    (Date(ThisItem.Year, ThisItem.Month, 1) = Date(Year(Now()), Month(Now()), 1)), Edit, Disabled)