Hi
I have connected 6 different List box tools and updated the formula with in Action Tool
When I placed the Macro in the Data
I'm receiving this error
Tool #2: Parse Error at char(0): Unknown variable "E" (expression #1)
can someone help me to decode the error
Solved! Go to Solution.
Hi @BRRLL99 , is Tool #2 the formula tool you are changing? It looks to me like there is something going wrong with your Action tool configuration, leading to the formula being updated to an invalid one.
Some screenshots of your action tool configuration and your formula tool would be useful.
this is the formula I have written in Action tool
@BRRLL99 for this issue, the best way might be to get rid of the action tool altogether. You can link the list boxes directly to the "Q" anchor of the formula tool (see below). Then, replace the formula with the one currently in your action tool.
Please share the workflow
could please let me know the reason
Why action tool was removed?
@BRRLL99 , you had already written a formula that dynamically updates when the list box values change. The formula tool can deal with this directly, without an action tool inbetween.