Detour Tool Problem

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?

Test.yxmc

Macros

Accepted answers

patrick_digan

Sorry, you should also check the box in the detour tool to be detour to the right. That should fix the problem. I've attached a quick sample.

New Workflow30.yxzp

All comments

patrick_digan

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!

pcatterson

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.

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167