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 need to create an interface that would allow a user to select multiple fields from a predetermined set of values. This needs to be connected to a filter which would all only the values that are selected to be displayed on the final export. Is this something that is possible? I could do it with one value, but how do you create the macro so that it can tell the filter to select multiple values?
The key might be to have your filter formula say something like: [Field] in ("A") rather than [Field] = "A"... then you can use the List Box Interface tool with an action that updates the "A" in the filter formula to be a concatenated list of the choices selected in the List Box. Set up your List Box as follows:
List all the predetermined options in the Properties box, one per line. Then by generating a custom list and separating with , delimiter, you can then use the Action tool to replace your "A" in the filter with the concatenated list ("A","C","D" for example). Action tool can be configured as follows:
See attached for sample workflow. Does that help? :)
Thank you for responding! I tried opening up your workflow but instead of downloading the program it displayed the coding in a browser window. I'm excited to see if this will work! Could you please try uploading the workflow again?