2 Replies Latest reply: Jun 28, 2012 3:48 AM by Richard Chilvers RSS

    Best way to manage default selections

    Richard Chilvers

      This is a general question about selecting the 'default' data a user sees.

       

      Many of us 'filter' our data in the script; for example, SELECT where FIELD1 = 'A' or 'B' or 'C'   ... etc

      This is fine until a new selection for FIELD1 is needed, and then someone has to modify the script. And often no one remembers to tell the script writer !

       

      The alternative is to present the user with all the data (ie. no filter) with a default selection already made on FIELD1 for the worksheets. This has the big advantage that should a new value of FIELD1 be needed, the user can deal with this themselves by adding to the selection.

       

      Has anyone got any views about the best way ?