Merge Fields
Using variables to create dynamic labels
Merge Fields
Merge fields (also known as variables or placeholders) are the magic behind printing 100 distinctive labels from one single design.
What is a Merge Field?
A merge field is a placeholder text that gets replaced by data from your spreadsheet when generating the PDF.
- Design View:
Hello, {{First Name}} - Printed Label 1:
Hello, John - Printed Label 2:
Hello, Mary
Syntax
We use the "Mustache" syntax: double curly braces.
{{Column Name}}
- The text inside the braces must exactly map to the header in your data source (case sensitive).
How to Insert Fields
Method 1: Drag and Drop (Recommended)
- Go to the Data Source tab.
- You will see a list of available columns.
- Drag a column name onto the canvas.
- It will automatically create a text box containing that field.
Method 2: Typing
- Create a normal text box.
- Type
{{and a dropdown list of available columns will appear. - Select the field or finish typing the name manually.
Image Placeholder: [GIF showing the autocomplete dropdown when typing
{{]
Combining Fields
You can mix static text and multiple fields in a single text box.
Examples:
- Address Line:
{{City}}, {{State}} {{Zip Code}} - Price Tag:
Price: ${{Cost}} only! - Greeting:
Dear {{Title}} {{Last Name}},
Missing Data Handling
If a cell is empty in your spreadsheet for a specific row:
- The
{{Field}}will be replaced by an empty string (nothing). - The label will print without that specific bit of text.
- It will NOT print "undefined" or
{{Field}}.
Tip: If you have an address line 2 that is often empty, placed it on its own line. Our renderer will not collapse the empty line automatically yet, so consider combining it in your spreadsheet if spacing is critical.
Best Practices
- Keep Headers Simple: Rename columns in Excel to simple names like "Phone" instead of "Customer Contact Phone Number (Mobile)" to keep your design formulas clean.
- Preview often: Use the preview arrows to check for long names that might break your layout.