Changing Part of a Formula Tool through an App

[keng]

Hi, 

I'm trying to replace part of a formula through a text input in an Alteryx app. 

For some reason, it is not working. I want the users to have the flexibility of using the OR function as well if they have multiple choices. Any suggestions on why this might not be working? 

    

[apathetichell · Accepted solution]

Your formula is wrong. OR 'Tuscon' is a boolean - like OR ('Tuscon'=True).  Even it still replaces it you are replacing it with a new Boolean expression which will be false.

you want an IN statement here  value IN('Tuscon','Phoenix') you should then replace what's in your IN statement (except the parenthesis EXACTLY. So your user will have to enter something like "Tuscon","Phoenix" - I would recommend using a listbox for this with lisbox -> list mode -> actoin tool - repalce vs the way you are doing this. 

[keng]

You are a lifesaver! Thank you!