Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Firstly is this possible?
Id like to create a button that selects in field but id like it to select a number of statuses rather than just a single status
for example
Field = [Quote Status]
Search String <> 'Won' OR 'Lost'
Any ideas?
Thanks for all you advice in advance.
Hi,
Set it to search
(Win|Lost)
All values without quotes, separated by the "|" symbol, and warped by parentheses., then a new action to select excluded.
Hope that helps.
Miguel
Hi,
Set it to search
(Win|Lost)
All values without quotes, separated by the "|" symbol, and warped by parentheses., then a new action to select excluded.
Hope that helps.
Miguel
I THINK YOU ARE LOKKINGFOR SOMETHING LIKE THIS.
SEE ATACH.
Hi Miguel,
This works if I use the
='(Won|Lost)'
but i require the reverse
<>'(Won|Lost)'
which fails to work. If this it is not possible to <> is something along the lines of ='(Internal Estimate|Order Request|Pending)' this doesnt seem to work and im guessing its because of the whitespace?
Hi,
Yes, blanks are not welcome in these expressions. Wherever you have a blank, fill it with an "*" instead. Note that I added a new action to select excluded in the same field.
Hope that helps.
Miguel
Hi Miguel,
Sorry missed that attachment, thats exactly what im after, thank you again for your excellent help.
Lewis