Case 2: Printing on Physical Templates

Introduction

Feature Overview

With the feature, (Set Background Image), data can be printed with a customized format on physical sheets, accurately filling the blanck space.

Scenario

For example, when you need to print on blank boarding passes, you can upload the unfilled boarding pass image as the background of the print template, and fill passengers and flights' information into it. After this, print the information without the background on the boarding passes.

Setting Rules

1. The paper size set in the template must correspond to the actual boarding pass size.

2. The template's background image must have the same aspect ratio as the actual boarding pass.

Preview

Setup Steps

Designing a Form

Create a Boarding Pass form:

Field Description	Field Name	Field Type
The ticket number	Ticket NO.	Serial No.
The passenger's information and the departure infomation	Name	Single Line
	Flight
	Group
	Seat
	From
	Gate
	Boarding Time	Date&Time
The arrival information	To	Single Line
	Gate	Single Line
	Arrive at	Date&Time

Setting the Print Template

1. Create a new print template

Go to Extension > Print Templates > New Print Template, and select Spreadsheet Template from the dropdown. You can rename the template as "Boarding Pass Print Template".

2. Adjust the paper settings

In the template design tool bar, click (Paper Settings) to set the print paper size, orientation, and margins.

Paper Size: Select Custom and set the width and height the same as the actual boarding pass's dimensions.
Paper Orientation: Set to Portrait.
Margins: Set the Top, Bottom, Left, and Right margins to 0 mm.

2. Set the background image

Click (Set Background Image) > Background Image," and click the Upload button () on the right to upload the image of boarding pass.

Note:

1. Ensure the background image's aspect ratio matches the actual paper's aspect ratio to avoid misalignment.

2. It is recommended to scan the actual printed paper and crop any excess blank areas. This is to ensure the image matches the actual paper's aspect ratio.

3. When previewing the printing effect of the template, you can enable Print Background to check if the positioning is correct. After adjustments, disable it, for the background is not needed for actual printing.

3. Adjust the cells

Field values can only be placed in cells in the template, so the cells need to be adjusted to determine the positions of field values. You can adjust the cells according to the following steps:

First, adjust the vertical cell lines to ensure each item on the boarding pass has a cell that can be filled with the corresponding value. You can estimate the number of cells needed in one row, then move the right cell lines to the left to ensure there are enough cells.
Next, adjust the horizontal lines up and down, placing the cells in the correct positions.
Merge cells when necessary.

Note: If unsure about how to adjust the cells, you can first draw grids on the boarding pass image, scan and upload it as the background, and then adjust the lines to be aligned with the drawn grids.

4. Drag fields to cells

Drag the field values from Fields on the left into the corresponding cells:

5. Save the template and set the print scope

After setting up the template, click Save and then click Print Template Settings in the upper right corner. Configure Available Scope and Generated file name.

Demonstration

Refer to the Preview section for the effect.