List Box Tool Configuration

[CamilleB]

Hi,

I am trying to create an app that will allow the user to choose multiple attributes that will generate a single report from those attributes that were chosen by the user. 

I am at the finish line with this but got stuck in the correct formula to use. 

Filter Tool ConfigAction Tool Config
List Box Tool Config

Could someone help me with the correct formula to use? There will be about 72 listings for the user to choose from. 

[SamJHolmes]

Hi Camile,

Do you think you can attach a copy of your workflow so I can dig into this a bit deeper?

Thanks

Sam

[CamilleB]

Hi Sam, 

Yes sure.

Please see attached.

I basically removed the information that was placed in the text box tool with "**Information Entered Here**" as the information was sensitive. But you will get a gist of how the workflow is, or how I am trying to get it to work.

[DavidxL · Accepted solution]

I think it would be easier to use the List Box in Select Tool mode and use some Transpose/Cross Tab to Join instead of Filter.

I've attached an example. I'm using a custom macro "Special Character Cross Tab" which is my version of "Cross Tab Real" by Ben Moss to Transpose while retaining the spaces in the column names.

[CamilleB]

Thank You!