I am working on a macro. I created a detour that is conditioned on whether you fill in a text box. If the textbox is blank, it is supposed to detour and not perform that step. When I fill in the textbox normally, it should perform the step and continue on, but when the first character within the textbox is "t", "T" or "1", then it flips to the detour erroneously. I believe it is because these characters refer to True in a boolean sense and override the condition placed on the detour.
Has anyone come across this before or have any solutions to this problem?
Solved! Go to Solution.
I would suggest 2 changes on the action tool connected to the detour tool to correct the issue. This is how i normally set these up:
1) On the action type dropdown, change it to update value with formula.
2) In the formual box on the bottom, type in: regex_replace([Destination],".*","False")
The way you had it setup, it was changing the False to whatever item you typed in. As you pointed out, when it was a number or word starting with t, it was then evaluating that as True and detouring. For everything else, it was evaluating it as false. With my method, you're replacing the whole value (whether it's true or false) with the False so that it can be properly evaluated. Hope that helps!
This doesn't fix the problem. When your formula is applied it never bypasses the steps. If there is nothing in the textbox, I want it to go right. This always sends it left regardless.
Thanks!