Hi I want to configure my drop down tool to be able to select a user's name in the workflow which will feed into a formula tool that has If/Then statements that will generate different outcomes in columns when a specific user is selected?
Ok that worked thanks! If I select a name from the drop down when I run workflow, how do I exclude all other names from outputting to rows?
@Khristian_Evans Your formula tool should connect your input file, the input text tool, which contains the names, you can keep it separate, you don't need to connect the input text with the formula tool.
Also, check out these links:
https://help.alteryx.com/current/en/designer/tools/interface-tools/drop-down-tool.html#drop-down-too...
https://community.alteryx.com/t5/Tool-Mastery/Tool-Mastery-Drop-Down/ta-p/37094
You can also right click on the Drop Down tool and open the example.
Also, the sample under "Help > Sample Workflows > Use Scripting and Automation Tools > Build an app > 06 Calculate a mortgage payment" has dropdowns in it.
User | Count |
---|---|
60 | |
24 | |
24 | |
21 | |
21 |