Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I got a trigger on one of the sheet and added an action to select multiple values of a field
the field is Business Type
the values are OFFICE and REGIONAL OFFICE
I put in the action the field [Business Type] and in the value I put (REGIONAL OFFICE|OFFICE)
Only OFFICE is selected
values that contain spaces are not being selected
Please advise
Hi
Try replacing the spaces with *
(REGIONAL*OFFICE|OFFICE)
That appears to work.You can use Replace() to swap the space for a *
Regards
Jonathan
Hi
Try replacing the spaces with *
(REGIONAL*OFFICE|OFFICE)
That appears to work.You can use Replace() to swap the space for a *
Regards
Jonathan