Prompt for multiple items

[AMLSAm]

Hi all. I didn't find this in the help topics. Wondering if the community could help. I have a report prompt and I need to use this to prompt for more than one item. Is there a way to prompt for multiple items in a prompt (maybe in contains)? I have tried using a comma and other indicators between the items, but can't seem to get it to work.

Any suggestions?

[EricaFo · Accepted solution]

Sadly, I am not sure this is possible. I found that someone sent this as an idea, which makes me think it isn't possible.

https://one.workfront.com/s/idea/0870z000000PSsYAAW/detail

[AMLSAm]

Erica-Thanks! I was afraid of that. I upvoted the suggestion. Thanks for sending that in your reply. I appreciate it.

[ManuelBa]

Hi Amanda,

any chance to predefine sets of items?

In that case you could use custom prompts and the OR function:

The user can then use the dropdown and your predefined options are executed in the background:

[AMLSAm]

Thanks Manuel. Unfortunately not. The items would change each time depending on what items we wanted to look up.

I checked in with our account rep and there is no way to do this as we want. I upvoted the idea of multiple prompts. Thanks!

[ManuelBa]

Could you give us some more details on what you want to analyze? Do you need the CONTAINS function or could you also use EQUAL?

In general, multiple items can work for some cases: