Select in Field with Spaces/Special Characters

[jcampbell474]

I'm trying to implement a (Settings > Document Properties > Triggers > Field Event Triggers > On Select > Select in Field) Triggers and can't get two of them to work.  One has spaces and the other has a special character '/'.  All of the others triggers work fine.

I googled and browsed through the QV community and can't find a solution that works. 

Here's one option I tried.  I need 'State' to be selected in the ALView listbox.

=if(Replace(GetFieldSelections(ALView),' ','?')='Zero?Quote?Agencies','State')

Another:

=if(GetFieldSelections(ALView) = '("Zero Quote Agencies")','State')

Here's the other expression: =if(GetFieldSelections(ALView) = 'Gainers/Losers',"Product")

I'm thinking one solution will apply to both instances.

Can anyone point me in the right direction to get this to work?

Thanks!

[sunny_talwar]

So the above expressions are not working or are they working but you want to be able to combine them?

[vishsaggi]

Where are you using these expressions? IN triggers? On select what is that, that needs to be selected. Your IF condition says 'State'? Is state a value in your list box? Can you send a sample or a screen shot of what should happen when On Select ?

[adamdavi3s]

So your logic is trying to say that if a list box selection = Gainers/Losers then reselect 'product' in the same listbox?

This seems to work fine for me, selecting 'Gainers/Losers' triggers the selection 'D' in my example as well as a selection in status

[jcampbell474]

Thank you all for the quick responses.

My expressions are not working and I don't want to combine them.

I'm thinking that at least this trigger: =if(GetFieldSelections(ALView) = 'Gainers/Losers','Product') is not working because I have another field in ALView called SubProduct.  Not sure...

I attached an app with examples.  The triggers Gainers/Losers and Zero Quote Agencies do not work.

[sunny_talwar]

You have three triggers to the same field? This isn't going to work the way it is structured today. Instead of three triggers you will have to use this one trigger

[sunny_talwar · Accepted solution]

Check the attached

[jcampbell474]

Sunny, perfect!  That did it. 

Makes sense, I now understand what was happening.  Thank you for the help, as always!