TextBOX Input

[hemant86]

Hi All,

I taking a Input from user using text box which is alphanumeric. My other input is .csv file. I'm trying to append a column with value entered by the user in text box. Now my workflow is working fine if the input is numeric. But fails if its alphanumeric or only alphabets. Below is the workflow I'm using

Formula tools settings

Action Tool Settings

Thanks in Advance!

[atcodedog05 · Accepted solution]

Hi @hemant86 

Give this method a try.

Hope this helps : )

[atcodedog05 · Accepted solution]

Hi @hemant86 

You can update your current workflow like below to make it work.

Workflow:

Hope this helps : )

[hemant86 · Accepted solution]

Perfect!!...Thanks @atcodedog05 ...Thats exactly what I needed. But did not understand the use of [#1] exactly.

[atcodedog05]

Hi @hemant86 

[#1] directly takes in the connection data (input text) and is used in formula. Note this can only be used in tools that uses formulas. 

Happy to help : )

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!