Choose between three

I have an app where the user has an option to choose between three selections. They can choose a short report, a long report or a third referred to as an extended report. The short and long are Allocate reports and the third, extended, report runs a macro to build a report. I've tried the detour tool but I don't think it'll work. I've tried a filter but since I'm not searching for a variable to change I'm not sure how I'd use it? I could create a variable, use the interface tool to change the variable then use the filter tool to separate it out from there on...

anyone have anything better? I'm all ears.

Thank you,

Brad

Choose between three.jpg

Developer Tools

Input

Output

Preparation

Interface Tools

Accepted answers

NicoleJohnson

What if you put each branch into a tool container, then you could use the selector tool to indicate which tool container to disable/enable based on which path you wanted it to take for each? Then it would only run through the Allocate report branch if you selected Short or Long (by indicating the tool container is enabled for Allocate Report and disabled for the macro), and then would only run through the macro if you selected Extended (enabling macro tool container, disabling Allocate tool container). Would that accomplish what you're looking for?

NicoleJohnson

You actually shouldn't need the connection tool or the action tool - you can connect the radio buttons directly to your formula tool. See image below - the formula you typed in the condition tool can just go directly into the formula tool. That should do the trick!

All comments

NicoleJohnson

brad_j_crep

It might work but I went with a double filter. I added a column named 'type' which would hold one of the three types "short, long, extended" placed there by the interface tools(List box). The first filter separates the macro report from the allocate reports and the second filter separates the two allocate reports. In the end it all comes back together with the union tool. I'll have to try the containers on the next app. Thank you for your time and idea. Much appreciated.

Brad

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703