Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
crystles
Partner - Creator III
Partner - Creator III

Select Field Trigger - multiple options in field

I need to filter the Document in the Trigger for "On Open"

I can do that with just one selection, but I cant figure out the syntax for multiple choices?

I have tried

  • 'Section1' and 'Selection2'
  • 'Section1' or 'Selection2'
  • 'Section1' ,'Selection2'

But none of them work?

1 Solution

Accepted Solutions
crystles
Partner - Creator III
Partner - Creator III
Author

I found this article that explained it.  Example of Selecting Multiple Field Values

I had to add double quotes around the selections instead of single quotes.

("CANADA" | "UNITED STATES")

Then the formula worked.

View solution in original post

3 Replies
m_woolf
Master II
Master II

(Selection1|Selection2)

MK_QSL
MVP
MVP

('A'|'B'|'C')

this will give you A and B and C selection

crystles
Partner - Creator III
Partner - Creator III
Author

I found this article that explained it.  Example of Selecting Multiple Field Values

I had to add double quotes around the selections instead of single quotes.

("CANADA" | "UNITED STATES")

Then the formula worked.