replace a value in multi row formula

[yuanlu]

Can someone please tell me if I can use user interface to input a numerical value to replace a value in a Multi Row Formula for instance:

IF [Row-1:WA Seasoning]=0 THEN 10 ELSE [Row-1:WA Seasoning]+1 ENDIF?

I'd like to replace the "10" with a user input value in above formula.

[JosephSerpis]

Yes you would need to configure the action tool connecting to the Interface tool to replace 10.

[Luke_C · Accepted solution]

Hi @yuanlu 

Yes, here's a screenshot of how. You can use a numeric up-down tool to let the user input, then update the expression to replace the 10.

[atcodedog05 · Accepted solution]

Hi @yuanlu 

You can also directly reference like below.

Hope this helps : )

[atcodedog05]

Happy to help : ) @yuanlu 

Cheers and have a nice day!