Action Tool - Can't Update Cell Value with Action Tool and Foruma Tool

Hi there,

with the Action Tool, I'm choosing a value from a drop-down list. I want this value to update cells in my workflow, for one of the columns.
I'm connecting the action tool to the formula tool to do so. Is this the right approach? It doesn't seem to work, the cells in the required column are not updated... I seem to miss the connection between the value chosen from the dropdown and the formula tool.

Do you have any hints on how to solve this?

Thanks a lot for your help.

Regards

T_Lina

Custom Tools

Accepted answers

grazitti_sapna

Hi @T_Lina,

Can you please select the highlighted portion as shown in the screenshot below:

Once you select this in the Replace a Specific String Keep only Input1, remove everything else from there. Then try and run the workflow again.

I hope it works for you.

All comments

Christine_Assaad

Hi @T_Lina

Will you be able to share the app or how the 3 tools were configured?

Cheers!

Maskell_Rascal

Hi @T_Lina

If its just a simple field value update from for the entire column based on the drop down, you can get rid of the Action tool and connect the Drop Down tool straight to the Formula tool like below:

The Formula tool will need to be configured to the column you are updating, and the formula itself will be the name of the connection. In the example above it is [#1].

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil

grazitti_sapna

Hi @T_Lina,

Can you please share the configuration of the tools? Is it a part of the formula that needs to be updated ?

T_Lina

Formula Tool configuration (goal: change the value for "Input_Dropdown"):

Action Tool Configuration:

Drop Down Configuration:

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703