Action tool to update formula

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?

Macros

Accepted answers

mceleavey

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,

Test workflow.yxwz

All comments

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.

Mildman

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

Test workflow.yxwz

mceleavey

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,

Test workflow.yxwz

Mildman

Perfect, thanks

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335