exclude values from default selection

[#1]

Hello All,

I know how to select a value by default from a field in a  filter. I have used the select in field trigger which works quite good for me.

Now another requirements came across me, which is to include all values and exculde 'Other' by default from a field in a  filter. Can some one tell me, how can i exclude a value by default from a filter field in a sheet.

What i mean to say is select All values in a field except 'Other' by default. The field name is Plant

Br

Arif

[IAMDV]

Arif - You can use simple IF statement. Something like this...

=IF(FieldName<> 'Other', FieldName)

You can use the same in ListBox expression to hide the 'Other' option.

I hope this helps!

Cheers - DV

[kaushiknsolanki · Accepted solution]

Hi,

   Try this.

   Add first Action to button as Selection in field   Field name and Value as "Other"

   then

   Second Action as Select  Excluded with same field name

Regards,

Kaushik Solanki