I have Main Screen, or which are 'Container1' and 'Container2'.
Both containers have a dropdown that have a list of views.
In 'Container1' visible I have If(Current_View_Dropdown_1.Selected.Value="Edit View",true,false)
In 'Container2' visible I have tried If(Current_View_Dropdown_1.Selected.Value<>"Edit View",true,false)
and I've tried If(Current_View_Dropdown_2.Selected.Value="Edit View",false,true).
I can get 'Container1' to hide, but I can't get 'Container2' to appear. I keep getting a circular reference error.
How do I get the two containers to appear independent of each other?
What am I missing?
Yep.
Wrestled with it yesterday for an hour or so until I got it in a bare-naked chokehold, figured it out and got it working.
Thanks!
Ok, I think I understand now. Basically Container 1 is an edit and Container 2 is a "view only", and either drop down can make it edit or view only. Please try the following:
Container 1 OnChange:
If(
"Edit View" in Dropdown1.SelectedText.Value || "Edit View" in Dropdown2.SelectedText.Value,
Set(var_Edit,true),
Set(var_Edit,false)
)
Container 2 OnChange:
If(
"Edit View" in Dropdown1.SelectedText.Value || "Edit View" in Dropdown2.SelectedText.Value,
Set(var_Edit,true),
Set(var_Edit,false)
)
Container 1 Visible:
If(var_Edit,true,false)
Container 2 Visible:
If(var_Edit,false,true)
I've been playing with it for about an hour.
I've almost got it working. There needs to be a way to reset Dropdown_1 to 'Edit View' in the Onchange of Dropdown_2, or they both are visible at the same time.
I've entered the formulas exactly as you have suggested.
With 'Container1' dropdown showing 'Edit View' and 'Container2' NOT showing 'Edit View', both containers appear, when only Container1 should appear.
'Container1' (with Edit View) -
When I change 'Container1' dropdown to other than 'Edit View' (and 'Container2' is NOT 'Edit View'), 'Container1' remains and 'Container2' disappears, when it should be the opposite. If neither container is 'Edit View' 'Container2' should be visible.
When 'Container2' dropdown is 'Edit View' it should be hidden and 'Container1' should be visible.
Container1 -
Hi!
Are you wanting the selection of drop down 1 to show/hide container 2 and vice versa?
If so, I would set a variable in the onChange event of each drop down.
For Container 1's OnChange:
If(
Current_View_Dropdown_1.Selected.Value="Edit View",
Set(var_showContainer2,"true"),
Set(var_showContainer2,"false"))
For Container 2's OnChange:
If(
Current_View_Dropdown_2.Selected.Value="Edit View",
Set(var_showContainer1,"true"),
Set(var_showContainer1,"false"))
And then your visible on Container 1 would be:
If(var_showContainer1,true,false)
And likewise the visible on Container 2 would be:
If(var_showContainer2,true,false)
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional