Problem with space in trigger, GetFieldSelections() and Selection List

[#1]

Hello,

I have a little problem:

- I load a list in an inline mode in my main script

:

LOAD * Inline

[%_Zone_art

'Class1'

'Class2'

'Class3'

'Product Manager'

'Priority Level'

'Product'

];

- I add a selection list in my program

- I add triggers to always have 'Class 1' selected if no record is selected (I want this one and not only one selected)

%_Zone_art

='('&if(GetSelectedCount( %_Zone_art )=0,'Class1' ,GetFieldSelections(  %_Zone_art,'|' ) )&')'

My problem is when I select 'Product Manager', the selection is erased fos this record... I can't select it.

When I remove space and name it 'ProductManager' it is OK...

Have you got an idea ?

Thank you,

Willy

[sunny_talwar · Accepted solution]

Try this as your trigger expression

='("'&if(GetSelectedCount( %_Zone_art )=0,'Class1' ,GetFieldSelections( %_Zone_art,'"|"' ) )&'")'

UPDATE: Added " double quotes to the expression so that it can handle spaces in field.

[#3]

Hello,

thank you very much.

I will try on wednesday and tell you.

Regards,

Willy

[#4]

Hello,,

your answer is correct.

Thank you very much.

Willy