Text Box and Action tools not updating formula tool. Parsing error.

[Joker_Hazard]

Hello All!

Having trouble with those tools. For some reason it's giving me a parsing error.

I tried changing the format of this field for: V_W_String; V_String; 

Any ideas?

Thanks!

[apathetichell]

Can you post the replace string configuration on your action tool? Most likely you are trying to put a value into a call to a variable instead of the variable itself- the easiest way to avoid this is to have your formula tool point to a dummy value (ie 1) and then have your action update the dummy value.  You want to match value to value or variable to variable (and if you are matching variables your action tool isn't set up right)... Your error message points to trying to put a value where it's looking for a recognized field name. you  want the value "Testing" there - but it's looking for [Testing] - which doesn't exisist.

Hope that's clear - so in summary - put 1 in your formula tool and point to 1. If that doesn't work - then show the lower part of your action tool.

[Joker_Hazard]

Hello Apathetic.

It makes sense but as far as I know my configuration is correct:

My goal is to update this field with any type of string value. Could be "Testing", "Alteryx" or even a number.  

[apathetichell]

Your problem is you are trying to replace a field ([Nome...) with a string, so it isn't reading it as "testing" - it's reading it as [testing] which is an error. put a string in your macro as the value (ie. "1") and have your action tool point to updating that value (ie "1")

[Joker_Hazard]

Apathetic,

I tried all configs but none of them did work for me. I'm sorry... I'm uploading the workflow if you don't mind to show me what i'm missing.

Thank you very much for the extra help

[apathetichell · Accepted solution]

This version fixes those problems... NOTE: you are using a text box to update numbers. I set it to tonumber() the value coming in from the question - but you should be using a numeric up-down.

[Joker_Hazard]

Thanks for the solution and for the hint 🙂