AnsweredAssumed Answered

Script to Filter using Omit

Question asked by laguna92651 on Nov 28, 2012
Latest reply on Dec 3, 2012 by 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

Outcomes