Use List Box to decide which containers to run in a Macro

I have a macro with 8 containers (each with a macro output). For the sake of this post, the containers are named 1-8. I want to use a list box so the user can check which containers they would like to run. I need help making these connections. Not sure if an action tool or a condition tool is needed to connect to the list box and if so, how to configure them.

Thanks in advance!

Containers2.png

Containers.png

Macros

Interface Tools

Accepted answers

apathetichell

delete the condition tool. it goes listbox-> action tool -> container. no condition tool. Having said that ---> you want IN - not contains. let me give you an example:

contains('hello','hell') ---> true

'hell' in ('hello') - false

in looks for a distinct element in a list of elements. contains does a character match. if you had 11 containers and were searching using contains:

contains('container 11','container 1') -> would be true.

'container 1' in ('container 11') would be false

All comments

apathetichell

are these standard containers or control containers? it's easiest to use the listbox in generate list mode pass it into an expression via an action tool and to update a value in an IN expression so like 'myvalue' in ('values generated from my listbox') ---> when your listbox containcs values like 'myvalue1','myvalue2' etc---> and at run time your expression becomes 'myvalue' in ('myvalue1,'myvlaue2') because of the actio tool.

to have the listbox update the cotainers eanbled/disabled property you would need to update this element via an action tool with a formula. the formula would be 'test' in (#1) ---> where #1 is the result of the listbox. 'test is a specific value relating to a specific container. This would yeidl either a true or false which would enable/disable the container base upon it's underlying setting.

apatel1501

I think i follow. I am using standard containers.

I connected my list box in generate list mode to a condition tool and used the following formula: contains([#1],"Container1=True") and connected the True side of the condition tool to an action tool to enable/disable container from condition.

But it won't let me connect the action tool to a container for some reason. Screenshots attached. When i try to do connect the action tool, it won't allow it.

@apatel1501 go through the below post

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Option-to-select-which-container-is-to-be-run/td-p/753340

apathetichell

delete the condition tool. it goes listbox-> action tool -> container. no condition tool. Having said that ---> you want IN - not contains. let me give you an example:

contains('hello','hell') ---> true

'hell' in ('hello') - false

in looks for a distinct element in a list of elements. contains does a character match. if you had 11 containers and were searching using contains:

contains('container 11','container 1') -> would be true.

'container 1' in ('container 11') would be false

apatel1501

Perfect - thanks!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703