Action Tool

[Joy1]

Hi guys,

I need your help in the following:

I have a formula that for simplicity says [field1]+1

I want the user to be able to manipulate this 1 input parameters. I went o to say replace string 1 with a user input string. But it is not working: the 1 is not being substituted

How to solve it?

[fmvizcaino]

Hi @Joy1 ,

I'm attaching an example where I configure the action tool as it should to automatically replace anything inside a formula. In my example, I'm replacing the number 1 for an user input.

One thing that you need to be careful is the string to select, if you choose to replace the 1 in the formula [field1] + 1, it will automatically replace the 1 in field1 and in number 1 as well.

Best,

Fernando Vizcaino

[Joy1]

I have been trying this with no success...

This is my formula:

HELP!

[fmvizcaino · Accepted solution]

Hi @Joy1 ,

The action tool is configured as it should. One thing that looks strange is your data type, since you are using integer, it is probably removing the decimals from the result.

Best,

Fernando Vizcaino

[afv2688 · Accepted solution]

Hello @Joy1,

This should show you how to do it.

I did also notice that the formula you are applying is on a Int16 value.

Would recommend you to change it to double to get the desired results

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards