4 Replies Latest reply on Dec 3, 2012 11:12 AM by laguna92651

    Script to Filter using Omit

    laguna92651

      This script currently shows all records that does not have "Labor" in the Materials field or shows records determined by the other stauts options, Active or Inactive, and no "Labor" entry in the materials field. I would like to add a global checkbox field, No Labor Included, that would allow me to see or not see records that have "Labor" in the Materials column. Basically I want to be be to turn the hard wired Omit on and off.

       

      This script is working, is there a way to copy this from my script area and paste it into a text file, to save me some typing and mistakes?

       

      Set Variable[$StatusGRID;Value:GlobalProduct::xStatusGrid]

      If[$StatusGRID="All"]

      Enter Find Mode[]

      Set Field[Products3::Status"*"]

      New Record/Request

      Set Field[Material2::Fabric;"Labor"]

      Omit Record

      Perform Find[]

      Else

      Enter Find Mode[]

      Set Field[Products3::Status;GlobalProduct::xStatusGRID]

      New Record/Request

      Set Field[Material2::Fabric;"Labor"]

      Omit Record

      Perform Find[]

      End If