Macro with condition tool; can anyone tell me what's wrong?

[G1]

Hello 🙂

I am trying to get the attached macro to add a new column stating 'true' if the incoming number is above 0, or 'false' if the incoming number is 0 or less. I've also attached a test workflow with a text input tool.

I know you probably wouldn't do this task ordinarily with a condition tool, but I'm trying to get the condition tool working so I can use it for a detour. Right now I can't even get it working to update a simple value in a formula.

Can anyone tell me what i'm doing wrong?

Thanks in advance!

[wdavis · Accepted solution]

Hi @G1 

At the moment, there is no value being assigned to update the label to either True or False.

Therefore, if you change the action type to be "Update Value with Formula" you can then enter a Formula at the bottom which just defines what the field should be updated to e.g True/False.

One thing to note, when entering the values they will need to be contained within double and single quotes - "'True'" for this to work.

Let me know if this works for you!

Thanks

Will

[G1]

Hi Will,

Thanks for replying and thanks for your help! I have got it working!

G