Record Details

Record Details allow a single product record to contain multiple related values, such as ingredients, specifications, seed varieties, components, or other grouped attributes. These values can be referenced in label templates and automatically repeated during printing.

Label examples

Seed mix example

Kit components example

Specifications example

Ingredients example

Setting up Record Details import

After you have successfully configured data import from your data source(s), you can enable Record Details generation.

Open 1 Label Print Data > Record Details in the Import Settings, and enable the 2 Generate Record Details checkbox. Then select the 3 Generation Method.

The remaining configuration depends on the selected Generation Method. Each method is described in the sections below.

Generation Method

Record Details can be generated in different ways depending on how the data is structured in the source. AzureLabel supports three methods for creating Record Details.

From column groups

Use this method when repeated information for a product is stored in multiple columns within the same row.

In this structure, each product record contains repeated column groups that represent detail values. This is typical for data stored in a wide format, where repeated attributes appear as numbered columns.

For example, a seed mix might contain columns such as Variety01, Percent01, Variety02, Percent02, and so on. AzureLabel reads these column groups and converts them into multiple Record Details rows.

To set up the From column groups method:

1. Add fields to the Field Set. This defines the fields that make up one Record Details row. AzureLabel uses this set to recognize repeating column groups such as Variety01, Variety02, and convert them into detail rows.

   In this example, add Variety and Percent.

2. Select the Start Field — the first field where the repeating column groups begin.

   In this example, select Variety01.

3. Set the Repeat Count — the maximum number of column groups to process. When generating Record Details, AzureLabel stops if the first field in the Field Set has no value.

   In this example, set it to 5.

From row groups

Use this method when repeated information for a product is stored in multiple rows of the data source.

In this structure, each row represents one detail item, and several rows belong to the same product. AzureLabel groups rows that share the same product fields and converts them into Record Details for that product.

This method is typical for data stored in a long format, where repeated values appear as separate rows.

For example, a product may contain several components with different quantities, with each component stored in a separate row.

To set up the From row groups method:

1. Add fields to the Field Set. This defines the fields that make up one Record Details row.

   In this example, add Component and Quantity.

From nested records

Use this method when the data source already contains nested lists or arrays of objects, such as in JSON data.

In this structure, each product record includes a property that contains an array of detail items. AzureLabel reads this array and converts its objects into Record Details rows.

This method is common when importing data from APIs or structured JSON files.

For example, a product may contain several ingredients with different percentages, with each ingredient stored in an array named "ingredients" within the product object.

To set up the From nested records method:

1. Select the Details Array Name — the array that contains the detail items.

   In this example, select ingredients.

2. Add fields to the Field Set. This defines the fields that make up one Record Details row.

   In this example, add Name, Percent, Origin.

Sort Record Details rows

Regardless of the selected generation method, you can also sort Record Details rows.

1. Add fields to the Sort By list. These fields define the order of the Record Details rows.
2. To sort in descending order, enable the checkbox next to the field in the list.

Viewing Record Details

After Record Details are generated, they can be previewed in the Test Import tab of the Import Settings window. When a record is selected, its Record Details appear in a separate table next to the main data table.

After the import is completed, Record Details can also be viewed in the Label Print Data table, where the selected record displays its details in a subtable.

Add Record Details to a label

You can drag and drop a Record Details field from the Data Source Fields list, just like a regular field.

Alternatively:

1. Add an element such as Text to the label.

   

2. Select a Record Details field on the Data Source tab in Element Properties.

   

3. Enable the Bind to Record Details checkbox on the Record Details tab in the Element Properties.

   

Record Details Settings

To set up how Record Details are displayed on the label, use the Record Details tab in the Element Properties.

• Bind to Record Details – repeats this element for each record in Record Details instead of using a single value.
• Start From Record – specifies the first detail record used for this element (1 = first record).
• Maximum Records – limits the number of detail records used. Set to 0 to use all available records.
• Repeat Spacing – sets the distance between repeated elements.
• Repeat Direction – determines the direction in which the element is repeated for each detail record.