I have two galleries. The first one filters the second based on the selection. Each gallery has an indicator and then the months. When the month is clicked on it will bring up the second gallery that shows the indicator and the neighbourhoods. The first indicators works perfect but when I go to click on the second indicator the screen comes up blank.
On the second gallery I have it filterd by the table, village and then indicator from the pervious gallery.
The frist gallery shows the indicators and the months. When you click on the January textbox it will then navigate to another screen (gallery 2).
As you can see there are two indicators on the main screen. When you click on Janaury for the first indicator it filters the next gallery perfectly. See below.
But when you click on the second indicator it navigates you to the next screen (gallery) and it is blank. See below.
I don't understand why the first indicator in gallery works but the second indicator doesn't.
Here is the forumla that I am using on the second gallery: Filter(table4, Village = varLocation, Indicator = RHCCGallery.Selected.Indicator).
Did you get a chance to look at the solutions I provided over in your other post earlier?
That might be helpful for this scenario as well.
Beyond that, can you explain the indicators you make reference to and how that relates to table4.
I did get a chance to look at the app your provided early and I do not understand one bit. I have attached my excel file so you can see how I have that set up and how I am pulling in the data. I have also shared the app so you have see where my brain is. I may be way off from what I am trying to do but this might help you better understand what I am looking to accomplish.
SO in regards to the gallery issue. I have created a gallery that shows each indicator that fall under the filter I have set. When you look at the excel file you can see that there is a column for KeySuccessFactor and a column for IndicatorGroup. Based on the screen it will show the filter pertaining to the screen name. eg. Customer Experience Screen is filter using Filter(Table1, KeySuccessFactor = "Customer Experience"). Now if in the table a indicator is given a collectionlevel of neighbourhood it will navigate to a screen where they can enter neighbourhood data. What I thought I had set up and working was that when they click on an indicator that has a collection level of neighbourhood it will navigate to the neighbourhood screen and update the Indicator label to the name of that indicator that previously clicked on.
You can see what I have put together when you look at the Care Conference Screens.
Hope this helps.
I'll take a look at what you have provided. I might pull this conversation into a private message chat rather than keep building on this posting.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021