ListBox and Update value to feed into a filter

I feel like very similar questions have been asked but none that I've found has the same setting as I do. So here's another question for the experts:

- I'm looking up unique values from a column of an input

- Pass these unique values into a ListBox tool for user to pick out from

- Pass the picks from the user into a filter, by updating the values of these picks to a string, then use that string as filter criteria

- Export out the original input with user's picks filtered for.

I'm attaching the workflow here. Not sure why I just can't get the filter tool to pick up the selected values from ListBox. Thanks a million!

Filter Plant.yxwz

Workflow

Accepted answers

apathetichell

three things:

1) set your list box to custom list mode - not select mode. (something like " "," " as your seperators)

2) configure your filter too with a formula using IN (ie [Plant] in("1"))

3) set your action tool to replace "1" - including the quotes

I'd also recommend using recordid/crosstab/dynamic rename (first row of data) to prevent the swapping of special characters to _ in your list box.

All comments

apathetichell

three things:

1) set your list box to custom list mode - not select mode. (something like " "," " as your seperators)

2) configure your filter too with a formula using IN (ie [Plant] in("1"))

3) set your action tool to replace "1" - including the quotes

I'd also recommend using recordid/crosstab/dynamic rename (first row of data) to prevent the swapping of special characters to _ in your list box.

apathetichell

Play around with those instructions - if you are having an issue - look at the attached workflow.

Filter Plant.yxzp

Ychurc

Thank you @apathetichell for the quick response! I tried your suggestion above and it's still not giving me the desired outcomes. Thanks for any additional help!

1) set list box to custom list mode with "," as seperators DONE

2) configure filter tool with a formula using IN (ie [Plant] in("1")) DONE

3) set action tool to replace "1" - including the quotes DONE

4) I use crosstab to get the values for List Box tool.

Filter Plant.yxwz

apathetichell

Are you running as an app - and is browse(10) configured to be displayed in your interface designer? assuming there are special characters in your plant field - your workflow should work fine. see my .yxzp - you are not sending any sample data with your file.

Ychurc

I ran it as an app just now and it worked perfectly. Thank you @apathetichell !!

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335