Product: LABEL MATRIX
Version: All Versions
|
1. Create a new text field to use with the expression, click on the Add Text icon.
2. Select the text field and right click selecting Properties.
3. Under the Data tab change the Origin drop-down to Combination.
4. Click the Other button. Select the Logic Functions. Click OK.
5. In the Expression Piece window select If - Different True or False Result. Click OK.
6. In the expression If(0,"True Condition", "False Condition"), highlight the "0" and click the Other button.
7. Select Logic Functions. Click OK.
8. Select the Equal option to use the expression. Click OK
The expression should look similar to the picture below. There may be values that appear after Equal("Value","Vaule"). For this document I have named them as "Variable" and "Equal to Variable". The "Variable" is going to be the Variable field you want to compare in the Equal part of the function. The label we are using has multiple fields already connected to a database, we will select one of those.
9. Highlight the "Variable", or the value that is represented in that position.
10. Select the value from the records above. Once selected click Use.
In this example we are selecting [Sheet1$Lot]. The name of the Database Field should now appear in the expression.
11. Change the "Equal to variable", to a record/value that would return from that database.
In this example it is 12.
If [Sheet1$Lot] is equal to 12, it'll show the True Condition, if [Sheet1$Lot] is not equal to 12, it'll show the False Condition.
|