Multiple text box with IN clause on filters

Question

Hello Community,

I am trying to have multiple text boxes but I want it to be dynamic where I may choose not to use one of the text boxes.  Currently I get an error saying not enough parameters for the function "IN".  Second my multiple selections are not working properly.  I get a Malformed Function Call error when I try to input multiple selections.  Everything works when I input a single entry for each text box.

losingh · Answer

Thank you both for the suggestion. I like the chain app suggestion and I am attempting to update it accordingly.  I have updated the configuration with the suggested formula  but I am getting an error on the initial app of a parse error Unknown variable "AL" which is just the first state in my list.

patrick_digan · Answer

@losingh You could also

1) Change your action tools to update values with formulas, and have formulas like this:

or

2) Use reference shortcuts. After you've named your text boxes in their annotation section of their config, you can write a filter tool like this (where you just enter "" to ignore that filter):

or

3) you could also use radio buttons, but I like the above 2 better.

Testing Text Boxes.yxwz

AngelosPachis · Answer

Hi @losingh ,

For your use case I believe it would make sense if you use chained apps. If you are unfamiliar with the concept, a great resource is the interactive lessons in the community. Chained apps will give your users to select only relevant values based on the selection made previously.

For example, your first app will give your users to filter or not for a state (ideally not with a text box but a list box would work better). If the user decides not to filter for any state, then the second app will allow the user to select one or more cities. However if the user selects to filter for one or more states in the first app, using chained apps will allow the second app to only display the relevant cities that are in the states selected earlier.

Same logic applies for the property id selector. Another great resource that you can use to reverse engineer is Alteryx Weekly challenge #175

It's the exact same thing you're trying to do :)  Let me know if that worked for you.

Cheers,

Angelos