Template Designer
Design PDF documents and Excel spreadsheets from templates using the visual Template Designer.
Overview​
Create professional PDFs and data-rich Excel files with the drag-and-drop interface. Perfect for invoices, reports, certificates, and data exports.
Template Types​
PDF Templates​
- Use for: Invoices, reports, certificates, contracts
- Components: Text, images, tables, charts, dividers
- Output: Professional PDF documents
Excel Templates​
- Use for: Data exports, spreadsheets, reports
- Components: Tables, charts, formulas
- Output: Excel .xlsx files with multiple sheets
AI Assistance​
Use AI tools like ChatGPT, Claude, or Gemini to generate PDF and Excel templates automatically.
Generate Templates with AI​
- Provide the AI with our Template Schema Reference
- Describe the document you want (e.g., "professional invoice with itemized table and tax calculation")
- Specify the output format: PDF, Excel, or both
- Copy the generated JSON into the Schema Editor
For PDF/Excel templates, AI can generate complex features like:
- Multi-page layouts with headers/footers
- Tables with calculated columns
- Charts linked to data variables
- Conditional sections based on data
Edit Templates with AI​
Already have a template? Use AI to:
- Add new pages or sheets
- Create calculated columns in tables
- Add charts and data visualizations
- Implement conditional logic
Simply export your template JSON, share it with the AI, describe your changes, and import the updated JSON.
Learn more:
- Generate Templates with AI - Step-by-step guide with prompts
- Edit Templates with AI - Modify existing templates
PDF Designer​
Available Components​
- Text blocks
- Images and logos (select from Asset Gallery)
- Data tables
- Charts (bar, line, pie, area)
- Dividers and spacers
- Headers and footers
- Page numbers
Page Settings​
- Size: A4, Letter, Legal, Custom
- Orientation: Portrait or Landscape
- Margins: Top, bottom, left, right
- Header/Footer: Add to all pages
Excel Designer​
Sheet Management​
- Create multiple sheets
- Name sheets
- Link between sheets
Components​
- Tables: Structured data tables with calculated columns
- Charts: Visual data representation
Calculated Columns​
Use JavaScript expressions for calculated values in tables:
row.quantity * row.unitPrice
row.rowNum + 1
row.price > 100 ? 'Premium' : 'Standard'
Charts​
Available Chart Types​
- Bar Chart: Compare values
- Line Chart: Show trends
- Pie Chart: Show proportions
- Area Chart: Cumulative trends
Chart Configuration​
- Data source: Link to table or variable
- Colors: Customize chart colors
- Labels: Axis labels and title
- Legend: Show/hide, position
Adding Images to PDFs​
From Asset Gallery​
- Drag Image component onto PDF canvas
- Click the image component
- In properties panel, click Select from Gallery
- Browse and select an image from your Asset Gallery
- Click Select to insert
- Adjust size and position as needed
Benefits:
- Company logos appear consistently
- Brand assets are centrally managed
- Same asset used across all templates
- Update once to update everywhere
Upload New Assets​
Before designing, upload assets to the gallery:
- Navigate to Asset Gallery
- Click Upload
- Select logos, signatures, or images needed for documents
- Organize in folders (e.g., "Logos", "Signatures")
Variables in Templates​
Use the variable system to inject dynamic data:
Invoice #{{invoice.number}}
Customer: {{customer.name}}
Total: {{invoice.total}}
Variables use double curly braces {{variableName}} syntax and automatically appear in the Variables tab.
Designer Interface​
The Template Designer has a three-panel interface:
- Left Panel: Component Library - Drag components from here
- Center Panel: Canvas - Design your PDF/Excel template
- Right Panel: Three tabs for editing
- Properties Tab: Edit selected component settings
- Layers Tab: View and manage component hierarchy
- Variables Tab: See all variables used in the template
Layers Tab (Component Tree)​
The Layers tab shows a hierarchical tree view of all components in your template.