• Products
    • Clik Service
    • Clik Remote
    • Clik Jobs
    • NICEIC Cert Software
    • Clik Cert Electrical
    • Clik Cert
    • Clik Cert (Field)
    • Clik AC Calc
    • Clik Training
  • Features
    • Asset Management
    • Bespoke Certificates
    • Catering Certificates
    • CRM
    • Customer Portals
    • Diary
    • Electrical Certificates
    • Engineer Portals
    • F-Gas
    • Fire and Security Certificates
    • Fleet Management
    • Gas Certificates
    • Invoicing
    • Job Management
    • Job Scheduling
    • Manager Portal
    • Mobile Job Sheets
    • Notifications
    • Planned Maintenance
    • Print Templates
    • Purchase Orders
    • Quoting
    • Reporting
    • Service Incidents
    • Stock Control
    • Third Party Integrations
    • Validation
  • Industries
    • Catering
    • Facilities Management
    • Lifts
    • Electrical
    • Plumbing and Heating
    • Air Conditioning
    • Generators
    • Building Services
    • Fire and Security
    • Doors, Gates and Barriers
    • Grounds Maintenance
    • Roofing
    • Pools
    • Cleaning
    • Renewable Energy
    • PAT Testing
    • Gas
    • Pest Control
    • Drainage
    • Telecommunications
    • Audio Visual
    • Laboratory Equipment
    • Water Services
    • HVAC
    • Construction
    • Environmental
    • Healthcare and Medical
    • Property Maintenance
    • Office Equipment
    • Carpentry
    • Fencing
    • Waste and Recycling
    • Traffic Management
  • Pricing
  • Case Studies
  • Blog
  • Newsletters
  • Support
Contact Us Try for FREE
  • Products
    • Clik Service
    • Clik Remote
    • Clik Jobs
    • NICEIC Cert Software
    • Clik Cert Electrical
    • Clik Cert
    • Clik Cert (Field)
    • Clik AC Calc
    • Clik Training
  • Features
    • Asset Management
    • Bespoke Certificates
    • Catering Certificates
    • CRM
    • Customer Portals
    • Diary
    • Electrical Certificates
    • Engineer Portals
    • F-Gas
    • Fire and Security Certificates
    • Fleet Management
    • Gas Certificates
    • Invoicing
    • Job Management
    • Job Scheduling
    • Manager Portal
    • Mobile Job Sheets
    • Notifications
    • Planned Maintenance
    • Print Templates
    • Purchase Orders
    • Quoting
    • Reporting
    • Service Incidents
    • Stock Control
    • Third Party Integrations
    • Validation
  • Industries
    • Catering
    • Facilities Management
    • Lifts
    • Electrical
    • Plumbing and Heating
    • Air Conditioning
    • Generators
    • Building Services
    • Fire and Security
    • Doors, Gates and Barriers
    • Grounds Maintenance
    • Roofing
    • Pools
    • Cleaning
    • Renewable Energy
    • PAT Testing
    • Gas
    • Pest Control
    • Drainage
    • Telecommunications
    • Audio Visual
    • Laboratory Equipment
    • Water Services
    • HVAC
    • Construction
    • Environmental
    • Healthcare and Medical
    • Property Maintenance
    • Office Equipment
    • Carpentry
    • Fencing
    • Waste and Recycling
    • Traffic Management
  • Pricing
  • Case Studies
  • Blog
  • Newsletters
  • Support
return to Support Centre

Adding Database Images to Print Templates

If you want to show engineers photos on a job sheet, this guide will show you how to do it.

There are two options, one to show all images or one to show a single image. We explain how to do both below.

 

Show All Images

First, go to the template editor by clicking Tools > Print Template Editor.

clik service tools menu drop down, print template editor

Open up the template you want the images to display in.

Click on the ‘Insert Table’ button, then click where you want to place it.

insert table icon

Set the ‘Table Name’ as ‘Documents’.

table name field

Next, go to the ‘Columns’ tab and add a standard column then change the ‘Column Format’ to ‘DBImage’.

columns tab, column format field

Once you’re done click ‘OK’.

When you print out the template you will see all the images.

 

Show One Image

This is an easier way of just showing one image.

First, go to the template editor by clicking Tools > Print Template Editor.

Open the template you want the image to display in.

Then select the ‘Database Image’ icon and place it where you want the document to appear.

You will then need to go to the properties window for the database image. Click on the placeholder, then go to the ‘Properties’ tab on the right-hand side.

Click on the ‘DatabaseField’ drop-down and select ‘Documents’.

You now will see images that have been saved on your job sheets.

Clik Service

Clik Service

Print Template Editor

Adding Action List Tables to Print Templates
Clik Service

Clik Service

Print Template Editor

Fixing Missing Footers On PDFs

Print Template Editor

  • Editing Print Templates
  • Inserting Text Boxes Onto Print Templates
  • Adding Text to Print Templates
  • Inserting Images onto Print Templates
  • Adding Your Company Logo to Print Templates
Show more

Ask Tech a Question

Did you find what you were looking for? Don’t worry if not, you can get in touch with our tech support team.

Contact Tech Support
PERSONALISED LEARNING

A Training Masterclass From Our Experts

You’ve got the software. Now get the expert knowledge straight from the experts. If you want to know more about Clik Service or the NICEIC Cert Software, maybe you want to drill down into a specific module, or a run-through for a new engineer, we’ll walk and talk you through it in the way that suits you.

Learn More

4.5

  • Products
    • Clik Service
    • Clik Jobs
    • Clik Remote
    • NICEIC Cert Software
    • Clik Cert
    • View All Products
  • Features
    • CRM
    • Invoicing
    • Job Management
    • Job Scheduling
    • Quoting
    • View All Features
  • Industries
    • Air Conditioning
    • Electrical
    • Facilities Management
    • Fire and Security
    • Plumbing
    • View All Industries
  • Support
    • Training
    • Service Status
    • Contact Tech Support
    • Product Roadmap
  • About
    • Blog
    • News
    • Privacy
    • Terms

Copyright Clik Limited © 2000-2023 – All Rights Reserved