Hi all,
I am building an App in Designer where the List Box Interface I am using is created dynamically from the data. i.e. if a field contains A,B,C the list interface will show A, B, C as the options to select. If it has A,B,C,D it will show all four. e.g. A Field is summarised, Crosstabbed and then used as the Fields from Connected tool on my List box.
My Filter tool is then set up to use the below whereby the values within the brackets are replaced by what is selected in the List Interface and data is filtered to what the user selects.
[Field] in ("A","B","C")Problem I have is that - The data can change, and whilst my user interface is dynamic based on what is in the data source, my Custom Filter is hardcoded as an In Statement to use in conjunction with the "update specific string" in the action tool.
Can i dynamically take the list from the source data and pass that into the Filter Expression / Action Tool? I tried using a batch macro with a control parameter but could not combine the App Interface with the Batch Macro to get it to work. Can try and post a sample workflow if the above explanation doesn't suffice.
Any help appreciated!
