(Pending|Negotiation) Does not able to activate ?

[paulyeo11]

Hi All

I need to create a button , when i activate , i need the Pending & Negotiation label to be turn on.

So i using below script :-

(Pending|Negotiation)

But it does not work. Can some one advise me why ?

Paul

[Anil_Babu_Samineni]

May be ='(Pending|Negotiation)'

[paulyeo11]

Hi Anil

Thank you.it work fine, like below :-

='(Pending|Negotiation|Prospecting)'

But i also have :-

Initial Communication

='(Pending|Negotiation|Prospecting|[Initial Communication])'

Above does not work. why ?

[Anil_Babu_Samineni]

How about this?

='(' & Concat(DISTINCT {<[Sales Stage] = {'Pending', 'Negotiation', 'Initial Communication'}>}Chr(34) & [Sales Stage] & Chr(34), '|') & ')'

[paulyeo11]

Hi Anil

Still cannot work.

now it does not select any label.

Paul

[el_aprendiz111]

Hi,

[Anil_Babu_Samineni]

PFA

[paulyeo11]

Hi Anil

How about can you advise me how to recode the label of

Initial Communication

To Initial_Communication ?

Paul Yeo

[paulyeo11]

Hi Anil

I think your is latest ver.

I open your QVW , it still not working.

May be due to I am still using Ver 9 , no budget to upgrade.

Paul

[paulyeo11]

Hi Fer

Thank you , i am using ver 9 , not able to work.

Paul