Skip to main content

Word and Excel Templates

Choose Word or Excel from New Template to use a .docx or .xlsx file as a reusable print template. Edit its content and formatting in Word or Excel, insert field placeholders, then upload it to Print Design.

Upload and Replace a Template​

  1. Create a template of the required format
  2. Open Template Info, enter its name, and configure its scope
  3. Under Upload Template, click Click to Upload and select the matching .docx or .xlsx file, up to 20 MB
  4. The uploaded file appears in the list below the button; the right workspace previews the source file
  5. Save, then select a real record in Preview to check populated output

Before a file is uploaded, the workspace shows No template uploaded. To replace it, edit the document locally and upload the revised file in the same format.

Office templates use the file's layout. Set page size, margins, portrait/landscape orientation, Word tables, and Excel print settings in the source document. The PDF canvas tools apply to PDF templates.

Insert Fields​

Copy the exact API name from Data Fields and surround it with double braces. Display names are not API names. The following names are examples; replace them with names from your form.

Document contentValue used in preview
Customer: {{customer_name}}Main-record customer name
{{salesperson}}Personnel field's display name
{{department}}Department field's display name
{{product.name}}A field from a related record
{{customer_location.full}}Complete location as text

Personnel, department, organization, and relation fields resolve to their display values within the current user's access. Related fields use qualified paths copied from the field panel.

Repeat Child Rows​

Template Info → Child Tables automatically lists the current form's child tables. Copy each table's Start Marker and End Marker. The marker uses the child form's actual API name; there is no custom alias to configure.

For a child form whose API name is order_items, prepare these three consecutive rows inside one Word table or Excel worksheet:

RowProductQuantityAmount
Start marker row{{#order_items}}
Sample data row{{order_items.name}}{{order_items.quantity}}{{order_items.amount}}
End marker row{{/order_items}}

The first column above labels the example rows; do not include those labels in the document. Each marker row must contain only its single marker, with other cells empty. Put column headings above the start marker. The sample row repeats for the selected main record's child records, and both marker rows disappear from the result. Use {{order_items.__index}} for the row number.

In Child Tables, configure sorting and Print Range when needed. Print Range opens the field-filter dialog and limits the child rows belonging to the selected main record. With no child records, the result retains one blank sample row.

Related fields within a child row use paths such as {{order_items.products.name}}. To repeat a child row's related records as a separate table, use three rows with {{#order_items.products}}, {{order_items.products.name}}, and {{/order_items.products}}. Use the actual source path and a separate block; nested loop rows are unsupported. Related tables are found in Data Fields, rather than configured as extra child tables in Template Info.

Location Fields​

Print templates expose nine location parts, all strings:

PartExample placeholder
Complete location{{customer_location.full}}
Country{{customer_location.country}}
Province{{customer_location.province}}
City{{customer_location.city}}
District{{customer_location.district}}
Detailed address{{customer_location.address}}
Postcode{{customer_location.postcode}}
Longitude{{customer_location.longitude}}
Latitude{{customer_location.latitude}}

full joins the nonempty country, province, city, district, and detailed address with /, adding no spaces. Missing parts are blank; coordinates of zero are rendered as 0. These same parts work in child and related field paths.

Preview and Print Format​

The editing workspace previews the uploaded source, including its placeholders. Preview with a selected record generates the populated document. Word and Excel results use their corresponding file previews. Set Print Format in Template Info to Current Format for .docx/.xlsx output, or PDF for converted output.

The runtime print dialog uses the selected template's output and preview. Generating output preserves the reusable source template.

Ask AI to Prepare a Template​

You can upload a file and ask AI to insert form-field placeholders, or ask it to create a new Word/Excel template. For example:

Use this Excel file as an order print template. Fill the customer and location fields, repeat the order item rows, then preview it with an existing order.

AI uses the form's real field paths and child bindings, validates the file, saves the template, and generates a populated file for review. See Office print template CLI workflow for commands and definitions.

See PDF Watermarks for text/image watermarks, color, opacity, size and density. Watermarks apply to PDF output only.