If(
IsBlank(Checkbox1.Value) Or (IsBlank(DatePicker1)),
DisplayMode.Disabled,
DisplayMode.Edit
)
Currently doesn't work correctly even though i have no errors
Solved! Go to Solution.
Swap the logic and check for if one is present, and if so use Edit, otherwise use Disabled.
If(
Checkbox1.Value Or (!IsBlank(DatePicker1)),
DisplayMode.Edit,
DisplayMode.Disabled
)
Now, if either the checkbox is checked, or the Date Picker is not blank, the other box will be enabled, otherwise it will be disabled:
in fact Checkbox1.values is already boolean, so you can try like this
If(
Checkbox1.Value Or (IsBlank(DatePicker1.SelectedDate)),
DisplayMode.Disabled,
DisplayMode.Edit
)
Hi,
Please try using below formula -
If(
Checkbox1.Value && !IsBlank(DatePicker1.SelectedDate),
DisplayMode.Edit,
DisplayMode.Disabled
)
or you can try below one
If(
!Checkbox1.Value Or IsBlank(DatePicker1.SelectedDate),
DisplayMode.Disabled,
DisplayMode.Edit
)
Your formula as given
If(
IsBlank(Checkbox1.Value) Or (IsBlank(DatePicker1)),
DisplayMode.Disabled,
DisplayMode.Edit
)
Will not work if the checkbox is unchecked.
So try it like this instead:
If(
!Checkbox1.Value Or (IsBlank(DatePicker1)),
DisplayMode.Disabled,
DisplayMode.Edit
)
Check if it helps @olsen9
These work but only if you have a date included, and click checkbox,then the 2nd box is enabled. as you can see I want either the top fields to be checked or have a date added to enable the disabled box below. Here is my example of it not working as I checked checkbox1
Swap the logic and check for if one is present, and if so use Edit, otherwise use Disabled.
If(
Checkbox1.Value Or (!IsBlank(DatePicker1)),
DisplayMode.Edit,
DisplayMode.Disabled
)
Now, if either the checkbox is checked, or the Date Picker is not blank, the other box will be enabled, otherwise it will be disabled:
| User | Count |
|---|---|
| 128 | |
| 99 | |
| 98 | |
| 89 | |
| 61 |
| User | Count |
|---|---|
| 170 | |
| 151 | |
| 127 | |
| 109 | |
| 98 |