Triggers How to Select 2 values in the same field QV11

[#1]

I have a field called LOAN CATEGORY CALL REPORT, the field has several products. I would like to set a sheet trigger to select both 'Indirect Auto' and 'Direct Auto' when the tab is selected. I can set it to open with one field selected, but not the additional field. I'm certain it is probably syntax error, but I'm really frustrated. Any help would be greatly appreciated!

This works:

OnActivateSheet>Select In Field:

Field > [LOAN CATEGORY CALL REPORT]

Search String > ='Indirect Auto'

This DOES NOT Work:

OnActivateSheet>Select In Field:

Field > [LOAN CATEGORY CALL REPORT]

Search String > = [LOAN CATEGORY CALL REPORT] = 'Indirect Auto' and  [LOAN CATEGORY CALL REPORT] = 'Direct Auto'

[#2]

("Indirect Auto"|"Direct Auto")

[sibin_jacob · Accepted solution]

='(Indirect*Auto|Direct*Auto)'

[#4]

Great! Thank you Sibin, this works. I'm wondering why though, is it basically doing a wild card search or with triggers do you have to use the asterisk for spaces in field values?

[sibin_jacob]

If you are using trigger for select in field, you need to replace space with asterrisk.

If your string not containg space no need to use asterrisk.

Thanks,

Sibin Jacob.C

[#6]

Hi,

I've just come across this answer as I was having a similar problem.

My problem, however, is that in my field I have "Strongly agree" / "Strongly disagree" / "Agree"

and only want to have Strongly agree / Agree selected.

Using ='(Strongly*agree|Agree)' also selects "Strongly disagree" as the asterix acts as a wildcard in this instance.

I am using the Select in Field action. Could you possible help?

Cheers,

CG

[#7]

I’m sorry, but I have not solved this one yet. If you come across the answer, I’d appreciate it if you could post it to this thread!

Thanks!

[#8]

Did you try using the double quotes as I suggested?  That removes the need for a wildcard.

[#9]

Ah just seen properly, had thought I'd already tried that.

Yes, Rebecca is correct. If i use

("Strongly agree"|"Agree")

as my search it does indeed work.

Thankyou!