Having problems getting a RG Row to collapse when setting the element of one of the rows in the RG to not be visible.
Scenario:
Have a RG set to display options from Options Table. The RG is in a Row Group.
Have an Input element inside a Row Group inside the RG to display options from an Options Table.
RG Initially displays all Options and sets the Default Option To “Any”
Have 2 canvas slides - 1 for Upper Case and 1 for Lower Case
When either slide is set to “No”, the corresponding cell in the RG is set to not be visible. When the slide is set to “Yes”, the corresponding cell in the RG is set to be visible.
Want to collapse the height of the cell/RG/Group so that the space taken up by the option is not displayed.
What’s happening.
Element containing the option isn’t displayed when the slide is set to “No”. But the element isn’t collapsed.
Am including a link to the application.
To test, you can
Click on the down arrow. The RG will populate with the options. And the select input element will display Any.
You can select “Lower Case” from the rows by clicking on the row and the select input element will display “Lower Case”. The dropdown (RG) will be hidden.
You can slide the slide the “Lower Case” slide to the off position (“No”).
You can click on the dropdown arrow. The row containing “Lower Case” will be blank but not collapsed.
I’ve set the groups containing the RG, the RG, and the input in the RG to collapse and Fit Height to Content. And I’ve set Min Height and Max Height as I think they should be set.
Their are workflows used to trigger setting custom state values as well as showing/hiding the dropdown Group/RG/Input.
I know the goal is to change the Data Source before the RG is populated, but in my case (as least as I can figure out right now), I need the Data Source fully populated when the page is loaded. And options restored when the corresponding slide(s) are set to Yes.
Not sure how I would filter the data source. I currently set a state value for Upper Case to yes, and a state value for Lower Case to yes at Page Load. And then when the slides are set to No or Yes, I set the same states to yes or no to enable/disable the cell value being displayed or not.
How would I set the filter on the data source to include/not include the options at page load and then when the slides get changed?
I get that. But how do you combine multiple criteria into one data source filter to get an OR. I tried using filter merge filter - with separate criteria for each filter. And all it does is display the last criteria - regardless of which criteria i put first. And I can’t find the Advance option when I use filter to set up an OR.
I have an options table with 5 options.
All
Lower Case
Number
Special Character
Upper Case
Do you? Because you literally asked the same question again in this thread.
The merged with operator should do the trick… not sure why it’s not working for you. If you are trying to use an advanced filter (and I’m guessing you know the filtering takes place on the client side), you will find the Advanced option at the very bottom of the dropdown when you add a constraint to the :filtered operator.
I asked it because I see posts where people have supposedly got it to work after the data source is loaded. But it’s more fun to hit your head on a wall for an hour…
I clicked the link in your initial post in this thread, but it doesn’t look like it’s accessible anymore, and it’s kind of hard to understand exactly what you are trying to do. One question that comes to mine, though, is do you have to use a repeating group to create the dropdown? I mean, why not use a regular dropdown element?
Yeah, I didn’t realize you are trying to show options from an option set in a repeating group for the purpose of making a dropdown (you added the screenshots after I replied about the advanced filter, although you did call it out in the initial post, but I didn’t really put it all together… my bad).
I did originally. But that was before I was filtering the data source. What I was originally was planning to do was using one or more slides to inactivate rows in the dropdown list. And I was told that there wasn’t a way to do that in a regular dropdown - I needed to use an RG. Now I’m just planning to not show them in the dropdown when the slide is set to No. I will probably go back to using a regular dropdown.
For what it’s worth, I would almost certainly do that.
Sorry, I’m not following what you mean by slides that inactive rows. If you can share some screenshots that make it clear what is supposed to happen from a user experience perspective, I’m guessing we can figure something out.
I want to display all of the rows from the options table on page load. So I’ve set custom states (yes/no) for each of the rows to tell the system to display them on page load. I need to create a filter that merges each of the custom states together - that check each custom state for a yes value and the corresponding row from the options table is the same.
I then have slides for each option that are used to filter the options during use. Here’s an example of two of the slides.
When the user clicks the slide into the No position, the system will filter out the corresponding value in the data source. So for the Upper Case slide, the value Upper Case will be filtered out and the dropdown should collapse around the row. When the user triggers the slide into the Yes position, the system will add the row back into the dropdown and expand around the row.
As mentioned earlier, I was originally going to grey out (inactivate the option) in the list when the slide was set to No. That way the user could not click on the option for further processing. Now I’m just removing the option from the data source instead - if I can get the merge to work.
Still don’t have permission to view the link… go to the Settings >> General tab and set the application rights to everyone can view (or edit, if it’s just a test editor).
Okay, check out the regular dropdown I added, and click the toggles to off to see the associated option removed from the dropdown. Is that what you want?
