Select more values on Activation Sheet

[#1]

Hi,

what is the syntax to select more fileds on activation sheet.

I can select only one value. I would like when I clik on my sheet1 the values A,R,S,T is selected.

Thanks for your help.

Judi.

[Gysbert_Wassenaar · Accepted solution]

This is the search string you need: (A|R|S|T)

The values are enclosed between parentheses and are separated by a pipe symbol '|'

[#3]

Thanks. It's true pipe symbol '|'.

I have an other question : In my input box I try to change operator '=' by '<='

Inmy presentation tab is it possible to show or not the operator but how can I change '=' to '<=' ?

An idea ?

Thanks for your help.

[Gysbert_Wassenaar]

No, that's not possible. The alternative is to use a variables, one for the operator and one for the value to compare to.  Create an input box for the two variables.  The variables can then be concatenated to create a search string for the field.  See attached example.

[#5]

Thanks for your help, Gysbert.