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

    To Select Blank Value Using Trigger



      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.