How To

How to Share Labels and Data Between Computers?

See the Sharing Labels and Print Data Across Computers section to learn how to do this.

How to print labels with Transparency codes?

For printing ¹ Transparency codes, templates are supplied with the program:

Amazon Transparency 1.125" x 1.125"
Amazon Transparency 1.75" x 0.75"
Amazon Transparency UPC 1.375" x 1.375"

Example of printed labels (test data):

You can change these templates for yourself in the Label Designer.

¹ For more details on how to print labels, see the Printing Labels section.

How to display a link from the database in a QR code?

Let's say the link is in the Link data field of your data source.

At the time of inserting the QR code into the template

Go to the Data source for barcode tab and select data field Link.

In an existing QR code

Double click on the QR code
Select data field Link.
Click OK.

How to generate barcode?

In the template formula

Use function Barcode.

For example formula

[Code] Barcode("EAN-13"; "23")

will generate an EAN-13 barcode with a "23" prefix based on the data in the Code data field.

In this case, the barcode will be formed "on the fly" when printing labels or in print preview.

How to change the currency symbol in the label?

Open Label Designer, delete the old currency symbol and add the desired currency symbol with the Currency Symbol tool.

How sort the list? How can I sort the list by several columns, for example, by article and color?

You can sort the list by any column, for example, by name, article number, etc.

To sort, click on the column heading.

To change the sort direction, click on the column heading again.

To sort by several columns, press the [Ctrl] key while clicking on the column heading.

How to use image links in Google Drive to display images in labels?

Google Drive public links of this kind

https://drive.google.com/file/d/{Image ID}/view?usp=sharing

not suitable for direct image acquisition.

Such links must be converted to links of this kind

https://drive.google.com/thumbnail?id={Image ID}&sz=w{Image width in pixels}

You can do the conversion directly in the template. For this, it is necessary to add the function of replacing part of the string in the formula for obtaining a link to an image.

An example of a formula if the link to the image is obtained from the data field [Image] and the image width should be 1000px:

[Image] Replace("/file/d/"; "/thumbnail?id=" ; "T") Replace("/view?usp=sharing"; "&sz=w1000" ; "T")

How to add an element, such as a barcode, to a separate layer in a template?

Add the desired layer in the template properties and before adding the element, change the current layer to another one.

You can also change the layer of an existing element.

How to create your own label template?

Creating a label template is described in the Creating a label template section.

How do I transfer a label template or multiple templates to another computer?

To transfer one template

Select Actions > Save to file menu.
Choose a location to save the template.
Transfer the saved template to another computer.
On another computer, go to Label Designer.
Select Actions > Load from file menu.
Select a saved template.

To transfer multiple templates

Go to Menu > Catalogs > Templates.
Check the boxes for the templates or template folders you want.
Select Actions > Templates export menu.
Select the templates export method Keep folder structure.
Select a folder to save templates.
Transfer the folder with the saved templates to another computer.
On another computer, go to Menu > Catalogs > Templates.
Go to the root of the catalog.
Select Actions > Templates import menu.
Select the import method Import all templates from a folder.
Select a folder with saved templates.

How to work with GS1 data in a label template?

To work with GS1, you can use:

The function in the formula GetGS1ParsedData(<AI>), where <AI> is the AI by which the function returns the data of the element if an element with such AI was present in the GS1 string, otherwise the function returns an empty string.
The functions in a JavaScript getGS1ParsedData(<GS1 string>, <AI>), where <GS1 string> is the GS1 string that the function parses into separate elements, <AI> is the AI by which the function returns the data of the element if an element with such AI was present in the GS1 string, otherwise the function returns an empty string.
The functions in a Pascal script GetGS1ParsedData(<GS1 string>, <AI>), where <GS1 string> is the GS1 string that the function parses into separate elements, <AI> is the AI by which the function returns the data of the element if an element with such AI was present in the GS1 string, otherwise the function returns an empty string.

You can see all application identifiers (AI) that the GS1 string can store.

An example of a formula for working with GS1 data:

[Barcode] GetGS1ParsedData ("01")

The following happens in the formula:

The GS1 string is taken from the Barcode data field.
Using the GetGS1ParsedData function, a GTIN (AI=01) is obtained from the GS1 string and displayed on the label.

An example of a Pascal script for working with GS1 data:

var
    GS1Str, GTIN, Serial: string;
begin
    //getting GS1 string from Barcode data field
    GS1Str := GetFieldValue('Barcode');

    //getting GTIN (AI = 01)
    GTIN := GetGS1ParsedData(GS1Str, '01');

    //getting Serial (AI = 21)
    Serial := GetGS1ParsedData(GS1Str, '21');
    WriteLn('GTIN: ');

    //displaying GTIN
    WriteLn(GTIN);
    WriteLn('Serial: ');
    
    //displaying Serial
    WriteLn(Serial);
end.

In the Pascal script, the following happens:

The GS1 string is taken from the Barcode data field.
Using the GetGS1ParsedData function, GTIN, Serial strings are obtained from GS1 and displayed in the label.

How to get a GTIN (or other element) from a GS1 string and put it in a separate data field when loading data?

Let's say you have a file with GS1 strings in a GS1 data field.

Let's say you want to load a GTIN element into a GTIN data field.

Do the following:

Open the settings for loading data from the source.
Add a GTIN data field.
Click the button and set the formula to get the GTIN value (AI=01):

[GS1] GetGS1ParsedData("01")

Let's say you have a product file and each product has a price in the Price data field, but you want to load that price with a markup.

Do the following:

Open the settings for loading data from the source.
Select the Price data field.
Click the button and set the formula to get the markup price (15% in this example):

[Price] AddPercent(15;"+")

How to set up a scheduled task launch?

Create and configure a task in the Tasks catalog.
Configure Windows Scheduler to run this task.

Task creation

Open the Tasks catalog through Menu > Catalogs > Tasks.
Create a task using the Add button.
Set up and test the task.

Configure Windows Scheduler to run this task

Go to the Windows menu Start > Windows Administrative Tools > Task Scheduler.
Click Create Task.
Go to the Actions tab and click New.
Click Browse and select the program file C:\Program Files (x86)\AzureLabel 14\AzureLabel.exe.
Temporarily go to the program and in the task window click Copy as arguments to run from the command line.
Paste the copied into the Add arguments box.
Click OK.
Go to the Triggers tab and click New.
Set the task launch schedule.