List box linking to formula

[vishtrack]

Hi folks,

I have a specific scenario where I need to link the List box from interface tool to Formula tool.
Based on the selection on the list tool, the values in the If condition needs to change. How do I achieve this?

[apathetichell]

via an action tool to replace part of your formula tool. Note a listbox can create multiple values which may not fit what you are trying to replace in a formula tool. An example would be helpful.

[vishtrack]

Hello, thank you for the response.

I need to include the list of values in a IF formula.

The formula is as below-

If Contains ([Country], "US") Then 0 ElseIF 

Contains ([Country], "UK") Then 0  ElseIF

Contains ([Country], "India") Then 0  else "1" Endif

The user should be able to select the list of other countries such as "AUS"/ "IRE"/"MON" etc during the run, based on the selection the above formula needs to change. Thanks in advance

[caltang · Accepted solution]

Hi @vishtrack - I'm not fully clear on your formula, but to build on the advice of @apathetichell , you can try my workflow:

The configuration needed on the List Box itself is something like this:

The areas highlighted are the key parts you need to configure. In this case, the formula you are replacing is the values in a list - a la ("").

In addition, I believe you'll have a list of values (countries in this case) that you'd like users to select. You can go a step further and put it into the list box connection from a file drop down OR you can even use a fixed list referencing a YXDB with (NAME && VALUE) fields only.

Let me know if this helps give you more ideas.