We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Enable/Disable Formulas using Check Box Tool

dmpope
8 - Asteroid

Hi there,

 

I have two formulas in a formula tool that I'd like the user to be able to enable/disable based on whether they need to run the workflow for the current date or a previous date. I read in the 2024.1 release notes that this is possible, but I haven't found any examples on how to configure the tools for this to work.

 

Currently, I have two check box tools, one for Yes and one for No. Yes would be if they need to run a previous date, No is for current date. My thought was bringing down a Condition tool to set the condition formula to Yes (so if yes is selected, then True). Then the action tool from the True anchor would enable the previous date formula, and if No is selected then it would go to the false anchor which would enable the current date formula. 

 

However, running this in debug shows that this set up isn't working and right now I'm at a bit of a loss on how to change the logic. Could anyone help out? I've attached an example workflow of how I currently have my interface set up in my real workflow. 

 

Thank you!

1 REPLY 1
dmpope
8 - Asteroid

Found the solution.

 

If anyone needs the answer, in my action tools, I chose "Update Value with Formula" instead of "Update Value". The formula I used was IF [#1] = "true" THEN "true" ELSE "false" ENDIF.

Labels
Top Solution Authors