How to filter options on production labels based on an option value

How to filter options on production labels based on an option value

This article explains how to filter and print select options on production labels based on a specified option value.

Note: If you already have a modified label you can skip to the section 'How to setup Label and Data Fields to print options based on a specified option value'.

Create a modified label
1.  From the Tasks menu, click Manage Process Reports.
2.  From the Category list on the left, select Production Labels.
3.  From the list of labels on the right, select the label you want to modify.
4.  From the toolbar, click the Copy button.
5.  Enter the name for your new label and click OK.
6.  Your new label will be added to the list and automatically selected. In order to use your new label you will need to add it to the list of labels to print. Consult your online help for additional instructions.

How to setup Label and Data Fields to print options based on a specified option value

The first step in setting up these fields is to determine which options and option values are applicable to what you want to display.  Each option needs two data fields setup, one functions as the "Label or prefix" and the other is the data itself.

Note:  Option Names in formulas will be entered within square brackets and single hash marks, such as '[Blind Type]'.  Option Values will be entered within single hash marks, such as 'Corded'.  Option Names and Option Values must match what is setup in the product database and what you see in the software.  The option that determines which options and values to display does not need to be on the label, but must be valid in the software. 

The example below is for horizontal blinds with an option named Blind Type.  The Blind Type option values are Corded and Cordless.  If Blind Type = Corded, then the option Control Length needs to print.  If the Blind Type = Cordless, then the Cordless option Module Type needs to print.

1.  Below are the steps to add the Corded Control Length fields

     1a.  For the label prefix for the option Control Length, add a field to the label and change the Field Type to Data Field.  Add this formula in the Data Field:  = CASE WHEN '[Blind Type]' = 'Corded' THEN 'C     Length:' ELSE '' END.  (Where "C Length" is the prefix for the Control Length value)

      1b.  For the Control Length value, add a field to the label and change the Field Type to Data Field.  Add this formula in the Data Field:  = CASE WHEN '[Blind Type]' = 'Corded' THEN '[Control Length]' ELSE '' END

2.  Below are the steps to add the Cordless Module Type fields:

     2a.  For the label prefix for the option Module Type, add a field to the label and change the Field Type to Data Field.  Add this formula in the Data Field: = CASE WHEN '[Blind Type]' = 'Cordless' THEN 'Modules:' ELSE '' END (where "Modules" is the prefix for the Module Type value) 

     2b.  For the Module Type value, add a field to the label and change the Field Type to Data Field.  Add this formula in the Data Field:  = CASE WHEN '[Blind Type]' = 'Cordless' THEN '[Module Type]' ELSE '' END

3,  Repeat the above steps for all applicable options.

4.  Click OK to save the changes.
5.  Click OK to close the Modify Report screen.


APPLIES TO
Solatech Window Covering Software 4.0
Solatech Window Covering Software 4.1
Solatech Window Covering Software 4.2

    • Related Articles

    • How to sort production labels by an option value

      Summary This article explains how to setup production labels to sort by an option value. More Information The default sorting for production labels is first by order number, then line number. If you want to sort by any other field you must create a ...
    • How to create, modify and setup production labels

      This article explains how to create, add and modify custom production labels.  Solatech provides default labels in the software; however, they cannot be customized.  Below are the steps for creating a new label that can be modified to fit specific ...
    • How to prevent valance labels from printing when no valance is selected

      Summary This article will explain how to setup your products and labels so that a valance label is printed only if a valance is selected on the order. More Information Notice The steps in this article assume you have the following software: Solatech ...
    • How to put images on production labels

      Summary This article explains how to put images on production labels printed with the Solatech Window Covering Software. More Information Putting labels on production labels is a two-step process. The first is to find the image and update your ...
    • How to override an option value in Order Entry

      Summary Beginning with version 5.0.0.239 of the SalesPRO software, users may now override an option value in any product. Please note that if you override an option for some vendors, you will be unable to send your order electronically. Instructions ...