Dynamic fields

Dynamic fields allow you to make reports flexible by changing how data is filtered or displayed based on a selected input.

They work by passing an input into a query, which returns a value.

For example, you can:

• Filter a report by a specific tag or collection
• Display custom data stored in metafields, attributes, or properties

This article explains the two types of dynamic fields and how to identify and use them in a report.

In this article:

• Types of dynamic fields
• Input dynamic fields
• Key-value dynamic fields
• Format key-value data
• How to use dynamic fields
• Need more support?

Types of dynamic fields

There are two types of dynamic fields. Each is used for a different purpose.

• Input dynamic fields: used to filter or evaluate data based on a selected input
• Key-value dynamic fields: used to display stored custom data

How to choose the right type

• Use an input dynamic field to filter data or check a condition
• Use a key-value dynamic field to display custom data stored in metafields, attributes, or properties

Input dynamic fields

Input dynamic fields require an input for a parameter. This input is passed through a query, which returns a value.

This means:

• You select an input (for example, a tag)
• The query checks the data
• The field returns a result based on that input

The data type is pre-defined, so no additional formatting is required.

How to identify this type

Input dynamic fields can be identified by the ‘@’ in the field display name, which represents the parameter name.

When to use this type

Use input dynamic fields when you want to:

• Filter results
• Check conditions (for example, whether something matches a value)

Example:

The field Is tagged with ‘@Tag’ from the Products table allows you to select a tag as the input.

• The input is the selected tag
• The query checks whether each product has that tag
• The field returns 'Yes' or 'No' for each product

Key-value dynamic fields

Key-value dynamic fields return a value or a list of values associated with a specific key.

These fields are used to display custom data stored as key-value pairs, such as:

• Metafields
• Attributes
• Line item properties

This means:

• You select a key (for example, a metafield)
• The field retrieves the stored value
• You choose a format to control how the value appears

How to identify this type

Key-value dynamic fields can be identified by the star icon in the field data type.

When to use this type

Use key-value dynamic fields when you want to:

• Display stored custom data
• Format that data for readability

Format key-value data

When using a key-value dynamic field, you must select a format to control how the value appears in your report.

How to choose a format

• Use Text for words, labels, or descriptions
• Use Numeric for plain numbers
• Use Currency or Unit when the value includes structured data
• Use Date or Date/Time when converting stored strings into readable dates

Available formats

Example:

The field Product Metafield ‘@Metafield’ from the Products table shows the value assigned to a product for the metafield key global.title_tag.

• The key is global.title_tag
• The stored value is retrieved for each product
• The format (Text) controls how the value is displayed

How to use dynamic fields

Dynamic fields can be added to a report as either:

• a filter (to control which data is included)
• a field (to display values in the report)

Add a dynamic field:

1. Select the field to add to your report or add as a filter
2. In the popup window:
   • Select a Parameters input (for input dynamic fields), or
   • Select a key and a Format (for key-value dynamic fields)
3. Select OK

Change an input

1. Select the field in the Selected fields pane, or select the pencil icon next to the filter field
2. In the popup window:
   • Update the Parameters input, or
   • Update the Format (for key-value dynamic fields)
3. Select OK