Action tool to update formula
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- Macros
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Perfect, thanks
