1 Reply Latest reply: Jan 22, 2012 9:54 AM by Erich Shiino RSS

    Pls Help

    Shantnu Patel


      Can any one help me and answer that how to set default selection when open sheet last 45 days data,date field is date2

        • Re: Pls Help
          Erich Shiino


          Please, check solution in the attachment


          I used a trigger on document 'on open' event.


          Go to settings ->Document properties -> Triggers and set the action there.

          The action is selection in the field (I called it Date) and the syntax is:



          It will generate a search string like this:



          Hope this helps,