10 Replies Latest reply: Feb 18, 2014 1:03 AM by Sajeevan Govindan RSS

    To Select Blank Value Using Trigger

      Hi,

       

      I have to select a set of values(including blank) in a particular field as default while leaving a sheet.

       

      And I am using the following triggers

      Select in Field:

      Field: FIELD

      Search String: only({<FIELD={"=len(FIELD)=0"} >}FIELD)

       

      Toggle Select:

      Field: FIELD

      Search String: (Value1|Value2)

       

      This works only if there is no selection on that FIELD. If there is any other selections, it is not working. Even I have tried 'Clear All Field' Trigger. But doesn't works.

       

      Please help to find a solution.

       

      Thanks & Regards,

      Vinitha Mano R.