Select multiple value from a field using trigger

[#1]

Hello guys.

I need to create a trigger in a sheet to select multiple values from a field.

Say the field is CustomerPostingGroup and the value that I need to select in the trigger is strings 3RDPARTY and ACCREC'BLE.

And please take not that there is an apostrophe (') in the ACCREC'BLE string.

How do I do this? I know we can add Triggers in the OnActivateSheet and add a Select in Field action. I input the CustomerPostingGroup as the Field.

But how do I enter in the Search String if I wanted to trigger selection of two values?

Thank you very much for your kind attention guys

[#2 · Accepted solution]

Apply select in field trigger and add this is in search string

='(3RDPARTY|ACCREC*)'

Regards,

Prabhu

[#3]

Hi Prabhu

Thank you for your answer! the ' ' should be outside of ( ).. now I know why mine didn't work

Thank again brother