Action tool to update formula

[Mildman]

I have an Analytic App which loads data from different sources into either Prod or Stage db's.  The App allows you to set which environment by a dropdown which is either Prod or Stage.  I would like to add a field to the data which tells if the app was used for Prod or Stage data.

This is my test flow, the dropdown has values of Prod or Stage.

The update value is set to 

But when I run the test app I get the following error

How do set the value in a formula based on the value of a dropdown?

[mceleavey]

Hi @Mildman ,

Can you share your workflow? I don't need real data, just mock it up so it's close to what you're trying to do.

M.

[Mildman]

I want to change the value of the field Envi based ont he value of the dropdown list.

[mceleavey · Accepted solution]

Hi @Mildman ,

This had something to do with how it was interpreting the manual fields in the dropdown.

I've changed this to be a text input and changed the dropdown function to be "Fields from connected tool".

I've also changed the action tool to update a specific string.

I hope this helps,

M.

[Mildman]

Perfect, thanks