Help with settings controls and showing a gallery subgroup

Copper Contributor

I am having some trouble accomplishing 2 tasks.


For reference: 

Datasource is excel file (Table1)

gallAll.Items = GroupBy(Table1, "Hospital", "grpByHosp")

gallHosp.Items = Sort(Filter(Table1, And(ThisItem.Hospital = Hospital)), Room, Descending)


1. How to make toggHosp toggle show/hide corresponding subgroup.


2. How to selectively set toggHosp toggle via the buttons (ALL,SR,N,S). For Example, N button selects MRMC and unselects all others.


Screen Shot 2020-06-22 at 2.06.32 PM.png

Screen Shot 2020-06-22 at 2.07.01 PM.png

1 Reply

Answered my own 1st question. Just set gallHosp.Visible = toggHosp.Value. Still looking for help with #2.