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