Use Formula with my own parameter get from a Textbox tool

Hey !

How is it possibly to work with parmeter from entry fields?
Given:

Text Box tool connect to a an Action tool and connect to a Formula tool
Input data tool (with a select * from mytable) connect to the Formula tool.

When I run the workflow I get the error:

Formula (24) Parse Error at char(20): Unknown variable "myentryfieldtext" (Expression #1)

How configure my Formula tool and my Action Tool?

Mathias

My current configure:

Text Box

Action Tool

Formula

Macros

Preparation

Accepted answers

paul_houghton

Hey Mathias,

In your formula you are trying to find the field called myentryfieldtext, this doesn't exist in you data set. What you need to do is surround it in quotes ("myentryfieldtext") then it will be recognised as a string. Once you do that then the updating action you are doing should work.

All comments

paul_houghton

Hey Mathias,

mathias_schnoor

O.K thanks it works.

One Question at once:

When I connect a Browsetool at last I get not the right output.

When I use a Output Data tool an write the output into a csv-file. I get the correct output.

Why?

Mathias

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703