This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a filter that I want to the user to be able to change based on the checkboxes that are selected. However, it's not working. The interface looks how I want butit's nto working. Pictures of filter and WF below.
You can do this by creating a custom list from the listbox matching the style of the "IN" function.
The "IN" function compares a value to a comma-delimited list to see whether it's equal to one of the members (e.g. 'A in("x", "y", "z")' returns true when A is "x" or "y" or "z" but false else).
In the listbox configuration, instead of having it create the list (which would look like ("x=True, y=False, z=True") in the default manner), create a list with "," as the delimiter and update the expression accordingly.
I'm attaching a minimal example. I used different names and values for the listbox elements to show that when you do that, the values get passed to the filter, not the names. It does work if the names and values are identical.
Ok. So this work if I list every county. The issue is the user will load different files from different states and therefore different counties. I need to have the app be able to dynamically change the the list that will show up.
It won't matter. The filter gets auto-populated by whatever is selected before pressing "Run" on the app. If you want an easier way (compared to tinkering with the macro/app) to change them frequently, see the different options on the listbox tool. One is "External Source"; it would be appropriate using this to save the set of values as a CSV with "NAME" and "VALUE" fields and update there (presumably automatically as part of whatever process you use to decide which values to include) whenever you want to update values.
* sorry - this was a reply to the post above (re when they change)