Can anyone help me to implement one trigger on below scenario?

[#1]

Hi All,

I have one field as Country with below field values

Country

All

India

uk

hongkong

china

brazil

Now i want to implement trigger on field value " All " to "select all" the field values in country field?

So that i can view the complete data related all countries.

Thanks in advance!

Raju

[rwunderlich]

You will need double quotes around the values. Try:

=if(SubStringCount(GetFieldSelections(Country),'All')>0

,'*'

,'("' & GetFieldSelections(Country, '"|"') & '")' 

)

-Rob

[#3]

Rob, Its working! Thanks a ton!

Raju

[pratap6699]

very nice post sir,,,i have same requirement like this,,,,that is now we are select 'All' fieldvalue in country field then all fieldvalues will be selected right,,,now my requirment is when you select 'ALL' all selections will be clear like 'clearall button' is it possible...

[rwunderlich]

Just select a value that isn't there. That should clear the field.

-Rob