Share
Report
5,331I had a formula that has been updated (thank you @WarrenBelz ).
Sort(
Filter(
ParkListCollection,
varIsProgramHierarchy = "National" || Park=varParkAlpha
),
Park
)
I've considered anew my desired outcome; it is - If User heirarchy equals 'Region' that User can only see parks in their region in the Combo Box. Everyone else can see all Parks.
Additional:
1. The 'Member List' and 'Park List' have columns titled 'Park' and 'Region'. A park could be 'Park A', 'Park B', 'Park C'. Each park could be in a different 'Region'
Region is used twice in this database 1) as a location identifier; 2) as a designated 'ProgramHeirarchy'; they are unrelated. A region name could be 'East', 'West', 'South', etc; while a park is could be 'Park A' or 'Park B', and one park could be in 'West' region and the other in 'East' region.
2. The member 'ProgramHeirarchy' is stored in a Text column of the MemberList, along with all other member data. Member 'ProgramHeirarchy' levels are 'National', 'Region', 'Park', 'Employee'.
3. I do have a variable currently called 'varIsProgramHierarchy', the content of which displays the current user's heirarchy. If I drop a label on the screen and put 'varIsProgramHierarchy' in the Text field the content returned is 'National' - which is my ProgramHierarchy.
I also have a varible that identifies the region of the User, and I have a dropdown (on the page but not visible and supports the Combo Box, that has the User's region name in it.
Again, what I need is for the formula to allow all members with a heirarchy of 'Region' to see only parks in the region, and all other members able to see all parks.
All responses (
Answers (
