Input to formula tool through dropdown

[hemant86]

Hi Team,

I'm trying to take an input through dropdown which is connected to a formula tool. I have tried something I got online. Please see screen shot below. It does not seem to work for me. Appreciate any help.

[Luke_C]

Hi @hemant86 

Does it work when it runs as an app? Or just not working when you run the workflow in designer mode? When testing these inputs you should go to the workflow config and enter a value that will be passed when the workflow runs for testing purposes:

[Emmanuel_G]

Hi @hemant86 ,

Try taking a look at this link for the answer : Update values in multiple formula expressions 

[DavidP]

Hi @hemant86 

It might seem obvious, but you have to run it as an app with the   next to the Run button for any

option from the dropdown to be taken into account.

The way I would troubleshoot this is to start with a very simple app:

Make sure you select this option in the interface designer

In the formula tool I simply create a new field that will show the value of [#1]

Now that this works, you can start writing some more complex logic and test every step of the way. The 1st thing to check is for which selections is the condition [Month]=[#1] true - test them all. It might be a case mismatch or whitespace, etc.

[hemant86]

Thanks @Luke_C . It was not working for Designer nor the APP. After making the changes in the workflow settings you mentioned now its working on Designer but still does not work on App. Any Idea?

[hemant86]

Thanks @DavidP . I tried doing it the way you suggested. I can see the UserInput in the browse tool while running as app. But there is no output file generated. But according to the workflow and input data output file has to be generated. Actually I'm performing a filter on the month column entered by user and producing the out put.

But when run as an app it says not output file created.

[DavidP]

Hi @hemant86 

Apps are often tricky to debug, but there is an easy way. 

In the Interface Designer, the 2nd option down on the left is called Test View. This allows you to select or enter the values you want to use for testing your App and you then click the Open Debug button. This creates a new workflow that you can run as a workflow with the values you selected in the Interface tools and you can see what actually happens step by step. This should show you what happens where you expect a file output to be created and you can also see the actual result of every tool in the workflow.

[hemant86]

Thanks @DavidP  for the advise. I was able to figure out what after debugging where I was going wrong. There was nothing wrong with the workflow. I was just fooling around with incorrect input files.😫. Thanks Again😊

[ShreyaValte]

@DavidP How can I use this output because I am getting the desired output in browse tool but I am not getting same output from formula tool.