In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Updating Hardcoded formula values using text input

wonka1234
10 - Fireball

Hi,

 

I have a formula like so 

 

Formula =  

If Contains([Value]), "Louis) or

Contains([Value]), "Ren") 

 

How can I use an input tool/analytic app tool to have a user enter in the names based on whatever name they want? 

 

Another issue is that there may be more names then just louis and ren, they may want justin or thomas added too...

2 REPLIES 2
RobertOdera
13 - Pulsar

Hi, @wonka1234 

 

Go to Interface on the toolbar --> Text Box tool --> Open Example.

Replace the names, e.g., Louis, with a parameter, and that parameter captures whatever users type into the Text Input (and you will need to standardize by including a formula (or error message) that encourages users only to use lowercase and last name)

 

RobertOdera_0-1675520760357.png

 

Felipe_Ribeir0
16 - Nebula

Hi @wonka1234 

 

Try this

 

gif1111.gif

 

Labels
Top Solution Authors