
Configuring Data Sources
l Use formulas that use the results of other formulas. Loftware Label Manager automatically
calculates all dependent fields first.
Loftware Label Manager uses spreadsheet-like syntax for its formulas. If you are an experienced
spreadsheet user, you can type formulas in manually. However, to make it easier to use Loftware Label
Manager’s formulas, the Formula data source dialog box has a Formula Assistant.
This section provides a general overview of how to take advantage of Loftware Label Manager formula
features. It is useful to experiment and practice with your own formula combinations to discover the
functions that work best for your own applications.
The Importance of Meaningful Field Names
Giving your fields a meaningful name makes it easier to work with formulas.
Example1
The formula (Gross_Weight – Tare Weight) / Piece_Weight is much easier to understand than (TXT0000 –
BAR0001) / BAR0002.
Example2
Building a complete name string out of three input fields is easier to read as: FirstName & “” & Middle Initial & “”
& LastName
Creating a Formula
Loftware Label Manager provides two basic methods for creating formulas:
l Type the formula directly into a text box. This is similar to typing a formula into a spreadsheet.
l Use Loftware Label Manager’s Formula Assistant capability. This allows you to build your
formulas from lists of field names, operations (for example, mathematical calculations) and
functions.
You can also combine both methods when creating a formula.
Using the Formula Assistant
The Formula Assistant consists of three columns:
l Fields: A list of all of the variable fields on the label that you can include in the formula. Any
non-printing fields that you may have dropped on the custom operator input screen also show up
in this list.
l Operations: The mathematical operators and string functions you use in conjunction with fields.
l Functions: A list of special barcode functions, check digits and system values.
Using the Formula Assistant, you can build a formula by pointing and clicking on Field Names,
Operations and Functions.
Loftware Label Manager Version 10.1.1 User's Guide
282
Comentarios a estos manuales