User Input: Input multiple values to a filter

[wonka1234]

hi all,

I am trying to setup a user input where a user can input multiple values.

The filter would be setup like so:    Column A = "1235" , "2353" , "5435".     up to many values

How can I accomplish this?

[Jonathan-Sherman]

Hi @wonka1234,

You'll want to use the IN() function, which allows you to list out all the possibilities:

[Column A] IN (1235,2353,5435)

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan

[Jonathan-Sherman]

The IN function works with both numeric and non-numeric data types also, in my example I used numeric so there was no need for speech marks but works equally well with them too!

[Column A] IN ("1235","2353","5435")

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan

[wonka1234]

thanks jonathan - how do I make this as a user input?

[Samanthaj_hughes]

@wonka1234 You need to use interface tools to have users input during runtime.

You can have a text box update the text input for example through the action tool.

[wonka1234]

@Jonathan-Sherman  hi Jonathan, would you know how to use your answer in a userinput box?