Views:

Product: LABELVIEW, CODESOFT

Version: All Versions

Overview

You can combine (concatenate) multiple data source variables into a single value by creating a Formula data source. This allows multiple variables, such as serial numbers, counters, or database fields, to be displayed together as a single text string, barcode, or image on your label.

Procedure

Step 1. Open the Data Sources window if it is not already visible.

If the Data Sources window is not displayed, navigate to View > Data Sources. The Data Sources panel opens on the right side of the application.

    

Step 2. Create the data source variables that you want to combine.

Right-click the desired data source and select Add. Repeat this process for each variable you want to include in the final formula.

In this example, a Counter field and a When Printed field were created.

    

Step 3. Create a Formula data source.

Right-click Formula in the Data Sources window and select Add.

Step 4. Build the concatenation formula.

Reference each variable inside curly braces { } and join the variables together using the & operator.

For example, you can concatenate the variables Serial and 4 Digit Counter. Use the Preview section at the bottom of the Formula editor to verify the result before saving.

Step 5. Place the formula on your label.

Click and drag the completed formula onto the label.

When prompted, choose whether to place the formula as a Text, Barcode, or Image object. In this example, the formula is placed as a Text object.

Keywords: combine fields, concatenation, labelview formula, codesoft formula, labelview formula, formula, adding fields